Bar chart report has 41 pages when it should only have 1

[cravincreeks]

Hello all,

I have a bar chart in a report that is based on a query. I manually stretched the bar chart so that it fills most of the 8.5" by 11" page (if it were smaller, it'd be difficult to read). The bar chart renders correctly, but there are 41 pages in the report, all with the same exact bar chart. It's like the first page gets duplicated 40 times.

I plan to print these charts to a printer via a macro, VBA, or VB.net. If this code prints the report as is, then it'll print 41 pages when it should only print 1.

Any idea why this is happening? I've looked through all of the properties for the form, but didn't find one that may be causing the problem.

Thanks

Alex

 

[dhookom]

I expect you have a record source of your report that should be removed. If your report only contains the chart, the report should generally not have a record source.

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]

 

[cravincreeks]

That fixed the problem. Thanks