Solved

Send a value from a subreport back to the main report in 2008 reporting services?

Posted on 2009-05-08
5
677 Views
Last Modified: 2012-05-06
I am converting a few reports from Crystal reports to RDL.  I need one of my reports in SQL Server 2008 to do the following:

- Pass a value to a sub report (zero)
- the sub report evaluates data in the sub report and changes the value (example from 0 to 3)
- the value (3) is passed back to the main report
- the main report totals up the sum of what is passed back from all of the subreports and prints the total in a group (21)

Is there a way i can do this in RDL?  Any help is appreciated...I'm a bit of a hack!

Thanks!
0
Comment
Question by:GreatWindows
  • 2
  • 2
5 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24342215
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 250 total points
ID: 24342404
Sorry, I don't think this feature is possible right now in reporting services.  I have seen this asked before and all my research has not found a solution yet.
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 250 total points
ID: 24342407
You are absolutely tru CGLUTTRELL, that is why I have provided few links above, which is also mentioning the same.
0
 

Author Comment

by:GreatWindows
ID: 24346820
ok.  Well i was hoping I could get that to work.  I'm a bit surprised but can't change it.  So can i do this...and how?

1. place a table where i used to have the subreport in a cell on the detail row of the current table I have?
2. if so, how do i call this dataset each time to retrieve the info just for that line?
3. finally, how do i evaluate each row of data to tally a condition and then print it out?

In step 3, i basically need to evaluate certain conditions in the data and store the tally (i.e. 3 rows have "Great" in them) and then print the total (i.e.3) in the group footer.

i appreciate the help.  Thanks to you both.
0
 

Author Comment

by:GreatWindows
ID: 24346836
I just tried doing step 1 in my above post and it seems that it won't allow me to change the dataset for the table inside of another table.  Is this the case or am i doing something wrong?  thanks.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

810 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