User Defined Group

[peterb58]

I have a report which I want to modify from static groups to user defined.
The basis of the report is Reponse time of an operator in a call centre. The groups are currently defined as <30sec 30 - 60sec, >60sec.
I then sub group these into fixed groups, so in the <30sec group it would be broken into 0-10sec 10-20sec, 20-30sec.

The reports now need to allow the user to choose the lower and upper limits, e.g lower limit =20 and upperlimit = 50. This would give the mail groups as <20sec, 20-50sec, >50sec. The sub groups would remain and sort themselves as appropriate.

The problem I have is with the Group name text. I don't seem to be able to base this on the parameter. I have looked at a text label based on GrouNumber, but this does not work as I expected. What I see is:-

GH1 - GroupNumber 1
GH2 - GroupNumber 1
GH2 - Groupnumber 2
GH1 - GroupNumber 3
GH2 GroupNumber 3.......

I could simply put Less Than Lower Limit..... but I would rather have
Less Than {?user input}


Crystal XI connected to Sybase Anywhere 9.

Pete

 

[Madawc]

What you could do is delete the group name that Crystal makes up and substitute a formula field that you write, though it can be based on the group value.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

Group on a formula like this:

if {table.value} < {?LowerLimit} then
1 else
if {table.value} in {?LowerLimit} to {?UpperLimit} then
2 else
if {table.value} > {?UpperLimit} then
3

Then in the group expert, choose options->customize groupname->use a formula and enter:
if {table.value} < {?LowerLimit} then
"Less than " + totext({?LowerLimit},0,"") else
if {table.value} in {?LowerLimit} to {?UpperLimit} then
totext({?LowerLimit},0,"") + " to " + totext({?UpperLimit},0,"") else
if {table.value} > {?UpperLimit} then
"Greater than "+totext({?UpperLimit},0,"")

-LB

 

[peterb58]

Madawc - I looked at that, but was getting confused by the results from the GroupNumber function. I expected all entries for GroupHeader 1 to run sequentially and independant of that, GroupHeader 2 entries to run in sequence. They don't, they run in the order indicated above. This made it diffcult to work out which values related to GH1 and GH2.

 

[peterb58]

lbass - that works fine. I will try to use this as a basis for the sorting of the subgroup. AT the moment, they are defined at 10sec intervals. Depending on the limits chosen by the user, the groups can overlap. I think I will need to do some maths on the limits and check to the result of a division and base it on that.

thanks

 

[lbass]

If you use my formula there shouldn't be any overlap.

-LB

 

[peterb58]

lbass - You formula works perfectly, it is the subgrouping that is my next problem.

I have 2 groups in the report. Group 1 is the time interval chosen by the user. Group 2 is a subdivision of this to show more detail. It is currently a Specified Order group. It shows the details in 10sec intervals up to 1 min and at 1 minute intervals after that.

example lower limit is 60sec and upper is 90sec. The subgroups will show correctly for Less than 60 sec. Looking at the entries in the 60 - 90sec group I see 1-2min which also appears in the More Than 90 sec group. This is correct, but confusing to the User.

In layout terms:-

GP1 Less Than 30sec
Gp2 Less Than 10sec
10 - 19 sec
20 - 29 sec
30 - 39 sec
40 - 49 sec
50 - 59 sec
GP1 60 - 90 Sec
Gp2 1 - 2 min
GP1 Greater than 90sec
Gp 2 1 - 2 min
2 - 3 min etc

I need to find a way to modify the sub groups to prevent this overlap

 

[lbass]

Records will only appear in one group, so there is no real overlap in that sense. What is the formula you are using for Group 2? I'm unclear on what you would like the final result to look like.

-LB

 

[peterb58]

lbass - GP1 and GP2 are both based on the Response time of an operator in seconds. GP1 shows what results are achieved against the main targets the user has. GP2 breaks this down a bit more to show extra detail. It is added to bulk the report out, it would look too plain and boring with just 3 rows.


The problem is that when you allow user choice, the defined intervals in GP2 can overlap those in GP1 as seen in the listing above. I am not using a formula for GP2, it is a Specified Order group. They are 'hard coded'. It is the labelling of the GP2, I need to work on. Making it dynamic, the same way you made GP1 is where I am headed.

The upper limit is 90 sec, but this causes data from the GP2 1-2min band to overlap GP1 bands. The data will be in the correct group, calls with a response of<90 sec will appear in the GP1 60-90sec band and the rest will be in the >90sec.

Pete

 

[lbass]

So please show what you would like to see for the example you gave earlier.

-LB

 

[peterb58]

lbass - I think the best approach is to reconsider my interval groups for GP2. I was trying to compress the slower response calls by introducing reporting levels of minutes. Obviously this will not work when the user chooses their limit based on seconds.

GP2 will be modified to be a Specified Order group with intervals of 10sec up to 120sec. Anything over this level will be grouped as Others. That way ( as long as the user does not choose 15sec!! ) the subgroups of GP2 will appear in the correct GP1 group. There will always be a few limitations for this, but the lower/upper limits the customer chooses will usually be 30/60, 20/60 or things in that order.

I appreciate all the help you have given, as always you are a star on this forum.

many thanks

Pete