Recent content by edsaf

Hi, Using Crystal XI, i have some data that shows a row for each agent that contains the start and end time for each phone state they were throughout the day. What i would like to do build a Gantt type chart that has the various phone states on the y-axis (ReadyForNextCall, AfterCallWork etc)...

When teams are created in one system, it sometimes take a day or two to update everywhere else. The formula generating the error is in the seconds sub report and the cursor is on the last line. variable x = 36 variable y = 35 (this is the distinct count of {team.name}) whileprintingrecords...

hi lbass, what can i do in cases where y (distinctcount{table.team}) will be less than the distinctcount({table.team}) in the second subreport?? I think thats the reason why i sometimes i get the error: 'The subscript must be between 1 and the size of the array' there are some cases where i...

Hi - Sorry, my bad. The blank page 1 was because the size of the subreport was larger than a page, so it decided to start it on page 2, dont know why, but thats what its doing. As for the error message for the 'site' version of the formula, as long as the group are suppressed in subreport 1...

also, just wanted to quickly add that its producing a blank page as page 1. even though i have suppressed all groups in subreport RHa

Hi lbass, That worked, fantastic! Also, i duplicated the process to show the available time at the site level, but it returns this message: 'The subscript must be between 1 and the size of the array' here is the code: [in RHa group footer for 'site'] whileprintingrecords; shared numbervar...

I have attached a pdf copy of the report and a screen shot of Crystal Reports design view so you can see what im trying to achieve. http://members.iinet.net.au/~dj_eddie/crystal_design.png http://members.iinet.net.au/~dj_eddie/task_report.pdf I have used the header/footer method successfully...

Hi All, Crystal XI - DB2 Database. I have a report with 2 subreports: Subreport 1 contains the available time per team Subreport 2 contains the tasks closed per team What i want to do is create a shared variable so that the available time for each team can be called in Subreport 2 so i can...

Thanks lbass. Thats worked. I actually did that before, but i panicked because to double check the results, i added markers and the date value that popped up with the marker was no where near the the date on the x-axis. But by checking the 'result' on the marker, it does match to the result...

awesome, thanks!! The graph now works. I have one more request. Is it possible to show the date across the bottom? in this case the date is the field i used for the variable onchgof.

Hi - Thats great, but for 1 rolling number, the number of customers that called once, but if i repeat the process for the 2nd rolling rolling, the total number of calls, how does that work? Ideally i would like to divide the 1st rolling number wth the secod to produce a First Call Resultion...

Thanks lbass that worked. I created the formula for 2 fields that i wanted to average. Problem is now i cannot graph it. Its for First Call Resolution. I created one rolling formula for the number of customers that called once and another rolling formula for the total number of calls. I can...

Hi Madawc, I dont understand. Here is the code from the thread i linked to: I have already changed the firlend name to the one i want to 'roll' and i changed the 'Rolling Period' variable to 7. All i need is for someone to help me figure out what i need to change so that it rolls the current...

Hi, After searching this forum for a 7 day rolling solution i found that the code in this thread was exactly what i needed. http://tek-tips.com/viewthread.cfm?qid=914201 All i need is help changing it so that it returns the 7 days including the record that the result is shown on, not the...

lbass - That worked a charm. Thank You