Solved

Access SubReport data from main report in Reporting Services

Posted on 2009-07-06
4
579 Views
Last Modified: 2012-05-07
I think the title says it all, i'm using version 2005
0
Comment
Question by:CurtinProp
  • 2
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
As far as I know there's no way to do this.  You can pass data via parameters to a subreport but not in the other direction.  If you need the same data in the main report, you'll need to repeat the dataset there...
0
 
LVL 2

Author Comment

by:CurtinProp
Comment Utility
I want to parse just single values back to the sub report, so I can do some totaling.

subreport has 3 rows, but main reports has 1

e.g need to get total value from all 4

Possible?
0
 
LVL 37

Expert Comment

by:ValentinoV
Comment Utility
If it's the subreport that should show the total of those 4 records you could pass the values from the main report to the subreport using parameters.  But, if it's only 4 records, why would you want to make it complicated?  Unless query performance is an issue, why not just create a dataset that fetches those 4 records at once?

More info on subreports and parameter usage: http://msdn.microsoft.com/en-us/library/ms160348.aspx
0
 
LVL 2

Author Closing Comment

by:CurtinProp
Comment Utility
thanks mate
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now