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

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!
GreatWindowsAsked:
Who is Participating?
 
Chris LuttrellSenior Database ArchitectCommented:
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
 
RiteshShahCommented:
You are absolutely tru CGLUTTRELL, that is why I have provided few links above, which is also mentioning the same.
0
 
GreatWindowsAuthor Commented:
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
 
GreatWindowsAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.