Can Shrink feature

[DeborahP]

I figured out a way to HIDE fields if they do not meet a certain criteria on a report and I have used the can shrink figure to squeeze everything together, however, I still have some big gaps in the report. Is there anyway to remove all the "spaces"?

The reason for the HIDING is that I could not filter the data because I created a calculated field on the report and if the person was noted as "COMPLETED", I did an event and hid the fields so the information would not appear. I made a simple report sorta complicated but it works except for the extra white spaces.

Thanks,
Deborah

 

[DeborahP]

I did all that you stated and it still did not work correctly. I had to go in and generate an ON print event and use the following:

If done = "completed" Then Me.NextRecord = True
If done = "completed" Then Me.MoveLayout = False
If done = "completed" Then Me.PrintSection = False

It worked like a charm!

Thanks for all the help.
Deborah