June 8, 2011 at 3:37 am
I have a report, based on a View in the database. The View comprises a number of UNIONs.
Two of the columns returned are Year (int) and Username (varchar).
Both of these are used as Prompted Filter Criteria, so when the user gets the report they have to choose a year and Username to generate the report.
The ordering of the values in these prompt drop down lists is not right.
I can address this by ordering the View by either Year then Username, or vice versa, but either way - the ordering of one list is nit right.
I cannot see a way to order these two lists so that both are ordered properly.
I would have thought it would be possible with SSRS, and I appreciate the data comes from the underlying report dataset and model, but I thought some form of sub-dataset could be created behind the scenes by SSRS to allow ordering, or similar, but I can't seem to find a way.
I imagine others must have run into thsi as well, so my question is - can anyone help?
Thanks a lot
Ian
June 18, 2011 at 4:05 am
Has no one else had this problem at all?
I'm beginning to think it isn't possible to work around.
June 20, 2011 at 7:35 am
Make a separate dataset for each parameter and sort that dataset the way you want. From what you wrote I assume that you are basing your parameter data on your primary report dataset. There is nothing wrong with this, other than the problem that you point out, and frequently it can take a little too long for the parameters to appear. Writing separate dataset queries for each parameter offers you an opportunity to make those queries more efficient for the purpose of feeding the parameter than the primary report dataset.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply