Symposium and Crystal reports

[Thant]

Greetings,
I have been tasked with creating reports out of symposium using crystal reports. Does anyone have any experience with this? if so I would like to pick your brain about field mapping and where i can find certain fields in the database
Thanks

 

[Aaith]

there is a reporting and Data Dictionary on the nortel site.
this list all the fileds / tables / ect...

its

Nortel Contact Center Manager Server
Historical Reporting and Data Dictionary

Doc id 297-2183-914

do a search for "297-2183-914" it should pop up in the list.

 

[steel451]

I have some experience of doing this and would be happy to share. You posted this in April so you may now be up and running, if not send me a pm.

 

[pablow]

I have done a bit of work with CR and reports - my first bit of advice would be to set up an ODBC connection to the CCMM server from Access or Excel and look at the tables and the data in it before formailising it into Crystal.

Access gives you the chance to "trial" your joins and queries in a nuch easier way than the cut down version of Crystal bundled with CC6.

 

[Thant]

Steel451,
Ive got a question for you but not sure how to pm it to you.

Anything worth doing is worth messing up at least 5 times before you get it right!

 

[Thant]

Does anyone know a good way to convert the talk time field in nortel into HH:mm:ss formatin crystal?
Im also confused about the talk time and wait time fields since it returns as a whole number. Is it coming in as seconds the application has been in talk time? Minutes? Hours? Im trying to get an average of this field for a scorecard for my AVP.

Thanks

Anything worth doing is worth messing up at least 5 times before you get it right!

 

[Utreg]

The Talktime is represented in seconds.
You can create the following formula to show it in HH:MM:SS

WhilePrintingRecords;
StringVar Hours1;
StringVar Minutes1;
StringVar Seconds1;
NumberVar TalkTime:=0;


TalkTime:={iAgentPerformanceStat.TalkTime};

If TalkTime < 0 Then
"Cannot have a time less than zero"
Else
(
(Hours1:=ToText(Truncate(TalkTime/3600),0);
Minutes1:=ToText(Truncate(Remainder(TalkTime,3600)/60),0);
Seconds1:=ToText(Remainder(Remainder(TalkTime,3600),60),0));

//Display the time formated.
(if length(Hours1) < 2 then '0') + Hours1 + ":" +
["0",""][length(Minutes1)] + Minutes1 + ":" +
["0",""][length(Seconds1)] + Seconds1;
)

 

[Thant]

Utreg,
Thanks for this this looks like what I need. Im going to test it today. Can you see any problems using this formula with the mApplicationStat table, or should it work the same way in both places?

Thanks

Anything worth doing is worth messing up at least 5 times before you get it right!

 

[Thant]

Utreg,
When I try and implement this i get a The ) is missing error

WhilePrintingRecords;
StringVar Hours1;
StringVar Minutes1;
StringVar Seconds1;
NumberVar TalkTime:=0;


TalkTime:={iAgentPerformanceStat.TalkTime};

If TalkTime < 0 Then
  "Cannot have a time less than zero"
Else
(
 |this is where it places error| (Hours1:=ToText(Truncate(TalkTime/3600),0);
  Minutes1:=ToText(Truncate(Remainder(TalkTime,3600)/60),0);
  Seconds1:=ToText(Remainder(Remainder(TalkTime,3600),60),0));

//Display the time formated.
  (if length(Hours1) < 2 then '0') + Hours1 + ":" +
  ["0",""][length(Minutes1)] + Minutes1 + ":" +
  ["0",""][length(Seconds1)] + Seconds1;
)

Any ideas?


Anything worth doing is worth messing up at least 5 times before you get it right!

 

[Utreg]

Should work for all (time variable) database items.
Don't know why it misses a ), I cpied it directly from a Crystal reports report.

Found another formula to display time, you can try this one below (it was uses to calcuslate and display an average. If that also does not work youy can try to get an answer in the the CR forum

http://www.tek-tips.com/threadminder.cfm?pid=767

// AVG Talk

local numbervar VariableinSeconds;
local numbervar RemainingSeconds;
local numbervar Hours ;
local numbervar Minutes;
local numbervar Seconds;

//Set variable
VariableinSeconds := If {dAgentBySkillsetStat.CallsAnswered} = 0 Then 0 Else {#Talksum}/{dAgentBySkillsetStat.CallsAnswered};

//divide the @TotalSeconds by 3600 to calculate hours.
// Use truncate to remove the decimal portion.
Hours := truncate(VariableinSeconds / 3600);

// Subtract the hours portion to get RemainingSeconds
RemainingSeconds := VariableinSeconds - (Hours * 3600);

// Divide RemainingSeconds by 60 to get minutes.
// Use truncate to remove the decimal portion.
Minutes := truncate(RemainingSeconds/60);

// Subtract the Hours and Minutes and what is left over is seconds.
Seconds := VariableinSeconds - (Hours * 3600) - (Minutes * 60);

// Format the hours, minutes, and seconds to hh:mm:ss
totext(Hours,"00") + ":" + totext(Minutes,"00") + ":" + totext(Seconds,"00")

 

[Thant]

Utreg,
When I try the formula above it keeps saying
"A statement is expected here" and references the first space within the formula

Any ideas? Im still trying to find the best way to do this. I have been reading up and would a ToText statement be any help at all?

Thanks


Anything worth doing is worth messing up at least 5 times before you get it right!

 

[Utreg]

Is your formula in the 'Crystal Syntax'?
(And hence not in the 'Basic Syntax')

This formula works fine for me in Crystal Reports 9.2 and above...

 

[Thant]

Utreg,
Wrong Syntax DOH!
That was my issue. I got it work and wanted to thank you for your last Avg talk formula. This is what I needed! My apologies for being a bit dense about this whole thing.Im still trying to train my brain to think programmatically. I appreciate the help!

Anything worth doing is worth messing up at least 5 times before you get it right!