GreatWindows
asked on
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!
- 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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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.
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/915783b4-585d-4668-80e7-178f14a24aec/
http://www.bigresource.com/MS_SQL-Passing-values-to-parameters-in-a-subreport-newbie--8wwNz2sj.html#
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=876a33c8-1302-432f-9ca1-54a5914afa3e&cat=&lang=&cr=&sloc=&p=1