Multiple passes in CR 8.5

[Estandridge]

Just a quick question, is there anyway to set up a report where it reads the database multiple times in order to populate a very large report? A lot of information that I have in a current report runs through formulas based on dates in the details section and I have not found a way around this as of yet. <grins> Wish I could give a better description of what I'm attempting to do. Any information would be very much appreciated!

Thanks,
Eric

 

[synapsevampire]

You can easily give a better description:

Crystal version
Database/connectivity used
Example data
Expected output (based on example data)

You shouldn't want to read the database multiple times, that's slow.

-k

 

[chelseatech]

If you are trying to multiply out the number of records, create a counter table with a single integer field with values, 1,2,3,4,5....

I used this with a courier ticket table an did a >= join to the counter table.

You can do a similar thing with a calendar table and a record for every day last year, this year and next year.

This requires a SQL compliant db, so don't try it with old relics like Foxpro, Btrieve or Paradox.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Estandridge]

As per your request, Crystal Reports version is 8.5, reading information from MAS90/200.

The Data:
Customer Name
Customer Account Number
Salesperson Number
Divison
And sales figures for the last two years.

The Format:

Customer Name: ACCT #: Sales #: Division:

Jan Feb Mar / / Aug Sep Oct Nov Dec Tot
2003
2004
Target
Month +/-
YTD +/-
Month % Diff
YTD % Diff

The problem: When I run the report multiple tables should show up by customer for each salesperson in the company. What happens is that I get one table for one customer for one specific date instead of all of this being combined into one table. Hope that clears up a little bit of what I'm trying to do.. Thanks again!
Eric