Distinct Count formula help

[JoyCR9]

I want a formula in CR9 that is a distinct count of {service_call.service_call_id} for each {part.service_part}

The tables have a nice clean join.

The only group of the report is {part.service_part}.

I suck at writing formulas and need some help.

Thanks,
Joy

 

[lbass]

You don't need to write a formula. Place the {service_call.service_call_id} in the detail section and then right click on it->insert summary->distinctcount.

-LB

 

[JoyCR9]

lbass,

I've been working with this, but need all service_call_id to print. Your method, and mine, only lists one service call id.

My group is system_id.

Suggestions on how to get all service_call_ids to print?

Joy

 

[JoyCR9]

My other problem is not every system_id has a service_call_id and I need to report on all system_ids.

 

[Madawc]

What sort of join between the two tables? Do you expect to have many {service_call.service_call_id} records for each {part.service_part}?

If so, you need to group {service_call.service_call_id} records by part. You could also use a running total for the group.


Madawc Williams (East Anglia, UK)

 

[Madawc]

I posted at the same time as your second message. If not every system_id has a service_call_id, then you need a left-outer link between the two, which should allow system_id records to be shown on their own. Note that the service_call_id fields will be null in these cases, and that Crystal formulas stop when they hit a null, unless an isnull({your.field}) test is done first.

Madawc Williams (East Anglia, UK)

 

[lbass]

I can't follow what your issue is. A distinctcount IS one number. Please provide some sample data and also show a sample of the results you are trying to achieve.

-LB