2 or more customers

[Sahubba]

Hello,
I am trying to see only the customers that are being helped at the same time with the same person.
I am not sure if how I can do this in crystal.

so if {customers} has the same {Sales person} at the same {Time}
Then I want them to show up.

I hope this makes sense.

 

[CoSpringsGuy]

try grouping by sales person and then by time

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection

 

[Sahubba]

Hi CoSpringguy,

That will not work.
I only want to see the customers that had the same sales person at the same time. there is a time in and time out.
that is how I will know that sales person where helping more then one customer at a time.

 

[Sahubba]

I thought this formula would work
if {table.enddatetime} > next({table.startdatetime}) then
"Double"
else
"One"
But I got this error
This field has no previous or next value.

So I am still stuck

 

[CoSpringsGuy]

OK I tried to do something similar to this a few months back.. Not sure if it will correlate to your situation.

Try grouping first by salesperson
then group again by customer
record sort by start time
place sales person and customer in the details section
{@2ormore}
create this formula
if {timeBegan}
in [previous({timeBegan}),previous({timeEnded})]
then 1

suppress details section with this formula {2ormore}=0

the results should display only records (sales and customer) which overlap in time with the immediate preceeding record


_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection