Please can someone help me with the below.  I have a report where I'm sorting on the field TimeOpenSoFar (for open support calls).  This is a text field and the values are shown as 001,10:14:26 where 001 is days, 10 is hours, 14 is minutes and 26 is seconds.

 

I am trying to group in my report so that all calls 1 day or less are grouped together, all calls for 001 are grouped together, all calls for 002 are grouped together and so on.

 

I am using the following formula in Report > Group Expert > Options > Options Tab > Use a Formula as a group name > x+2

 

if "000" in ({calllog.timeopensofar}) then "Less than 24 hrs" else
if "001" in ({calllog.timeopensofar}) then "24 to 48 hours" else "Others"

 

This works fine except instead of giving me one heading with all the calls listed underneath like:

 

Less than 24 hrs

Callid1

Callid2

Callid3

 

It is giving me a heading for each entry:

 

Less than 24 hrs

callid1

 

Less than 24 hrs

callid2

 

Less than 24 hrs

callid3

 

Does anyone know how I can get just one heading with all the relevant calls listed under one heading?

 

Thanks in advance!