on 05-24-2011 11:08 AM
Hi,
I would like to manually change the SQL statement that Crystal Reports 2008 generates (I am using several Oracle tables and views in my reports).
Where is this possible? I can show the SQL statement in the database menu but can't modify it there.
Thanks!
hi,
Go to Database ->Database expert. On Right hand side, under Selected Tables,
select the data provider and right click, you will see the option "Edit Command".
Regards,
Vamsee
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Steve,
After CR 8.5 yo can no longer edit the SQL directly. What we did was to create a Command Object which allows you to paste in or write your SQL. The REprots then use it as the data source.
As Ian suggested, open up your existing reports, copy the SQL from the Show SQL menu option. Create a new report and in the Database Wizard you'll see a Command. Select it, paste in the SQL and then copy the Objects from the old report into the new report.
Unfortunately there is no Set Location option to go from a report based on a direct connection to a Command object. Only way is to recreate your reports.
Thank you
Don
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.