CODEWITHSUNDEEP
ssrs-2008reporting-services
Neo
Neo

Reputation: 16219

How do I change order of parameter in SSRS

I'm working on SSRS reports and unable to change order of parameter which is coming into dropdown list please help me

=First(Fields!PortfolioName.Value, "PortfolioName") & " : " & Switch
    (
     Parameters!SourceID.Value = 13,
     "Official",
     Parameters!SourceID.Value = Nothing,
     "Internal" ,
     Parameters!SourceID.Value = 15,
     "Broker Dealer"
     ) & " Pricing"

gives id and porfolioname

for better understanding i paste a image here.

I want default value to be official at top

Upvotes: 0

Views: 1317

Answers (1)

rashkay
rashkay

Reputation: 824

I am assuming that the Pricing Source info is available in another table called "PricingSource".

(1) Use the following query to fetch pricing info data :

SELECT PricingSourceID, PricingSourceName
    FROM PricingSource
    WHERE PricingSourceId
ORDER BY CASE PricingSourceName
WHEN 'Official' THEN 1
ELSE 999
END

(2) Now use this query in another dataset and utilize this dataset in "Available Values" for the parameter "Pricing Source" in the SSRS to populate the dropdown list

Upvotes: 2

Related Questions