Hi Reader,

I am relatively new to reporting (Crystal Reports 11.5). I am stuck at a particular situation and there are no experts around. :(

Let me explain the situation. I have a list of users and their status across departments
UserID       Status               Department
01          Active               IT
01          Active               Docs
02          Active               IT
03          Suspended             Docs
04          Leave                 Docs

I need to find the distinct count of number of users having a particular status. In this case,
Active       - 2
Suspended    - 1
Leave        - 1

The result set is grouped by Status and User.
I tried using doing a right-click -> insert -> summary and did a distinct count at Status group level. This gives the required result set but this is present at the group header.

I want this summary to be present in the report header and I don't seem to be able to do this. When I copy it there, the result set gets weird. Please help me out. Or let me know if this is to be done any other way.

Thanks [COLOR=red]COLOR=red[/COLOR]

Thanks DBlank.
Actually, I already tried this and it does give me the required result in the group header. But as I mentioned, I require this DistinctCount result to be present in the Report Header and when I move this to Report Header, it is not giving me proper results.


Edited by manug87 - 30 Sep 2010 at 8:11am

Thanks a lot again.

The totals appear perfectly but the look of the cross-tab is not exactly that I require. I want a description to appear in the place where the Status appears in the row.
Is it possible to modify the look in cross-tabs? I mean the row name part of it.

you can create a formula to convert your status field to whatyever you want then use the formula field in the CT instead of the status.field.

Edited by DBlank - 01 Oct 2010 at 4:27am

are you excluding them in the rest of the report?