Crystal Reports 10 - SQL scripting
Posted on 2010-09-14
How do I change the hard code SQL query table/view listed in View SQL query in CR:
The below suggested didn't work in my case:
From the Database menu, select “Set Datasource Location”. Go to the table/view Properties. Right click "Overridden Qualified Table Name" and choose "Edit". Type the table/view name exactly as it is. This will strip down fully qualified table/view names and just display short names. (The default in CR is to dispaly fully qualified table/view names.) You can confirm the change from the Database menu by selecting “Show SQL Query” after editing "Overridden Qualified Table Name".
Note: I bringing over a crystal report that resides on another company's server, that does not have the full crystal installed, only the viewer. So, on my PC I make the corrections, and then copy the report back to their server. In order for me to test the report on my side, I have to use a different database, and when I do, the name of the database stays in the SQL script. I can not move the crystal report back to the other companies server , and run it because I get the message Table " can not be found. I look at the sql script and find the script still shows my testing database.
Any step by step suggestions welcome. I'm really a "pure" CR writer, not SQL too.