change table datasopurce without modifying report

[jsnunez]

Hi all

I am currently using Crystal Reports 9.2 and I have created a report that works with an Access query. I would like to change the report from working with quuery1 to query2 and both queries have the same fields.

Thanks
jsn

 

[hilfy]

If you're running your report through a program that you've written, you can do this without modifying the report - we'd need to know what language you're using in order to be able to give you specific help.

However, if you're just running the report in Crystal, you'll have to modify the report itself. In the Database Menu, select Set Location and point the data set to your new query. When you're done, you may also want to select "Verify Database" from the Database menu to make sure that all of your field definitions are correct.

-D

 

[synapsevampire]

Select Database->Set Locationa nd point to the other Query.

If you used the Add Command, then you can edit the Database->Verify Database

-k

 

[SFLLC]

If you don't mind a third party utility, our new .rpt Inspector 2 Professional Suite now comes in two editions. One that supports CR5.x-CR8.5 and one that supports CR9.x. Everything else in the two editions is the same. Including support of a new "data source / database conversion and migration wizard" which allows you to select one or more reports and select multiple sources to a destination for set location, convert driver, verify database. And we support ODBC / OLE DB / Native DB2 / Native Informix / Native Oracle / Native SQL Server / Native Sybase.

Both editions are now available for a FREE 30-day trial download.

Software Forces, LLC

http://www.softwareforces.com

===> two editions released: ".rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)" and ".rpt Inspector 2 Professional Suite (for CR9.x)"
=====> download your FREE 30-day trial today!

proud makers of ".rpt Inspector" brand for Crystal Reports,
"SPL (Smart Pick Lists)" for Crystal Enterprise, and "SmartObjects" for Seagate Info & Crystal Enterprise.

Coming soon ".rpt Inspector 3 Enterprise Suite" for Crystal Enterprise