Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    6

    Unanswered: Report formating

    I have a report that has a data grouped by location and then there are a list of staff names (up to 3), Staff1, Staff2, Staff3. Any of the three could have either a blank or a name for each event. I would like to be able to only show the names (not the blanks) on the report. The blanks show up as empty spaces. Is there a way to do an IIF statement or some other way to only show the fields with names without the empty space?

  2. #2
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    Create 3 groups to your report, grouped on Staff1, Staff2, Staff3.

    # Right click on the page, Sorting and Grouping, add new..

    Put the text box for Staff1, in Staff1 Group.
    Change the property of the text box to Can Shrink = Yes
    Change the property of the Group Headed to Can Shrink = Yes

    Repeat for the other groups...

    I can't guarentee this would work but it's how I managed it on one of my own reports.

  3. #3
    Join Date
    Jul 2011
    Posts
    6

    Thank you!

    That worked perfectly!! Thank you so much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •