Mr Wonderful
MIS
I need to populate a 3rd column on a table for the 1st 2 columns I have the following dataset
Date Percent
1/1/09 .065
1/1/10 .038
2/15/11 .0222
3/12/12 .068
In a header row in the table I have the starting value of 500.00 (reportitems!txtstartingvalue.value)
The running total needs to include the previous calculation of the previous row
The output should appear as
Date Percent Running Total
1/1/09 .065 532.50
1/1/10 .038 552.735 i.e. 532.50 * 552.735
2/15/11 .0222 565.005717
3/12/12 .068 603.426105756
I spent all day on this and it's the first time SSRS has really stumped me
Date Percent
1/1/09 .065
1/1/10 .038
2/15/11 .0222
3/12/12 .068
In a header row in the table I have the starting value of 500.00 (reportitems!txtstartingvalue.value)
The running total needs to include the previous calculation of the previous row
The output should appear as
Date Percent Running Total
1/1/09 .065 532.50
1/1/10 .038 552.735 i.e. 532.50 * 552.735
2/15/11 .0222 565.005717
3/12/12 .068 603.426105756
I spent all day on this and it's the first time SSRS has really stumped me