| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-01-07 : 16:07:52
|
| Just curious if it's possible to set a parameter where it has different category, and when the user selects a different category, it will display that report. Sort of like a report with a whole bunch of subreports. I haven't try it, but curious if this will work. So let say I pick Employee from the parameter, it will give me the given parameter for that report and then I can go to it. Then if I want Customer, I can also select Customer and then enter the parameter and then go to that report. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-07 : 17:02:55
|
| That type of thing would be up to the application. The application would know which report to call based upon the selection.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-01-07 : 18:22:22
|
| So then it's doable right? For Example:=iif(Parameters!Category.Value = "Employee", Report1.rdl, iif(Parameters!Category.Value = "Customer", Report2.rdl, iif(Parameters!Category.Value = "Misc", Report3.rdl, Report4.rdl)))Something of that nature? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-07 : 18:24:47
|
| My point was that you don't do this inside Reporting Services. Whatever application you are building to run these reports from is where you'd handle this.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-01-07 : 18:34:11
|
Chris,It makes no sense to open a report that allows you to select a report to view.You may just want a drop down combo box on your application that allows you to choose a report ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
|
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-01-09 : 12:02:20
|
| Yeah kind of like a drop down box. The thing is that I have a report that has numerous subreports. Depending on the subreport, I want different parameters to come onto the screen. So let say user choose employee, there will be parameter for EmpID, StartDAte, EndDate. If choose Customer then Cust_ID, Cust_StartDate, Cust_EndDate etc...I could choose to make these separate reports, but all these reports tied to a main report. So I want it to be kept as subreports.These reports are designed to be run in Reporting Services. Don't know how I would handle a drop down box to work as described for Reporting Services. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-10 : 12:14:27
|
| You shouldn't be designing reports like this. This is the job of your application and not Reporting Services.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-01-10 : 16:10:40
|
| I'm migrating from ASP and my users are used to having a drop down for this report. The report is tied to a topic "Gross Margin", and then within that heading are mini-reports where the user can select report that's tied to that heading. Once they enter the parameters, it applies to all the other reports. For example if they enter Parameters StartDate, EndDate, and ProductCode, it will allow the user to select each report from a drop down list. That's the reason why I want to be able to do this. Otherwise I would've just create separate reports and let the user enter the Parameters each time they want to run the report. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-10 : 16:12:23
|
| I'm confused. Don't you still have an ASP application that your users use and that ASP application hooks them into Reporting Services to view the reports?Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-01-11 : 10:34:24
|
| Yes, the ASP application does send them to the report using a Case clause. But I want everything done in Reporting Services and just have the Report Manager to host the Reports. I guess if it's not possible, I can just make separate reports, but I thought it would be more user friendly if I can replicate the old one. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-11 : 12:43:24
|
| It is not possible to have a parent report call a bunch of different reports based upon an input parameter. The subreports that you include are not dynamic.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-01-12 : 13:55:37
|
| Yeah, I guess that will not be possible. Just thought someone might come up with some way to get it working. |
|
|
|
|
Parameter to run different reports?