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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden text in tables causes empty rows 0
Filtering subreports on main report 0
Rows in a report 2
Completely Blank Report...no title, data, etc. 3
Report with fixe number of records 1
Using CanShrink 1
Bound Chart in Report Issues - Access 2007 4
Counting records in group in Details view 4

Back
Top