filter out rows in a report with hidden data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large data sheet with mulitible entrys with the same id#
i have hidden out the repeats on a report, however the rows show blank
i dont want them to show at all, so with all the blank rows my report is
like 27 pages,, but if i can get the blank rows out of the report it would be
about half.
can any one explain to me in lamens terms how to create a filter or maco or
expression so the blank or hiddens row dont show in the report
 
If your report and query are built properly, then the unneeded records won't
be there at all. Redo your query so it only pulls the needed data.

Another option is to set the "CAN SHRINK" property to TRUE for all your
controls. This wil prevent them from taking up any space if they are blank.
 
Another option is to set the "CAN SHRINK" property to TRUE for all your
controls. This wil prevent them from taking up any space if they are
blank.
Click to expand...

....all your Controls *and* Sections
 
Back
Top