Reports: get rid of blankpages

[mike]

Hi everyone,

I created a crosstab report and the report dynamically
displays the fields base on the data the query has. My
reports contains 10 unbound fields. The fields
displays/hides base on the query. What happen is that when
the query have two column of data,the reports displays
the two columns and hides the hidden unbound field as a
blank page. So how can I code the report to display only
the pages that have the data and cut out the blank page?

Any help is appriciated.

Thanks,

mike

 

[Duane Hookom]

There are methods that don't create blank pages. Check out the crosstab
report demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.