Multiple Instances of a location

[socalvelo]

CR 11
Oracle DB

Fields:
{table.location} for the street address
{table.CallNumber} Unique number for each service call

I want to report multiple service call locations. But I only want locations with more that two service calls. When using the Group Sort Expert, can a formula be placed in the formula editor to indicate >2 (next to the "Where N is" box) ?

Or is there another method to group on a formula? I'm having trouble doing this because the Count formula I am using requires the group be created first.

Lastly, this is already a subreport without a link to the container so I can't use an additional subreport.

 

[lbass]

You need to insert a group on location and then go to report->selection formula->GROUP and enter:

distinctcount({table.callnumber},{table.location}) > 2

-LB

 

[socalvelo]

Thank you LB.