October 20, 2010 at 12:31 pm
Hi all,
I was trying to create a report with a slight different kind of requirement,
Actually I have 5 Columns in a table from which I want the user to be capable to view the data based on any combination for those columns.
For Example:
I have a table Employee with attributes: Name / Age / Salary / STATE
Now I want the user to be capable of selecting any combination for these columns and then running the report, Actually the report will behave like a Select Query with Where clause with AND conditions for all columns.
Report design should be like this:
FIRST prompt: Select Column name ex: AGE
SECOND prompt: Select Column Value ex: 30
(now store this value somewhere and allow the user to again select a different column name like STATE, and the SECOND prompt will show all distinct STATEvalues, then user selects for ex: NEW YORK
Then when USER clicks VIEW REPORT:
Show all the employees where AGE = 30 and STATE = NEW YORK.
Is it possible ? as I dont want to create 10 prompts for 5 columns separately.
Any help is appreciated.
Thanks [/font]
October 28, 2010 at 4:31 am
I dont think in SSRS its possible. Becouse the datasets are eveluated when you click on the view report button. So, the final selection will be applicable i.e. if you have selected Age=30 at the end that will be applicable. For this also, your select query should flexible to filter out any column and its coreresponding parameter. Hope this helps in some way :-).
Regards,
Pravasis
October 28, 2010 at 7:22 am
I am not sure I understand your question. Are you asking how to use parameter inputs from 1 to 5 parameters in a query where you don't know the number of parameters that are going to be used from one execution of the report to another? Or, are you asking how to hide columns that you don't want displayed because a parameter was not selected for that column?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply