Count and sum on Page footer level or Per page level

building reports webintelligence
1

Hello All,

We have a requirement to apply count and sum on each page based on Employee. In webI 4.2 report, I’m using two breaks and doing count and sum but the client wants to do page level count and sum along with breaks. Does anyone has this kind of requirement please suggest the logic.

2

If the sum is a total based on the employee, then =sum([YourValue]) in ([Employee]) should be fine. It will work if you have a section or break-based report and put the value in the report, not the page footer.

3

Thank you, Mark. the issue on Page-level. the count and sum need to be per page. let’s say this report has 40 pages and the totals/count needs to be 40 pages. Hope I explained better this time.

4

Hi,

As far as I know this is technically not possible. If Crystal Reports is available you could do it there.