Recent content by heidi88

Trying to link continous records back to the original one. If 1st startdt= 2nd enddt, 2nd startdt = 3 enddt...mark the initorderid to the very first record. Heidi

Sorry, type error: [BEFORE UPDATE] CustNum OrderId startdt enddt InitOrderId 123 1 01/01/00 01/01/01 123 2 01/01/01 01/01/02 123 3 01/01/02 01/01/03 123 4 09/01/03 09/01/04 123 5 09/01/04 09/01/05 123 6...

Hi, I need to update some records. [BEFORE UPDATE] CustNum OrderId startdt enddt InitOrderId 123 1 01/01/00 01/01/01 123 2 01/01/01 01/01/02 123 3 01/01/02 01/01/03 123 4 09/01/03 09/01/04 123 5 09/01/04...

First, as long as you don't DROP the existing table, you don't need to re-assign the permissions. You can use either DELETE or TRUNCATE statement. Secondly, if you don't want to do complete refresh, first task you have to do is to compare Oracle table with existing SQL table to mark new and...

I have a Oracle statement like this and works in DTS: Select f1 From t1 Where f2=123 However, I need to replace 123 with variable v_f3. I try to declare the variable like this: variable v_f3 number; begin SELECT f4 INTO :v_f3 FROM t2 WHERE ...; end; Select f1 From t1...

I have dataset like this: PO# Position Sequence# POQTY Invoice# InvoiceQTY 123 1 1 100 10 50 123 1 1 100 11 50 I need the result like this, so the PO QTY won't be doubled even the PO was invoiced twice with half of the original...

I have a dataset like this: PO# Position Sequence# POQTY Invoice# InvoiceQTY 123 1 1 100 10 50 123 1 1 100 11 50 I need a result like this, so the PO qty won't be doubled even the PO was invoiced twice with half of the quantity on...

I need to create a report to fetch some data from SQL Server table and others from Essbase cube. Does anyone know how to combing these two data sources? Thank you

I have another un-related question and hoping you can help. Whenever I use activex viewer to view report on CE 9.0, it gives me red-x on the top and nothing happens. When I first launch the report, it did ask me to install ActiveX component, I guess I didn't choose yes. How can I get the...

In term of how I created the percentage, I use formula like: (Sales-Cost of sold)/Sales *100, Then turn on the % sign on the menu bar. Please let me know if you need more info. Thanks a lot.

Oh, you are right. I created the report in CR 8.5 and publish it in CE 9.0

I have a formula calculation sales marging in % format. Crystal report designer shows 20%, after publish the report into Crystal enterprise that field shows $20. Does someone know why? Thanks Heidi

A simple problem bugs me a lot. All users are using NT authentication (all mapped to a NT Crystal user group). On "Manage user" screen, all check boxes under "Selected" disappeared, I can not delete any users by checking the box. I guess none of the NT users can be...

I have a file like this: *NEW ZEALAND DOLLAR 0.6486 0.6506 NORWAY KRONE 6.6930 6.6750 SINGAPORE DOLLAR 1.7100 1.7059 SOUTH AFRICA RAND 6.3200 6.3750 How can I get rid of the extra...

Thanks for the response. I only need to dump the web file into a local text file: Private Sub Command1_Click() Dim txt As String Dim strURL As String strURL = "http://www.federalreserve.gov/releases/H10/hist/dat00_sd.txt&quot...