[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Access SubReport data from main report in Reporting Services

Posted on 2009-07-06
4
Medium Priority
?
586 Views
Last Modified: 2012-05-07
I think the title says it all, i'm using version 2005
0
Comment
Question by:CurtinProp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 24784367
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
ID: 24791303
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
ID: 24791866
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
ID: 31600058
thanks mate
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

650 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