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 |
|
matta0990
Starting Member
44 Posts |
 Posted - 2011-09-13 : 04:12:55
|
| Hi, I’m trying to create 15 reports all based on the same dataset but using different filters to change the data displayed. Currently I have created my own navigation bar using hyperlinked text so when click you are navigated to a different report. So, I have 15 separate reports.... Is there any way that I can get them all into one report? This would have worked fine until I needed to enter parameters and its VERY frustrating having to enter them every time I navigate to another report.ThanxJ Smith |
|
|
matta0990
Starting Member
44 Posts |
Posted - 2011-09-13 : 04:15:07
|
| Oh, anouther quick question,... this could be solved if there was a way in which when i clicked a button or something the filter on the report changed.... is this possible?J Smith |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-13 : 04:30:27
|
| why should you need 15 reports? if data to be shown is same why not use same report and by means of parameters apply your filter for 15 conditions. while calling specify in url your parameter values and based on values it will determine what data to be displayed------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
matta0990
Starting Member
44 Posts |
Posted - 2011-09-13 : 04:36:21
|
| because the users of the report do not know what parameters to enter to retrieve the data they need. This is why I created a navigation like list so they can just click on the link to take them there. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-13 : 04:41:05
|
| nope. no need to provide users with parameter tab. make the parameters hidden and give them just report links that have the parameter values set already in them as query string parameter values ( I assume you will know before hand what values to be passed for each of 15 conditions for the parameters)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
matta0990
Starting Member
44 Posts |
Posted - 2011-09-13 : 05:08:48
|
| but if i use report links, wont I have to create separte reports to link to? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-13 : 06:15:13
|
| nope. you can create link with same report itself but with varying values for parameters------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Multipule reports within one report???