Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jgilston
Starting Member
1 Post |
 Posted - 2009-01-27 : 13:42:07
|
| I am looking to have a list of columns as the parameters and allow the user to pick which column he or she wants to display. I can then use the "allow multiple values" option on the report parameter properties window to display multiple columns. I know how to set the column names as possible parameters but I do not know how to have to columns that they choose go back into the query and display the value and title of that column. Basically the query would be defined based on the user's choices. For example:I would like a persons name and the year to show up and if someone checked the a parameter called "weight" the title "weight" would come up and below it the appropriate number would appear. Thanks for your help. Please let me know if there would be a certain style of query that I would have to write to allow this to happen. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 12:45:07
|
| i think what you can do is display all parameters with value not applicable first when report comes up. then, based on what value you select for choice parameter, populate the corresponding parameter combo with values.this can be done by passing value of choice parameter to query populating dataset of other parameters. |
 |
|
|
|
|
|
User Defined Report