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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
extra query for 1 field
- Thread starter johnugly
- Start date
Which Crystal? In Crystal 8.5, I've done a lot of reports mixing database data with queries from Stored Procedures, which needs subreports since the two don't mix.
If it is just one data item for the whole report, that is the best way to do it. Subreports in detail lines make the report very slow, and are best avoided.
I recently re-wrote a Crystal Report and its Stored Procedure. I had been getting customer details using a subreport. But when I re-wrote the Stored Procedure to get customer details directly, the speed-up was remarkable.
Madawc Williams (East Anglia)
If it is just one data item for the whole report, that is the best way to do it. Subreports in detail lines make the report very slow, and are best avoided.
I recently re-wrote a Crystal Report and its Stored Procedure. I had been getting customer details using a subreport. But when I re-wrote the Stored Procedure to get customer details directly, the speed-up was remarkable.
Madawc Williams (East Anglia)
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question