Search results for query: *

Is it possible to export formulas, rules & groups/sorts from crystal XI? I developed a host of reports years ago. Im now being asked to document those reports and I am hoping that there is an automated way to do this. Any feedback would be appreciated. dannab

I read this post thread959-944565 and was wondering, any chance anyone is willing to post a sample of their perl scripts to connect and dump data? Ive been struggling for a few days. I know nothing about SQL, I know a little about perl and have perl support from a colleague, but at the rate I...

There was an error while trying to print report !Failed to access information from report file. This has occurred on both sccs 4.2 & 5.0 with both windows NT & windows XP. Our team was able to isolate our error to a local profile on a users workstation. Most likely due to permission conflicts...

We recently upgraded our symposium to 5.0 and had the same problem. We put in a ticket with Nortel and their tech called me back. He said that there is a known problem with the user database conversion from 4.2 to 5.0 and permissions are lost for certain tables. He also said that there is no pep...

More specific info: Im reading data based on an id, using Record Selection. RECORDID = "somenumber" 12345 (unique) Returns this record record id - 12345 employeenm - Janice Smith notes1 - 250 characters of text notes2 - 250 characters of text nextrecordid - 98765 If...

Im reading data based on an id, using Record Selection. RECORDID = "somenumber" 12345 (unique) Returns this record record id - 12345 employeenm - Janice Smith notes1 - 250 characters of text notes2 - 250 characters of text nextrecordid - 98765 If NEXTRECORDID is not null, read...

My report selection formula: RecordId = 12345 Returns //Record 1 Name - Susan Record Id - 12345 Notes1 - some data Notes2- some data Notes3- some data NextRecord Id - 98765 If record 1 has a valid next record Id, requery database for Record Id = $NEXTRECORDID (98765) and continue looping until...

Im using crystal 9.0 w/sybase. Im reading note records for employees based on a single record id. There is a field in the returned record named nextrecord. If the nextrecord exists, I want to read in records for the nextrecord id. I want all notes from record 1 & any nextrecords to show. Any...

I dont know what I did yesterday. Tried again this am, works fine. I ordered the george peck book. Cant wait to read it. Thanks so much for all of your help. dannab

the summary / running total field could not be created. dannab

lbass, How do I go about getting a summary for each date to appear on the report? Ive tried using the same formulas,removing ,{iSkillsetStat.Time}, but I get the svc factor for the first day in all of them. dannab

You are my Hero!! Thank you so much! Have a question though, how long have u been doing this, did you study for it? dannab

I deleted the datetime group (I had actually had both time & datetime). There are 3 seperate formulas for last week they are: //{@lastweek_level1} if {iSkillsetStat.Timestamp} = dateadd("d",-7,currentdate-dayofweek(currentdate)+2) then {iSkillsetStat.CallsAnswered}+...

Thanks, great info. I had to add a timestamp group & put the {@svcfactor} formula in it, worked beautifully, except this problem. For {@thisweek}, all intervals 00:00-23:25 accumulated properly. When I moved on to last week, the only data that accumulated was for the first interval 00:00, the...

{@svcfactor} is returning error the summary / running total field could not be created. If I simply print {@Level1} it returns 0. Even though there are values for the items in {@Level1} for the date/time dannab

For {@svcfactor} Im getting error: the summary / running total field could not be created dannab

Sorry the service factor formula actually contains {iSkillsetStat.Time}, not {iSkillsetStat.Timestamp} dannab

Hello All, Im using CR 8.5, connecting via ODBC to a symposium database. Im currently pulling data for Monday only. I need the report to display the service factor (a custom formula) as follows: 1/17/05 1/24/05 1/31/05 2/7/05 00:00 70 35 25 90 00:15 95...

Im using crystal 8.5 connecting via ODBC to a symposium database (I do not have permissions to add/change symposium tables). I have created a DNIS report, grouped on timestamp & time, to show calls ans, calls abandoned etc. My problem is only intervals with data in them appear on the report...

I had to create two formulas. 1. dateformat formulat to turn my timestamp into mm/dd/ccyy format (the field also includes mmhhss which I didnt want to use). Local NumberVar myyear := Year ({iApplicationStat.Timestamp}); Local NumberVar mymonth := Month ({iApplicationStat.Timestamp}); Local...