SQL Want to standardize the sql source of command file

[Former Member]

I seem to use SQL Commands more and more. I was wondering to store the commands source in such a way to minimize involvement. I have many reports date or department driven, typical drill down, is there a way to sync the sql from a server to the commands in cr so that I can change once for all Cr's?

[Former Member · Accepted solution]

Hi Paul, you can use the DataBase Expert and then save a SQL command table to the crystal reports repository. See attached jpg file.

1. create SQL Command table

2. In database expert right mouse click on Command select add to repository (crystal reports server)

-Rob

[Former Member]

Alternatively you can create a Stored procedure on the database, and then change command in each report to call the procedure.

Then in future you only need to update procedure rather than multiple reports.

Ian

[Former Member]

This would be good but in our case, the vendor does not allow me to make an SP on their database.