Sorting based on Parameter values

Question

Hi, I am using SSRS 2008R2.i have a jobid param in my report which is a textbox and i am passing some values like 1,4,2,6. i want the report to be sorted in the way i passed the values to the parameter. For example if i passed the jobid's as 3,2,5 the report should be sorted in 3,2,5 order only. if i pass jobid's as 3,1,2 the report should come in 3,1,2 order. please help me in this. Thanks in advance...

Answer 1

I am not certain what you mean when you say you are passing the values to the parameter but if you are getting the values within TSQL then you could insert them into as temporary table and use the ID column in that table as the column to sort by ...

DECLARE @Sorting TABLE
    (
      ID INT IDENTITY ,
      MyVar INT
    )

INSERT INTO @Sorting
       ( [MyVar]
       )
       SELECT TOP 5 ABS(CHECKSUM(NEWID())) % 10 + 1
         FROM sys.COLUMNS

SELECT *
    FROM @Sorting AS s
    ORDER BY id

go

DECLARE @Sorting TABLE
    (
      ID INT IDENTITY ,
      MyVar INT
    )


INSERT INTO @Sorting
       ( [MyVar] )
    VALUES  ( 3 ),
         ( 6 ),
         ( 1 ),
         ( 2 ),
         ( 9 )


SELECT *
    FROM @Sorting AS s
    ORDER BY id

Sorting based on Parameter values

Follow this question

Related Questions