inserted One chart.. got four.

W

WebDude

see.....

i created a new report and based it on a tiny simple parameter query.
With nothing on the report i then slapped in a small chart...and i must say
the chart looks niiiiiiiice :) ..but everytime i preview the report THREE
copies of the same chart are displayed over two pages.

What have i done to deserve this flavorless Manhatten!
simpsons quote.
 
R

Rick Brandt

WebDude said:
see.....

i created a new report and based it on a tiny simple parameter query.
With nothing on the report i then slapped in a small chart...and i must say
the chart looks niiiiiiiice :) ..but everytime i preview the report THREE
copies of the same chart are displayed over two pages.

What have i done to deserve this flavorless Manhatten!
simpsons quote.
Click to expand...

Does the report have a RecordSource? Normally a report that displays nothing
but a chart would not have one (the chart would). If the report has a
RecordSource with four records in it and you place the chart in the detail
section then you will get four copies (one for each record).
 
W

WebDude

How come you got all the brains in the family? :-O

Once again, you were right. After i removed the reports record source the
duplicate charts then dissapeared.. and im now left with one fabulously sexy
pie chart. :-DDDDD

Um.. The reports' record source (which was the same as the chart btw) was a
parameter query whose parameters i had conveniently displayed on the report
itself using a simple lonely text box. But now :-( the text box wont display
them para-meters no more... so... i... was.. wondering... me being new to
parameters and all ... how might i get those parameters to show up again? :)
:)

parameter!
boo!


WebDude



Wrote "WebDude" ;
i created a new report and based it on a tiny simple parameter query.
With nothing on the report i then slapped in a small chart...and i must say
the chart looks niiiiiiiice :) ..but everytime i preview the report THREE
copies of the same chart are displayed over two pages.

What have i done to deserve this flavorless Manhatten!
simpsons quote.
Click to expand...



Replied Rick Brandt :
 
R

Rick Brandt

WebDude said:
How come you got all the brains in the family? :-O

Once again, you were right. After i removed the reports record source the
duplicate charts then dissapeared.. and im now left with one fabulously sexy
pie chart. :-DDDDD

Um.. The reports' record source (which was the same as the chart btw) was a
parameter query whose parameters i had conveniently displayed on the report
itself using a simple lonely text box. But now :-( the text box wont display
them para-meters no more... so... i... was.. wondering... me being new to
parameters and all ... how might i get those parameters to show up again? :)
Click to expand...

You can restore the RecordSource if you like. Just put the chart into a section
that only runs one time instead of a section that runs once per record (like the
ReportHeader).
 
W

WebDude

Rick asnwered;
You can restore the RecordSource if you like. Just put the chart into a section
that only runs one time instead of a section that runs once per record (like the
ReportHeader).
Click to expand...



Thanks again rick!!!!!
 
Top