Post reply

Hi Team

  • October 19, 2022 at 8:07 pm

    #4101676

    Hi am try to sort based on Parameter selection in one of my report but some how am getting an error

    Here is the expression that I use

    =IF(Parameters!USR_NM.Value = 0, Fields!RESP_RESOURCE.Value, IF(Parameters!USR_NM.Value = 1,Fields!COUNTY_NAME.Value,

    IF(Parameters!USR_NM.Value = 2, Fields!PIN.Value,IF(Parameters!USR_NM.Value = 3, Fields!ACTIVITY_ID.Value))))

    C1C2

  • October 20, 2022 at 12:11 am

    #4101732

    You might try changing your IF to IIF?  If I remember correctly Excel formulas use "IF" while SSRS expressions use VB's "IIF"  (You could also use the Switch function to avoid the nested IIFs if you wanted to.)

    Hope that helps. 🙂 Jon

    "When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me

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

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