Post reply

Multiple parameter

  • May 14, 2014 at 1:51 pm

    #396755

    I don't know if this is possible in SSRS but i want to display the same report but with different orders.( This is main report only , No Subreport)

    Display report by DeviceClass

    Display by DeviceName

    Display by Manager

    But I need to select the parameter right in the beginning and then if I select DeviceClass , It should bring in the report (below) with DeviceClass grouping and similarly with others.

    How should I define the parameter and pass the values.. IS it possible?

  • May 14, 2014 at 3:14 pm

    #1713636

    You can do conditional sorting either in SSRS by using an IIF expression in the sorting properties for your Table/Tablix, or in SQL by using case statements in your ORDER BY (rough example below). If you want conditional grouping, you might be able to use case statements in your SQL GROUP BY, though I admit I have never tried that and don't know if it will work.

    ORDER BY

    CASE WHEN @Order = 'DeviceClass' THEN DeviceClass END,

    CASE WHEN @Order = 'DeviceName' THEN DeviceName END,

    CASE WHEN @Order = 'Manager' THEN Manager END

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

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