Post reply

How to Hide Rows in a report depending on the value of the Fields ??

  • May 27, 2008 at 10:28 am

    #191509

    Hi there,

    I Tried in vain the possibility to hide rows in a report displaying, here is an example of what I need :

    I have four columns in my report table :

    "FirstColumn, SecondColumn, ThirthColumn, ForthColumn"

    I need to hide the rows in the report when the values of all the columns : SecondColumn, thirthColumn, ForthColumn are null or empty and just show the rows if there are at least one of these column value,

    i tried to use the visiblity property of the row to test with the Fields parameters but the report doesn't Work !!!!!

    this is the expression i use :

    =Iif(Fields!FirstColumn.Value ="" and Fields!SecondColumn.Value ="" and Fields!ThirthColumn.Value="", True, False)

    and the error message :

    hidden expression for the texbox "Name" contains an error : the input string format is not valid

    So I need your Help please cause i't very important for me THANK U

  • May 27, 2008 at 12:25 pm

    #820753

    is it feasible to simply filter these rows out within your dataset generation (stored proc/sql, etc)?

  • May 27, 2008 at 1:31 pm

    #820798

    No I can't do that cause if i add condition in where part of the query i could not to have a data at all, i tried it and when these parameters are null ot empty no one row will be turned at all, cause i have a 3 groupement in my report and this one is the third,

    Thanks

  • May 30, 2008 at 8:50 am

    #822368

    Hi

    You can use IsNothing() function to check column with no values

    you code will look like

    =iif( (IsNothing(Fields!FirstColumn.Value,) = False)

    AND (IsNothing(Fields!SecondColumn.Value) = False)

    AND (IsNothing(Fields!ThirthColumn.Value)=False), True, False)

    Let me know if you want to discuss it more

  • May 31, 2008 at 12:35 am

    #822626

    Hi Gohel

    I'll try that on monday and let u Know

    Great thanks 🙂

  • June 2, 2008 at 1:03 am

    #822785

    It works Great thank u Very much, ur the Best 🙂

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

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