hiding some fields in SSRS 2005

  • hi i have a table

    Lname Fname Amt

    abc xyz 1

    pqr abc 2

    rhfa abcd 10

    zyes yeds 2

    i want the report to appear as

    Lname Fname Amt

    abc xyz 1

    pqr

    rhfa abcd 10

    zyes

    i want to hide Fname and amt fields when amt=2

    how can this be done?

    thanks in advance..!!

  • Where are you trying to hide this?

    In a staging table?

    In a cube?

    In a report?

  • If you want to hide it in the report, then use a filter.

    If this does not work, then use a conditional statement.

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

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