Post reply

How to hide a block of header text when list contains zero rows

  • July 9, 2004 at 4:21 am

    #180816

    On my report I have several Lists, drawn from different Data Sets. Each list has a block of static text above it describing what the list is. If any of the lists contain no records I want the static text to disappear. How do I achieve this? An alternative would be to keep the static text and then display 'No records found' underneath. How could that be done?
     
    Thanks

  • July 9, 2004 at 5:40 am

    #514038

    Laurence,

    What reporting tool are you using??



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 9, 2004 at 5:45 am

    #514040

    I am using Reporting Services - is that what you are asking? This is the Reporting Services forum, right?

  • July 9, 2004 at 4:02 pm

    #514180

    I was curious.  A lot of questions are mis-posted....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • August 3, 2004 at 6:31 am

    #517422

    I just saw this posted, sorry if you already found the solution.

    right click on the text box you want to hide

    choose Expression

    in the expression box key expression like =IIf(test value is nothing, "Leave blank", "Else type this text")

     

    example

    =IIF( Fields!ProjectTypeID.Value = nothing , " " , "Total for Project Type: " & Fields!ProjectTypeID.Value)

     

     

     

  • August 3, 2004 at 12:14 pm

    #517506

    Yes that solution is very similar to what I came up with, thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

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