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 |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2008-08-05 : 14:03:56
|
| I have 4 datasets for 1 report.I have @Endtime and @Enddate ,@Group for all datasets. I created parameters for it. I want all 4 datasets to catch the parameters When i run the report. Do i have to create Store procedures for all datasets?How to map parameters accross all 4 datasets so all of them can use? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 14:10:53
|
| You must give the source for all the datasets as your query/ procedure whichever you're using. then run each dataset by giving some random values for parameters and on refreshing it will automatically take the params from your query and create corresponding ones in report and maps them. |
 |
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2008-08-05 : 14:14:38
|
| But it is not mapping accross all datasets:For Eg: @Enddate should be same accross all datasets.I tried doing that already but didn't help . |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 14:16:34
|
quote:
Originally posted by SCHEMA
But it is not mapping accross all datasets:For Eg: @Enddate should be same accross all datasets.I tried doing that already but didn't help .
what do you mean by across datasets? you need to run query for each dataset individually for getting mapping. |
|
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2008-08-05 : 14:22:00
|
| Here is scenerio:I donot want to use too many parameters. so In Ist dataset: I have other parameters too like @startday, so i am usingDeclare @startday char(4)set @Startday = (select right(@Enddate,2) and i wanna do same for other datasets too. |
|
|
|
|
|
|
Mapping problem in Reporting service: