Search results for query: *

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

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

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

I schedule a report to run daily in CE 8.5. System date is embedded in report title. However, when I review the archieved history reports, the date in the report title all show today's date (06/19/03) instead of the history dates. Once each instance completes and saved, should the data...

I have two parameters with long picklist. When I run the report using DHTML on web, it works fine. But use ActiveX viewer, it can not load the parameter screen (no error, just freezes). Could someone tell me why ActiveX viewer cann't launch parameter with long picklist ? Thanks a lot.

I need to pass year to my report in eportfolio. The data type for year is numberic e.g 2003.00. In Crystal Report Development, I use description 2003 to prompt the parameter. But, in eportfolio, I can not hide the value (2003.00) and only show description (2003) in Active X prompt window...

I'd like to customize logon screen in ePortfolio to hide Enterprise authentication, make NT authentication the only option. Where can I find logonform.csp to make the change? Thanks

How to change parameters while viewing reports in eportfolio? Thanks a lot.

I have a silly questions. I noticed that a first-time user logon CE using NT authentication, his(hers) NT logon was automatically added as a new user. Is there a way that I can import some of NT logons into CE before users start using CE, so I can configure the permissions ahead of time...

ODBC connection is set up to use NT authentication to access SQL Server database. When I publish a Crystal report in Crystal Enterprise and preview it using NT logon i.e. company\user in 'Database Logon' screen, got error "can not open SQL Server". Do I have to use SQL Server...