Hello All, Please help me to figu 1

[visit2me]

Hello All,
Please help me to figure out this issue on my new report requirements. In below report, I have GH 1 Company Name and Group Header 2 Aging Date. I want to include total at bottom of report. current% is calculation of (1074318.08-1114098.75)/1114098.75*100, and all other % calculation base on that formula.
NOw, Total is little tricky Current total for 6/1/2012 is sum of each company 6/1/2012 amount and similarly 6/15/2012 and 7/1/2012. And current% an 1-30% are also same calculation as above. Is there any way of getting this done? Please help!!!

thanks,


*********************Current**********current%*********1-30 Days*******1-30 %
****Company AAA
****6/1/2012*********$1,114,098.75*******0%***********$85,113.68*******0%
****6/15/2012******$1,074,318.08*******-4%**********$177,668.51*******109%
****7/1/2012*******$945,025.17*******-12%**********$192,073.86******8%

******Company BBB
*****6/1/2012********$1,272,925.77****0%*********$274,745.21*****0%
**6/15/2012 ** $1,131,405.38 **-11% ** $190,605.16** -31%
**7/1/2012** $1,221,730.35** 8%** $362,311.98** 90%

***Company CCC

**6/1/2012** $1,060,121.12** 0% **$431,452.58 **0%
**6/15/2012** $1,116,497.91** 5%** $397,787.83** -8%
** 7/1/2012** $1,081,021.03** -3% **$515,395.47 3**0%

TOTAL
**6/1/2012** $3,447,145.64 **0% **$791,311.47**0%
**6/15/2012 ** $3,322,221.37** -4% ** **$766,061.50 **-3%
**7/1/2012** $3,247,776.55** -2%** ** $1,069,781.31 ** 40%

 

[IanWaterman]

The easiest way will be to uae a subreport which has same data as main report but without customer group.

Ian

 

[visit2me]

That's exactly what I did. But the issue with that was the performance. This main report was already taking 6 minutes to run and if I add subreport then it would be double the time to run report. And adding subreport works however due to performance issue mgmt team decided not to add total at bottom of report.
Good for me.
Anyway thanks Ian for your input and time.

 

[IanWaterman]

If its taking 6 mins to run you might want to take a look at your SQL and make sure all your select expert filters are being parsed to the database.

If you are using formulae in select expert that can some time mean too much data is being brought back to be filtered locally in report making it slow to execute.

Ian