Post reply

Need IIF condition based on a cloumn in SSRS

  • January 27, 2014 at 2:03 pm

    #303502

    Hello,

    I have a report (please see the attachments of screenshot.png and database)

    I am new to SSRS report; not understanding in the design view what I need to take either a table or list and how can I group the data

    If you open database.png;there is aLookupvaluename column in that based on Labor(need to write IIF condition; like if labor then populate VendorNo information and right side is inoviceamt information data below) we need to pull data

    Not sure how to group the data any help?

    Can any one check for Operating Labor in Screenshot.png and database.png and tell me how I can design the data?

  • January 27, 2014 at 3:05 pm

    #1683732

    need to write IIF condition; like if labor then populate VendorNo information and right side is inoviceamt information data below) we need to pull data

    If Labor THEN what?

    Sounds like you could make the column visibility be based on an expression...

    open the report in design view, click on the column, then properties, then select Visibility (or maybe Visible... too many years mucking with VBA!)

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

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