Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(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

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

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
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

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

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 ??


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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close