January 27, 2009 at 7:43 am
Trying to find a way to dynamically reorder report fields at runtime. I've got a couple user-defined parameters and would like to reorder fields as needed accordingly. I can't seem to find a way to do this. Any thoughts? All fields in question are inside of a table which is inside of a list.
Thanks!!!
January 27, 2009 at 8:37 pm
If you are using SSRS you can utilize interactive sorting for the user so that they can sort the data on their own or you could provide a parameter and utilize that parameter to generate the query for the dataset to sort the data by adding in the parameter value that they select at the end of the query after the ORDER BY clause. Using interactive sorting would make it more flexible for the user though.
It really depends on what you are using to generate the reports.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
January 28, 2009 at 1:47 pm
I'm trying to find a way to reorder the columns (not rows) on the fly, based on the entered parameters. So instead of displaying columns A-B-C-D in that order, I'd like to display C-D-A-B.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply