Multiple pages of the same chart on a report

[ivanteo]

i'm having a problem with my reports, it seems that everytime i open a report that charts my data, there's always more than 1 page of that chart, though all i need is already on 1 page. when i print this report, all the pages will be printed.
this does not happen if i open a report with the same underlying query displaying only the data (no charts).
anybody could help me?

 

[Pat Hartman]

The chart is being produced once for each detail line in the report. To stop this, separate the report into a main report with two subreports. One subreport will contain the detail data, the other subreport will contain the chart.

 

[ivanteo]

i've tried it out but the problem i have is that my chart is obtained by a query and i have a text field which gets data from this same query so the record source of my report is [query] and the record source of my chart is [query] but it turns out that the query parameter is displayed twice, in which both must be keyed in to display the whole report, aparrently one is for the chart and the other is for the text field.
is there any way of preventing this?
been struggling with this for the whole of this week!
seems that if i do not get the multiple charts, i will get multiple parameter criteria!
any help wld be really appreciated!

thank you in advance!

 

[ivanteo]

It's alright!
i figured it out!

i only need to place the chart in the page header instead of the details.

thank you so much for your help!

 

[Steve5]

Ivanteo,

Thank-you for posting your findings, it solved my problem also!!!!

 

[Pat Hartman]

If you have a report that is prompting multiple times for the same parameters, you can stop it by using a form to pass the parameters and referring to a form field to obtain the criteria rather than prompting for it.