Change the data source of a Crystal Report (V8) 1

[TudorSmith]

Hi,

I have a report based on a query that I built using Crystal SQL Designer. I subsequentaly saved the query, and built the report based on that Data source.

Now I find the report will run better using the SQL directly embedded into the report. any ideas on changing the data source from the query to just the SQL?

birklea birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!

 

[rogar]

Sorry, you can't change the data source for a .qry based report to anything besides another .qry file. You will have to create a new table (or stored procedure) based report using the old report as a pattern. It may help to open both reports in the same CR design window and select Tile Horizontal from the windows menu so you can see both at the same time. First place your table fields in the same alignment as in the old report, then copy and paste headers and other text fields. You can copy and paste formulas but datafield references will have to be edited from {Query.Field} to {Table.Field}. It's picky but doesn't take very long, unless you have a lot of reports to convert.

Ask yourself if the performance gain is worth the trouble.
Remember, too, that a change in the database table structure, such as inserting or deleting a column, can break a table based report without warning. A query-based report is protected against such changes.