Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Query
- Thread starter DLawyer
- Start date
A crystal query is from the Crystal SQL Designer program - cqw32.exe. A Crystal Report is from the crystal reports program - crw32.exe.
With a query you are limited to OBDC databases. If you have several Crystal Reports that use the same raw data, you can write one crystal query and base the report on the .qry file, which would keep you from re-reading the entire database every time you ran the crystal report(s). This is the way I have used this tool most often.
However if you are a SQL guru you can just write a stored procedure and base your reports from there.
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
With a query you are limited to OBDC databases. If you have several Crystal Reports that use the same raw data, you can write one crystal query and base the report on the .qry file, which would keep you from re-reading the entire database every time you ran the crystal report(s). This is the way I have used this tool most often.
However if you are a SQL guru you can just write a stored procedure and base your reports from there.
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question