Skip to Content
0
Former Member
Feb 27, 2009 at 03:32 PM

Switching Command Windows on Existing Report (need to use new ODBC)

25 Views

I have a report built with SQL code in a Command window based on ODBC connection #1. However, I need to change the report to call ODBC connection #2 for a different set of users. How can make this change and still retain the existing report layout?

I tried renaming the original Command window to Command1 and then created the new ODBC connection and duplicated the code in Command1 into the new Command. I had hoped that I would then be able to removed Command1 to faciliate the switch. This did not work as Crystal had already changed the field names to Command1.######.

I also tried the " find and replace" feature for formulas but this does not appear to work for field names. Does anyone have any suggestions of how to make this modification without having to rewrite the report?

Thanks for your help!

David