Skip to Content

changing data source type

We would like to programmatically change the data provider used by a report. Currently we are using ODBC and we no longer want to depend on the this middleware. Is possible to programmatically change the objects within the report's report document object to use a direct data connection or OLE DB connection? We would rather not change them through Crystal Report's designer if possible due to the number of reports that we would have to change.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 27, 2017 at 09:30 PM

    Hi Ben,

    Actually ODBC is the new standard. I suggest staying on it.

    If you want to use CR for VS .NET go here:

    https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

    requires VS 2010 -> 2015:

    And post your questions to this Forum

    https://answers.sap.com/tags/01200615320800001270

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Don,

      The choice to be off ODBC is not my choice and it is not my place to "sell" that ODBC should be in the future. This is coming higher up the management chain.

  • Jun 28, 2017 at 06:16 PM

    Hi Don,

    Thank you for the reply.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 28, 2017 at 06:50 PM

    Hi Don,

    I reviewed the content of the links that you provided, but they are not answering the question about programmatically change the data provider of a existing report. I appreciate the merits of ODBC, but I need to be able to change the data provider type. Anymore insight would be appreciated.

    Add comment
    10|10000 characters needed characters exceeded