Two lists in the body of a report

  • I have created two lists in the body of a report.

    I am using the following expression to make visible

    List1

    =iif(Fields!Age.Value >=5,False,True)

    List2

    =iif(Fields!Age.Value <5,False,True)

    The problem is that the non-visible list prints a blank page.

    The lists are contracts with lots of unique boiler plate language and the data (name, address, dob, emergency contact etc)

    In the properties of the each list I tried "Fit this list on one page if possible" with no luck.

    Any ideas?

    Thanks

    Matt

  • Unfortunately hiding objects in SSRS does not remove them when you are printing so you get the blank page.

    If the lists are so similar couldn't you use conditional logic within the lists to show the data that changes based on your criteria? Then it is one list object and will eliminate the blank page.

  • Good idea, I would have to reformat in order to use conditional text.

    What about two subreports? Subreports can grow and can shrink.

    Thanks

    Matt

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply