Skip to Content

CR4E - How to change database for a report, in which report query is added from sql file.

Feb 09, 2017 at 09:17 AM


avatar image
Former Member

In CR4E, I have developed a report using SQL command object, i.e I have created a SQL file with required sql query and added that file to my rpt file using the following option.

Right click on sql file, Crystal Reports > Add To Existing Report

After completing my report now I need to modify the database connections details in my report.

When I use "Set Datasource Location" option, it discards all the fields from the layout.

Can anybody please help me in changing the data source with out modifying my report.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers