Search results for query: *

Hi I use Crystal 8.5 with an Oracle db. I have created a report which has a memo field. (I am NOT sorting or grouping on the memo field) The report only displays the first character of the memo field. Any ideas on how I can get it to display the entire contents of this field? Thanks taij

hello I have to create a report which shows ALL jobs with or without revenue. Jobs which did not get invoiced will not have revenue or a record in the invoice table. right now, when I link the job table to the invoice table, it will only show me records which have been invoiced. how can i...

Is it possible to install IIS on a Windows XP Professional computer? Thx

select firstname from test; error msg: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'firstname'.

I have created a new table in an existing DB. I have run a query from the table via EM, but when I try to do the same via QA, it does not seem to reccongize the table exists.

Thanks for your help, but this does not exclude the jobs which have invoice billed in the months prior to the current date. Any thoughts on this?

I am using ODBC linked tables. I am using Crystal 8.5 with Oracle. eg of data: Jobdate Job Number Inv # Invoice Date 01/01/2003 c001 60001 01/12/2003 60002 03/3/2003 03/4/2003 c002 60005 04/12/2003 60006...

I am trying to do a close date report, based on the Job Date and Invoice Date. A job may have multiple invoices. I will be running the report every month. If a job has been invoiced in the month I am running the report for, then I want it calculate the close days by subtracting the Invoice...

Unfortunately it does not do that, it does not return a zero when null

I am using Siebel (Oracle DB) and Crystal Rpts 8.5 When a field has no value how can I get a 0 value assigned to it? If not isnull ({S_ORDER_ITEM.X_SHOT_FEE}) then Numbervar x5:= ({S_ORDER_ITEM.X_SHOT_FEE})else Numbervar x5:= 0; This is what I am using right now, but it does not work. (Does...

Is it possible to add a flag to a record if that record is already opened by someone else?

Does changing the Record Lock option in the form work as well? Changing the Record Lock Edited Records seems to help with this problem.