Sorry if this has been asked before but I couldn't see anything similar from a search of the forums.
I'm trying to filter reports using two parameters set up in the data tab of report builder in VS 2005. I want to filter on month and year, and when I set these filters up in the data tab VS creates the two report parameters for me. When the report is previewed or deployed, the year parameter drop-down list is in the correct order, but the month parameter drop-down list is in alphabetical order (April, August, December, etc).
I have set the time dimension up, with the hierarchy year>month>date. Is there any way to force the months into their correct order? I have created parameters of my own to do this, but the ability to select more than one item with the VS-generated parameters would really enhance the reports I am building.
If anyone can help or post links to resources that'd be great - Many thanks.
If you don't mind having all months appear all the time, you can open the report in VS Report Designer and change the parameter's ValidValues property from a query to a static list of values in the correct order. The report may not re-open in Report Builder afterwards, or if it does, the ValidValues property will be reset to a query, so be aware of that.
No comments:
Post a Comment