different query for each page???

[99mel]

Hi all,

Is it possible to make a different query for each page?

I have a chart on each header of each page for 1 product. In the footer of each page i want a breakdown of the chart. The problem is that the whole report is bringing in the records for ALL the products. I just want the one product (depending on the chart) on each page.

Any help much appreciated!!

Mel

 

[kenhamady]

Have you grouped by product and set a page break after each group footer?
What are your group fields? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[99mel]

hehe sorry. I got confused it was a 3D chart with 3 values. So i had 2 groups! one was surpressed so i sorta forgot about it. It works lovely now

Thanks anyway!