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

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

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

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