Crosstab Report

[Reggie]

Hi and TIA! (A2K) I have a report based on a crosstab query. There's a
possibility of 52 columns across the page. The report opens and fills the
controls with data and hides those that are not being used. This works fine
however the blank pages still show up. The weird thing is at the bottom is
shows Page 1 of 4 (the number of pages with data) but there may be 16 pages
including the blanks. The other weird thing is when I actually print the
report the 16 pages come out blank. Any clues and/or suggestions is
appreciated. Thanks for your time.

 

[Duane Hookom]

I recommend you take a look at the crosstab report demo at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. You can easily create
any number of dynamic columns with this solution. There is much less code
than other crosstab reports and it runs faster.