>I have a report with over 50 columns. I would like to know how to set a max number of columns per page in the cross-tab query and make it skip pages
>
>Thank you
>Perry

Check out our product Bull's Eye Reports. It has a feature called multiple horizontal pages that was designed specifically for cross-tab reports. You add as many fields (columns) to the first page as you can and when you run out of room you just add another horizontal page and keep going. This can be done via the user interface or code. You can download a fully-functional demo at http://www.uspioneer.com/download.htm.