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.
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.
View Complete Post