Setting visible to "No" causes performance issues

[jen89]

I am working on a report that does some extensive grouping and sums.
I use one level of grouping (customer number), then I do some sums and counts within the detail section. (I count invoices, and sum up the total revenue for each invoice.) I would like to see only the totals for each item, and they are displayed in the group footer

abc corp       $80,000
def inc.       $39,000
ghi corp       $99,100

The report works nicely, except that if I set the detail visible property to "no", the performance slows down considerably. (15-20 seconds for each page viewed.) If I instead leave it set to "yes" but shrink the detail section down to nothing, the performance issue is cleared up, but the footers only count the first record for each group. I would appreciate any insight on this problem. Thanks in advance,

Jen

 

[randysmid]

Hi,
Is the report based strictly on a table, or a query? The report should be based on a query, and the query should pre-sort the records into the order needed for the report. See if that makes a difference. HTH,
Randy Smith
California Teachers Association