Recording from 7.00 till midnight

[JOOJOO00]

Hi all, I'm a newbee here.
The following problem I have to solv is this:

The company (Callcenter), wants a FULL report, every day from 7.00 till midnight. The problem is that if there is NO call at for example 23.30, then there will be no record of it. The report is based on an half hour report daily.
The people who work with these reports want to have the full report WITH the call at 23.30. Is that possible?

PLEASE HELP !!!

 

[cmpgeek]

i think i am missing something... if there is no call @ 2330 how CAN there be a record for it to show?

if i am missing something really obvious just smack me over the head as i know it is definitely possible ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[JOOJOO00]

Thanx for repling.

In the report for example: @23.30 hr -- 0 calls offered -- 0 calls abandoned.
What I am trying to say is that in the report has to be recorded that on 23.30 , ZERO calls were offered. In the äbandoned calls" I can see in the report that it is ZERO, so why and HOW can I let Seagate record on the time above so that the FULL report can be presented even there is no call at the time at all.

Sorry for the terrible english...

 

[cmpgeek]

usually if there is no data for 2330, the 2330 wont even show up let alone anything else. the way i have found to work around that is a subreport. in the main report you would have the date and time ranges... the subreport would be linked to the main report by time range... you can then have a text box there that is suppressed conditionally (for when {total# of cases} = 0

i have a habit of doing things the hard way; so there may be an issuer way, but i DO hope you are able to get the data you want soon! ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[JOOJOO00]

Right, there is a subreport. In the main report there is a "query execution". This is what is says:

//Sqlv81QueryClassStartQuery ("APPS_DETAIL",{?Call Center},{?User Name},{?Password}, {@StartDate}, {@EndDate} ,{@StartTime},{@EndTime});
EvaluateAfter ({@Parameter Evaluation});
if {@StartTime} < {@EndTime} then
SQLv82QueryClassStartQuery (&quot;APPS_DETAIL&quot;,{?Call Center},{?User Name},{?Password}, {@StartDate}, {@EndDate} ,{@StartTime},{@EndTime})
else
SQLv82QueryClassStartQuery (&quot;APPS_DETAIL_OV&quot;,{?Call Center},{?User Name},{?Password}, {@StartDate}, {@EndDate} ,{@StartTime},{@EndTime});

The time range in the subreport is ok..

You mentioned a text box.. (for when {total# of cases} = 0).
Does that mean that I have to implement it in the main- or in the subreport.

The Half Hour formula is looking like this: @ Half Hour: HalfHourSort({Call Detail.Termination Time})

I tried to set it in the formula like : if isnull({Call Detail.Calls Offered}) then &quot;&quot;
else HalfHourSort({Call Detail.Termination Time})

Something tells me that I am close but so far, the report is still giving nothing at 23.30.

 

[cmpgeek]

try adding some kind of text in your if/then statement like this:

if isnull({Call Detail.Calls Offered}) then &quot;no calls recorded in time slot&quot; else HalfHourSort({Call Detail.Termination Time})

maybe crystal is acknowledging the slot; but the &quot;&quot; is not able to show it...


ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[JOOJOO00]

Here I am again, I was ill for more then a week.

I tried the last thing, but it still does not work in the way I want.
It is still not recording in the report (see above)

Is there another solution?

HELP !!!

 

[lyanch]

You don't mention which version of Crystal you are using.. but ..

Basically you need to either through a temp table or permanent table create a table that contains all the &quot;times&quot; and link that table into your output with a left outer join. Then you will have all the times show up on your report.

Lisa

 

[JOOJOO00]

Sorry, I am using Crystel version 7.5

Ok, Lisa, I tried to set it in &quot;left outer join&quot;, but it seems that I have not the right formula for it.

The problem is that there is NO table so ever. There are only queries...., with filename.civ

I can not get in to the report field:&quot;Call Detail. Termination Time&quot;.

I tried following: If Minute({Call Detail.Termination Time}) < 30 then Time(Hour({Call Detail.Termination Time}),00,00)
else Time(Hour({Call Detail.Termination Time}),30,00);


But what ever I do, the report failes... very frustrating
with fault message: PEStartPrintJob : Not enough memory for operation.

Maybe I am doing something wrong...probably for sure...

HELP !!!

Maybe it is helpfully to send a copy of report (Excel) to see what I mean.