Search results for query: *

Crystal 9 Need a counter variable to start at 902 instead of 0. Does anyone know how to do this? My formula looks like this WhileprintingRecords; NumberVar counter; If not isnull(GroupName ({SERVICE.START_TIME}, "by hour")) Then counter := counter + 1

SC0 7.1 CRON schedules jobs correctly, except for one. Below is the problem entry. Also, below is the CRON log file. There is no problem executing this from the command line manually. #Load Table 25 11 * * * sh /data/loaddata.sh CMD: sh /data/loaddata.sh > root 10904 c Tue Feb 1...

Crystal Reports 9 Need help creating a Minimum (MIN) formula based on the results from a Summary (SUM) formula. Below is the Summary formula: sum({agentstats.acdgrpprimtalktime}, {agentcnfg.agent_id}) + sum({agentstats.acdgrpovfltalktime}, {agentcnfg.agent_id}) The summary formula is on the...

Crystal 9 and Oracle 9i I need help with a formula that increments a counter whenever the value on a field from the previous record is not the same value, otherwise the counter retains the value from the most recent increment. For Example, lets say the table looks like this..... ID Type...

Need sample code for transferring records from two disparate databases like Informix to Oracle and vice versa using ADO. I'll be transferring anywhere between 100 records to 16,000 records.

Crytstal Report 9 I have a group section in my main report. I added a subreport in the header section and linked the two reports using a formula. Both reports have this same formula. Everything works fine, however, the reports take 20 minutes to run. Is there anything I can do to speed up...

Anyone know how to write a SQL Expression on Informix 7.1 for the following formula that I'm using to Group By? Numbervar minextract := minute({acdgroupstats.d_time}); Stringvar amdmins; if minextract <= 15 then amdmins := time(hour({acdgroupstats.d_time}),00,00) & "-" &...

Anyone point me in the right direction to send all files in a local directory on my PC to a remote FTP server using Internet Transfer Control? I know how to transport file(s)by hard coding it using the PUT operation, but business rule needs to be flexible enough to transport all files in the...

Crystal Reports 9 Informix 7 No Authorization to create stored procedures nor views Created a main report with two group sections on a ACD table Group Header 1 (Grouped by ACD) Group Header 2 (Grouped by Hour) Detail (No Data) Group Footer 2 (Summary of each ACD stats per hour) Group Footer 1...

Crystal Reports 9 Informix 7 No authorization to create views or stored procedures. I'm using the following formula to convert number data type to time format. It works fine, except in this type of situation when 60 seconds doesn't convert over to a minute. For example, 00:12:60. In this...

What function can I use to get the month and year from a date. The regional setting in windows for date is short date (08/13/2004). I used month(Date) hoping to get "08", but I get "8". Also, when I use Year(Date), i'de like to get "04", instead of "2004." Can anyone help

Crystal Report 9 Dev Edition Informix DB 7 Informix Client 2.81 VB6 NT 4.0 I'm using the DataDirect ODBC driver (CR Informix ODBC 4.10) to access Informix DB. I can manually run and export the report in Crystal Report connected via the ODBC driver mentioned above, however, when I try to run...

Below, I added the selection criteria to the "selection formula" in Crystal Report 9. This selection formula is using crystal functions, which slows performance. I had to add the "date" function because the acdgroupsstats.d_time field is a string datatype. Is there an alternative selection...

In Crystal Reports 9, how do I change the format of my formula to display a integer value to 20 decimal places?

I am using the formula below to sort by TIME in the group section in my report. The sort works fine on a Sybase DB with all the TIMES appearing in ascending sequence. However, when I use this same formula on a Informix DB, the TIMES are not sorting in ascending nor descending sequence. The...

Hello, I am trying to develop a custom Crystal Report using two views that are linked together. I am trying to sum the "HOLDTIME" which is grouped by skillset and then by agent/csrs. The relationship between skillset and agents/csrs is many to many. That is a CSR can be in one or more...

I am using Crystal Report 7, Microsoft VB 6.0, and Oracle Client 8. I have created a compiled executable that will export two files as MS Word document files. This works fine on the development workstation that has Crystal Reports 7, Microsoft VB 6.0, and Oracle Client 8. However, when I...

I am using the Shell API to attempt to print a MS Word Document without having MS Word opened. However, this Shell API always opens MS Word in order to print the document. What am I missing here? Private Declare Function ShellExecute Lib &quot;shell32.dll&quot; Alias &quot;ShellExecuteA&quot...

Below, I added the selection criteria to the &quot;selection formula&quot; in a report. This selection formula is using crystal functions, which slows performance. I know I can use an SQL expression field to replace crystal's currentdate and time function, but I do not know how to use the...

I have created a report that is grouped by a &quot;Region&quot; field(North, South, East, West). I have also created a SUM field based on &quot;Sales&quot; field. The detailed records in my group are summing Sales by Regions. My report looks like this when I run it: Region Sales...