Search results for query: *

Hi, I'm completely stuck with this one. I have a crystal report XI and have a date field of when an order was closed. So, not all orders are closed and in this case this field is blank. However when i export to Excel it puts the following in the spreadsheet '00/01/1900' for all cases where is...

Thanks for your input. I was using ODBC to connect but have also tried connecting using Oracle. We are on version 9.2i. We also put latest service pack on two days ago. Same problem. We think that perhaps there is a conflict in the criteria in XI, ie something was ok in 8.5 but now in XI...

Hi all, I have recently moved over 300 reports from 8.5 to XI. Most work ok but a few are getting strange join type errors which i am finding hard to resolve. The latest is as follows: When run an existing 8.5 report in desinger in XI get following error: ORA-25156 old style outer join (+)...

Hi, I am struggling to suppress data in my details section I have a formula @PeriodDue which tells me which period the order is due in If {OAS_DOCLINE.DUEDATE} <= {@Currentdate} then "This period" else If {OAS_DOCLINE.DUEDATE} >{@Currentdate} and {OAS_DOCLINE.DUEDATE} <= {@DateP2} then "This...

Can anyone help before i go mad... I have the following data and i need to get a minimum of the dates, which i have done. However i then need to get the corresponding order and price to the min date to show in the group footer. Detail lines: 13/06/2005 R000038 3,500 03/06/2005 R000035 3,500...

Hello, I am reorganising our Enterpise set up and have created a number of new User groups in the CMC. I want to delete the redundant ones just to save confusion when in the CMC, however when i tick the group and click on delete i get the following error: Update Error There was an error while...

Fantastic..... the report now works as i wanted it to. Thanks very much for all your help. Kaz

The field in the report is actually formatted as a date, if i browse on the field it tells me it is a date field. That has been my main problem, trying to select the date as a string in the parameter (crystal decisions says i need to do this to allow the parameter to remain empty)and then...

Hi, Thanks very much for previous advice, however i'm stuck on a second parameter.I have a date field (it is definetely a date field) crystal decisions suggests setting up a parameter for the date range as a string field and then applying the following (If{?WORDadded}<>&quot;&quot; then...

Thanks very muck K, you were right, it was a string. In every other table in the database this field is a number, i had come across this problem before but had forgotten. Won't forget this again in a hurry. Thanks very much

Hi, Can anyone help. I have a report where the user would like to be prompted for a variety of options, ie Works Order Number, Part Number, Customer Order Number etc. After having spent days trying to get records to show when only one parameter is entered I found an article on Crystal Decisions...

When trying to view a report in ePortfolio (Crystal Enterprise) I am getting an error as follows: Page header or footer longer than a page. File 6a82ec8912c88384.rpt. [On Cache/Page Server: S-REPORTS.pageserver] If i try to schedule the report i get the message that it has failed as it is out...

Thanks all, the Mid function worked great.... Kaz

Hi, I need to extract part of a text field and use this as a formula. I.e. Works order field equals &quot;EBOF 003102 MFIN&quot; (there are 21 spaces between number and MFIN). I am trying to write a formula which pulls out either the 003102 or the MFIN, so this field can be used in another...