I created a dynamic report and the fields is displayed
base on the query. The report contains about 34 fields so if the query has
34 fields, all
34 fields in the report shows up. But if the query has 10 (which most of
them have) fields, the report only shows 10 fields and hides the rest.
What happen is that when I go to print preview, its shows
the pages that have the fields and the blank page. The
blank page infact are the hidden fields. My problem is
that, how do I tell the print preview to display only
the pages that have the fields and don't show the pages
that contain the hidden fields.
Thanks
JJ