ssrs 2008 report parameters
-
In an existing SSRS 2008 report, I am adding a new tablix and a new dataset to the rdl. This new report has more parameters than the original report uses. When the new version of the rdl runs, the user will be able to pick what report they want to run. When the new report runs, there are 5 more report parameters than in the original rdl.
Thus can you tell me if there is a way for the 5 additional parameters to only show up, then the new report (tablix) is used? If so, can you tell me how to show those parameters only when that new report is executed? If not, can you tell me what I suggest to the user to they can let these 5 parameters are only used for this new report?
-
I'm pretty sure that's not possible, at least within SSRS anyway. The only way you could achieve that I can think of, would be via a web page with a Report Viewer control in it, and the web page would then control which report shows up in that control via the web pages report selection drop down, and not something within the Report Viewer control.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
So the only thing I can do is on each parameter is to say this parameter value is only used for the 'new' report as part of the parameter name that is displayed?
-
This sounds like what your trying to do is make some parameters display only if required, but if they are making them compulsory. SSRS does not support "optional required" parameters, they are either displayed or they are, and they are either optional or mandatory; they can't be in a state of flux.
Personally, I'd suggest using 2 completely separate reports. if they require different parameters, it implies that they are inherently different, meaning that the reports should be to.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
What you can also do is create two separate reports for the two that you have.
Then create a third one to act as an 'portal'. On this report you can just use text boxes and enter the names of those two reports. Then go to properties of each text box and go to action. On action you can then choose either go to report or go to url where you can specify the url of your report on your report server.
See below pictures as reference. I don't have an working example at this stage.
- wendy elizabeth - Wednesday, October 4, 2017 3:16 PM
Nope. Like Thom said, any given parameter is either optional or it's not. You can't have it both ways. Reinhard suggests another alternative, but that's not going to really benefit you in any meaningful way. One other thing you might be able to do, is have each report be a subreport, but then you'd need ALL the parameters in your main report, and the optional vs required thing becomes a problem unless you can go ahead and provide a default value for any required parameters of the report that has more of them and simply not use them in the report with less parameters, but as these are now subreports, you end up having to control visibility of each one, and realize that you'll always end up running the queries of both reports no matter which one you actually want. Just doesn't make a lot of sense to invest all that extra effort.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
I like the idea of having a third report that lets you select 1 report or the other report. However how about if the user wants to select both reports to run. How would I set that up?
-
Build your own web page and have multiple report viewer controls on it. Those kinds of functionality aren't likely to show up in SSRS any time soon.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply