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

I added a call in my shell script to reference the profile file. I also, still had to add ksh to my CRON task schedule. If I didn't add ksh, it would not run. Weird. . /etc/profile Thanks everyone!

Eric, What do u mean by source your oraenv?

Hi Alexhu, I tried it without the "sh" in front of it. I still get the same result. It doesn't run.

sqlldr pro/pro control=/home/pro/dataload.ctl log=loadgood.log bad=loadbad.log

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...

Thanks for feedbacks. I used Access to link the two tables and created a query to perform inserts. Man, it would take 4 hrs to complete the job. Does anyone know if ADO is being used when using an Access query to perform an insert? One of the reason I preferred avoiding using sqlldr was my...

Do you have sample code to loop through the recordset to insert into Oracle table? This sounds like it would take forever to insert 200,000 records.

How would the code like if I needed to get the results from the first database to the second database. For example I can get the recordset from my MS SQL databse, but how do I pass these records over to the Oracle connection to perform an insert of these records?

Get External Data --> Link Tables

What you want require third party IDE. You can use VB, ADO, T-SQL, and Crystal.

8.5 has this feature.

In the "Change Group Options" window, select the "Common" Tab". In the Common Tab, select "In Specified Order." In the "SPecified Order" Tab, select the account numbers you will always need to group by. In the "Others' Tab, select "Discard All Others."

Usually these ODBC drivers like IBM Informix drivers allow you to specify a generic logon id and password to use by adding it to the windows registry.

Yes, I use conditions in my selection formulas.

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...

Thanks guys. Distinct count works fine. Synapsevampire, 0 was not mandatory as the starting number. Just used it as an example. Thanks Again

wichitakid, the running total works fine in the Detail Section. But what if I need to create a GROUP Section to get the same results from the running total?

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...

The types of fonts you see on the drop down maybe related to the types of fonts supported by your printer driver you are using in Crystal Reports.