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
Solved

Access SubReport data from main report in Reporting Services

Posted on 2009-07-06
4
581 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL 10 35
SQL Server 2012 Lag Function With Group Levels 1 26
Stored Proc - Rewrite 42 58
Error when creating an UPDATE Trigger in SQL 6 20
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…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

856 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