Grand Total

[CrystalReports9]

Department 10 (Group Field)

Status (column in detail portion of the Department Group)
------
Y
Y
N
--
2 <---Total for 'Y'
--

Department 20 (Group Field)
-------------
Status
------
Y
N
-
1 <---Total for 'Y'
-

How to get the Grand Total Value 3 ?

 

[synapsevampire]

One way is to create a &quot;count&quot; type of Running Total and in the Evaluate->Use a Formula place something like:

{MyTable.Status} = &quot;Y&quot;

Don't reset the value.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[CrystalReports9]

If one more group is in above of DEPATMENT Groups then how to achive?

 

[synapsevampire]

Reset it at Department if you want it to reset for each one.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[CrystalReports9]

Its working fine...But i would like to eliminate the duplicate value [ Y ] in the Column. In the same example
Department 10 (Group Field)

Status (column in detail portion of the Department Group)
------
Y
Y <--- too be consider these &quot;Y&quot; as a single &quot;Y&quot;
N
--
1 <---Total for 'Y'
--

Department 20 (Group Field)
-------------
Status
------
Y
N
-
1 <---Total for 'Y'
-

How to get the Grand Total Value 2 ? Pls correct me