Selection

[JOOJOO00]

Hi all,

I work with Crystal 7.5.
In the standard report for Callcenters, I have to make a selection with from agents up to Extention 700 and higher.

The formula for the agents is as following: TrimRight({Users.Last Name})+", "+TrimRight({Users.First Name})+" Ext. "+
NumToText({Reason Code Events.Reason Code Resource ID})


It works fine, but I just need the information from 1 group, shwon here..: Bakir, Ibrahim Ext. 753


Event Reason Date Time Duration

Sign-on Automatic/No reason 4/3/03 08:04:16AM
Idle Automatic Idle with Sign-on 4/3/03 08:08:15AM 00:03:59
Idle overig 4/3/03 08:39:12AM 00:01:31
Idle Kwartier pauze 4/3/03 10:20:43AM 00:17:20

Bearzatto, Barbara Ext. 208..etc
Becker, Fernando Ext. 761...etc

Is there a formula for it and where do I put it?

Regards,
- Ronin71 - R>F>> SNAP!

 

[Naith]

Was there a 7.5? I've just sworn blind to someone that there wasn't. Don't tell me I'm going to have to eat humble pie for lunch...

And while my intelligence is on trial, I'm going to give the prosecution more to work with by admitting that I don't really know what you mean when you say: "I have to make a selection with from agents up to Extention 700 and higher".

Doesn't this mean all extensions?

Anyway, assuming I understand your request - and I think you're aware by now that I most likely don't - you can get the information for the one group you've specified by using a clause like:

{Reason Code Events.Reason Code Resource ID} = 753

Put this in your selection criteria if this is the only record you want brought back, assuming that {Reason Code Events.Reason Code Resource ID} is unique per record.

Naith

 

[JOOJOO00]

Thans for the reply Naith,

Well you can begin to eat the pie for lunch... I have exually version 7.5... Could that be a problem?

I am sorry for my terrible english. Maybe I can make it clear now.
There are several agents here with an extensioncode. What I just need are the agents with extensionscode 700 and higher.

I just made a formula in the Detail secetion: if {Reason Code Events.Reason Code Resource ID}>700 then NumToText({Reason Code Events.Reason Code Resource ID})
else
""

But the agent, for example ext. 208, is still on the report.

Does that mean that I have to devine every ext. in the formula ? Question 2: Do I have to make a new formula?

The formula shown before (in thread 1)is been set in Group Header #1.

Hopefully I can make the selection. - Ronin71 - R>F>> SNAP!

 

[Naith]

Your having v7.5 is not a problem. It's just I don't happen to particularly like the taste of humble pie is all...

I think I see what you're getting at now.

Do this:

Go to your Report Menu / Edit Selection Formula / Record.

and paste this in:

{Reason Code Events.Reason Code Resource ID} >= 700

This will only return records equal to or greater than 700.

I hope this is what you were getting at, but if I'm still off the mark, let me know and we'll see if we can't put it straight.

Thanks,

Naith

 

[JOOJOO00]

THANK YOU !!!!! Naith

It works!!! Great work..

This is exactualy what I need.

Can I ask you one more? I work with another report more then 4 weeks now, and it still doen not what I want.

Here we go, this is the following: I have an half hour detail report (from 7.00 till 22.00). It works fine but ( I know) if nothing has been recorded on our Aspect machine (telephone calls), then there will no information on the report also. But the customer wants a report from 7.00 till 22.00, even if there is for example at 21.30 no calls, beeing reported.
So it is going to look like this: 21.00 - 2 calls- 0 abandoned ; 21.30 - 0 calls- 0 abandoned <== this is the issue. the time 21.30 is still not on the report.

How in heaven name..... Please HELP..

B.t.w.: This is the formula for Half Hour: HalfHourSort({Call Detail.Termination Time})

Again, thanks for helping me... - Ronin71 - R>F>> SNAP!

 

[Naith]

This has come up before.

Read Ken's August 2002 newsletter to find out all your options.

http://www.kenhamady.com/news0208.html

Naith

 

[JOOJOO00]

Thanx.. I dont know if it is going to work but it should help, i guess..

Thanx for your help.

Regards, - Ronin71 - R>F>> SNAP!

 

[Naith]

Heh. I guess I can understand your reserved response. No one likes to be referred elsewhere to get their answer, but trust me; the answer you need is in this newsletter (pay particular attention to the section: &quot;Reporting on data that isn't there&quot;.) The only reason I didn't post it is because it's very long and detailed. But it does touch on about 8 different ways to achieve what you want, so I can't see how it won't help you.

If you're reading, great piece by the way Ken.

Naith

 

[JOOJOO00]

Hi Naith,

well it is not personal to you but I am a bit sick off it, sitting for weeks now, trying each formula, nothing works. And the main problem is that I do not have enough the know how yet!

I tried the section you mentioned, it looks good but I tried also to implement the sollution in each section possible (Detail, GroupFooters..etc). Nothing works.
The basic training I had was good and easy, but this is different.
For what I know is that our database works with Oracle and only in queries... like: Apps_Detail Apps_Detail_ov etc..
Mostly the report is failing when I try to change it.

But anyway thanx for helping me out at the first question I had. That was very great!! Maybe it is possible to send you some samples, maybe I forgot to mention something else....

Greatings from East-side of the Netherlands!! - Ronin71 - R>F>> SNAP!