Skip to Content
avatar image
Former Member

How to set Datasource pointing to multiple Database at the time crystal report creation

I need to create a crystal report and have to set Datasource location pointing to Development, Testing and Production servers. The created crystal report will be placed in database table and fetched at the time of reposrt generation by passing the credentials(Development or production).But whatever Datasource given at the time of creation it is pointing to that only cant able to change the datasource through the code. Please help me in this I need a crystal report generated with multiple datasource connection.

In C# I have written code as shown below:

oReport.SetDatabaseLogon(gcUser, gcPassword, gcDB, gcDB);
 oReport.DataSourceConnections[0].SetLogon(gcUser, gcPassword);
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 12, 2017 at 03:18 PM

    On the Download page WIKI use this test app to set location in code as an example:

    https://blogs.sap.com/2016/02/17/how-to-parameters-in-crystal-reports-for-visual-studio-net/

    Don

    Add comment
    10|10000 characters needed characters exceeded