How do i get Subtotal + Main total = Grand Total on Main Report

E

ejike_discuss

hi, can anyone help?

On my Subjective Report I have 12 values for each month of the year.

For the first month the value is =sum(Fields! Month_1.Value), and I
have named this text box 'SubRepM1'
The name of the subreport is 'subreport1'.


On my Main Report, again I have 12 values for each month of the year.
For the first month the value is =sum(Fields! Month_1.Value)*-1, and I
have named this text box 'MainRepM1'
The name of the main report is 'GMSHA Budget Adjustment Differentials'

Currently i am able to display the subreport values in my main report
but i need to total these values together for each month in order to
produce a grand total.

I am a newbie when it comes to using subreports within main reports so
any help would be appreciated. The Reports have been created using the
visio studio reports, ssrs.

thanks
 
Top