RPT file as a Data Source-Is this possible (Reports Ver 8)

[Bratfry]

(Crystal Reports Ver 8)

Can I create a report, save it with the selected data and then point other reports to report against the data in the first report???? If so, point me in the right direction.

Gary Regez

 

[kenhamady]

No, but you can use the SQL designer to do that (see 'Save Data with Query". However, this doesn't work well within applications.

You can also export the report to an ODBC table, and then report off of that. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[krist]

Ken,
Does it mean that, if we integrate CR with other application, Direct Access to database is the best access method to use ?? compared to ODBC and using SQL Designer file ?
What are the considerations in choosing the access method ??

Thanks,
Krist

 

[MalcolmW]

I've once used the SQL Designer query files with saved data as part of an distributed application. It is difficult to configure properly. I am in the process of replacing these query files with views, as V8.5 allows me to get the performance I need with views.
Internally, the SQL Designer saves the query data to a *.dbf file. Crystal Reports then uses ODBC to connect to this *.dbf file. If you select the "Save data with query" option, then this *.dbf file persists.
You can use views, stored procedures, or direct table access. All of these work well with applications. Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net