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 |
|
mikemadison
Starting Member
12 Posts |
 Posted - 2011-09-07 : 11:15:24
|
| Hi,Generally speaking, can both a parent report and a subreport access data from the same tables (as a shared dataset) in SSRS 2008 R2? Any information or insights would be greatly appreciated.Thanks,Mike M. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-09 : 08:21:52
|
| nope. not from same dataset. you've create separate datasets in both reports which forms both parent and child reports. but my question is whats the need of dataset in parent unless its showing some other data other than that shown by child------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-24 : 05:34:36
|
| Hi visakh16,what if my main report is the detailed report and my sub report is the summary and i use separate datasets but the content of the dataset is the same. or i need to modify the contents for the sub report because it only need 3 fields.example:main report(detailed)fields 1,2,3,4,5,6,78sub report(summary)fields 1,4,5- i have to sumarize based on 1for summary do i need to modify the query. because i create sub report the query from main report and the query from sub report is the same on the dataset name is different.regards, |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 06:00:32
|
| no need. you can use same query and apply grouping on it at report level------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-25 : 01:15:04
|
| The parameter that i used in Main report do i need also to replicate to my sub report?It's oaky if i will add my sub report ater the page heading or page footer?Btw, do you know any link to study SSRS especially Subreport. Thanks.Regards,JOV |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 04:19:17
|
| if you want to apply same filter means you need to create it in subreport alsoyou need to add subreport to report body part not in header or footer------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Parent and Subreports