Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 709
  • Last Modified:

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!
0
GreatWindows
Asked:
GreatWindows
  • 2
  • 2
2 Solutions
 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now