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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-02-10 : 09:29:37
|
| I'm wondering if it would be possible to create a static drop down list to run certain report base on what the user pick.For example I have 3 reports that's similar in a way but shows different information. If the user clicks on whatever it is on the drop down I want it to take them to that report and run it.I tried this conditional expression, but no luck.=iif(Parameters!Reports.Value = "Sales", "Sales_Report", iif(Parameters!Reports.Value = "Cost", "Cost_Report", "Gross"))The error I'm getting is "Error during processing of 'reports' report parameter". I put the conditional expression in the default values of Report Parameters and I think this is not the right place for it. Any other place I can put it in? |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-02-10 : 09:35:18
|
| Weird how the post got repeated.I got it to work now. I set it up in the Dataset under the Parameters tab. I just use my parameter there and use the conditional expression. |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-02-10 : 09:52:49
|
| I thought that it worked, but guess not. It seems to run the report, but the same report only.Anyone have any ideas? I can create a mainreport with links to those other reports, but I think a drop down would like nice. |
|
|
|
|
|
|
Dynamic Parameter to run reports?