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
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.
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"...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.