Chart: Different values on different pages

[LARiot]

Hi,

How do I get different dealer codes to print on separate pages? Currently they're on the same chart and thus on the same page.

Thanks

DlrCode Date SPSI
02041 01_2004 85.92
02041 01_2005 83.68
02041 01_2006 86.20
02041 02_2004 88.58
02041 02_2005 80.74
04028 01_2004 86.77
04028 01_2005 97.62
04028 01_2006 87.90
04028 02_2004 91.35
04028 02_2005 88.80
04038 01_2004 86.21
04038 01_2005 85.38
04038 01_2006 93.42
04038 02_2004 92.91
04038 02_2005 90.17
04070 01_2004 93.87
04070 01_2005 93.03
04070 01_2006 94.20
04070 02_2004 91.03
04070 02_2005 88.02

 

[dhookom]

You can possibly set your report's record source to something like:
SELECT DISTINCT DlrCode
FROM SomeWhere;
You can then use the Link Master/Child properties of the chart control to filter the results and print multiple charts.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[LARiot]

Thanks Duane,

However I need one dealer per chart not one record. All records for each dealer need to be grouped on each chart.

Can you go into more details on using the Link Master/Child. I tried adding Dealer Code to it but it blanks out my charts.

 

[LARiot]

I kinda feel silly answering my own questions but the right thing to do is to make the information available.

I created a new field under group and sorting for the report. Selected Yes for group header. Moved the chart into the group header section and added Dealer code in the details section.

 

[LARiot]

The report record source was the query this report is based upon.