Monday, February 20, 2012

Problem with Parameter

Hi ,

I am having a peculiar problem when i am using report parameters in a report. I am using report paramter to let the user select the month for which the report has to run, but the drop down has ordered the months in alphabetical order,for selection Is there any way I can set it to list it in the correct order ?

Thanks in advance
PMJ

If you are using an analysis services datasource, there is an easy way to solve this.

Open up your Date Dimension. Select the Month attribute. Right-click and select properties. Set the "Order By" property to key. Build and deploy your solution. Refresh the project in Reporting Services. And you will be good to go.

|||Hi Joel,

thanks a lot it worked !!!

Thanks and regards
PMNJ

No comments:

Post a Comment