How to show both detailed and aggregate data in one Tablix in SSRS
I am developing a report in Visual Studio 2013 and report requirements are: Report should include detailed data for each provider who provides individual services to patients Report also should include records for providers who provide group services. Thus the criteria in this set is different than the first set Report should include both #1 in one report separated by each provider I created #1 & # 2 reports but I am stock how to bring them together in one report where each provider gets his/her individual as well as group services reports in one nice formatted report. I have tried subreport with no avail but looking into linked report. Any thoughts/suggestion how this can be done? here is an example Individual Services P_ ID P_Name Unit ID Client ID Date Minutes CPT Code Type Indiv Rate 3 John 102 100 4/15/2015 60 90791 K2 $50.23 3 John 102 101 4/2/2015 60 90791 K2 $50.23 3 John 102 102 4/21/2015 60 90791 K2 $50.23 Total - Individual Services $150.69 Group Services P_ ID P_Name Unit ID Date Minutes CPT Code Type Gr_Svc Rate 3 John 102 4/20/2015 60 90853 I7 $25 3 John 102 4/22/2015 60 90853 I7 $50 Total - Group Services $75 Grand Total $225
It sounds like you've got 2 different queries here with different columns but you want to show the grand total of both. You should be able to have 2 datasets displayed in two tables. Then create a 3rd table and use an expression like this (assuming your datasets are called DS1 and DS2) to show the grand total: =Sum(Fields!Rate.Value, "DS1") + Sum(Fields!Rate.Value, "DS2") If that third table gives you trouble you could fake a table with a couple of textboxes.