Thanks for checking. I ended up creating a summary table in sql and will populate summary data there for calculations and then report.

I appreciate the time and effort.