So I have this report which looks something like this

gh1 regionname | 506
gh2 marketname | 193
gh3 branchname | 12
d                         1
d                         1
d                         0
and so on...

each region, market, branch is assigned to a manager login, so in the select expert it is something like this:
{RegionManager} = CurrentCEUserName or
MarketManager} = CurrentCEUserName or
{BranchManager} = CurrentCEUserName or
CurrentCEUserName = 'administrator'

administrator can see all the data, but each manager can only view the detail rows that are affiliate to them.

The problem now is when I ran it using a market manager login, the detail section did only show the rows that are related to the market manager, but the groups are not giving me the sum of rows that are related to the market manager.

Anyone has an idea on how to solve this?

p.s runningtotal does not work in this case because my sums must be placed on the report header.

Hey Dell,

I am using the formula in the select expert.

Thank you for the reply.

Yea that is all it is in the select formula, basically what it does is to filter (not suppress) the details so that it will only show the rows that are related to the manager login.

The formula I have is doing the job at the detail section, but the group levels are still summing all values of all manager, instead of that specific manager.

It is weird because i applied the formula to all 3 select experts (records, group, saved data). Somehow CR still summing up all the values, regardless if it is related to the manager or not.

I actually tried both ways.
1. I just right click the detail value and insert a summary.
2. I used COUNT ({detail value}, {branchname}) , i also dd it for other group levels too.

But both still sum up all the values even when I ran it where CurrentCEuserName as one of the managers.

I am sorry, maybe I did confuse you there a bit. So the detail part can only be 1 or 0 .
So for example this is the full table (full access to view):

               Manager    Total
branch group               3
detail          John        1
detail          Mike        1
detail          Jason       1

So if I run it with John's login, I am supposed to only get sum total for branch level to be 1:

               Manager    Total
branch group               1
detail          John        1

but instead I got this sum is 3:

               Manager    Total
branch group               3    <-- sum is still 3
detail          John        1

I am sorry if I caused any misunderstanding.