Filter Problem

[thehugedeal]

I am kind of new a crystal. I need to filter one field in my report but not change the total amount in another field. My reports is as follows

Total Name of agent Total #of accounts Total # of account worked on
Joe Smith 10 8


Joe Smith 1 Paid
Joe Smith 2 Lmtc
Joe Smith 3 Paid
Joe Smith 4
Joe Smith 5 Folw
Joe Smith 6 Folw
Joe Smith 7 Disp
Joe Smith 8 Disp
Joe Smith 9
Joe Smith 10 Paid


What I need to do is to filter the Call Disp codes by name but not change the total # of account field but change the total # of accounts worked on

Ex. When I filter with the filed name PAID
Total Name of agent Total #of accounts Total # of account worked on
Joe Smith 2 2


What I would like to do when I filter with PAID


Total Name of agent Total #of accounts Total # of account worked on
Joe Smith 10 2


Is there anyway I can make this happen. I am using crystal 8.0.

Thank You

Bruno

 

[Madawc]

In Crystal 8.5, you could try running totals, or the Distinct Count option. Also if you don't want all the details, you could group by account worked on and just show the group totals.

Does this help?

Madawc Williams
East Anglia, Great Britain

 

[IdoMillet]

In the detail section format attributes, there is a button (X+2) that allows you to enter an expression that controls the suppress attribute of the section.

Just enter an expression such as:

{Call_Disp_Cose} <> {?Call_Display_Parameter}

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[thehugedeal]

I have tried to group on accounts worked on it did not worked.

Any other sugestions.

 

[thehugedeal]

Tried the 2nd one, thanks guys

 

[lbass]

I would have approached this by grouping on {table.name} and then creating a formula {@paid}:

if {table.calldispcode} = "Paid" then 1 else 0

Then you would right click on {@paid}, insert a summary (SUM, not count), and then suppress the details.

-LB