Search results for query: *

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

I could download your file using your method, but the format is all wrong. Any idea? Thanks

I am trying to download http://www.federalreserve.gov/releases/H10/hist/dat00_sd.txt to a local text file. Here is my code: Private Sub Command1_Click() Dim b() As Byte Dim strURL As String ' Set the strURL to a valid address. strURL =...

I have a form with two command buttons: Undo and Exit. This form has several NOT NULL fields. When user leaves one of those fields blank and try to undo or exit the form, msg "Null value is not allowed" keep poping out and does not allow user to back out and start over again...

I align sub totals with detail lines for several numeric columns perfectly in Crystal Design. When I export the report to Excel, the sub totals shift two columns to the left. How can I maintain the report alignment when exported from Crystal into Excel? Thanks

can someone tell me how to add APS Server back in CE CCM. When I clicked the icon 'Add server', I received: ".. can not locate server executable file. Please make sure the new server is correctly installed.." Do I need to re-install APS? Thank you