Post reply

Group Header/Footer Expression for NULL

  • August 29, 2005 at 3:10 pm

    #114859

    I have a group header from records in a child table.  My DB schema is a two table/left outter join.  When my parent table has no records in the child table, I'd like the group header to say something like "No associated Records".

    I know how to do this with Crystal Reports, but can't get it figured out with SRS.

    Thanks!

  • August 29, 2005 at 5:27 pm

    #586020

    Can you post your work in progress query. It will be easier to work on it

     

    Kindest Regards,

    Amit Lohia

  • August 30, 2005 at 1:42 am

    #586057

    Well u can create a table row with the massege u want and add to the visibility property this code:

    =iif(Fields!Group3.Value is nothing,False,True)

    and for the other table rows the opozite.

    another option is use the table property->NoRows

  • August 30, 2005 at 8:04 am

    #586139

    ofir shoval,

    Thanks!  That's what I found to do in my book!

     

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

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