Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: farside11
  • Content: Threads
  • Order by date
  1. farside11

    DateTime selection inconsistency

    Hi there, I use Crystal Reports and Crystal Enterprise v10, reporting from an Oracle 9i database in a Unix environment. For this report, I have a single table data source that contains records of jobs run. Each record contains the job's Start_DateTime and the Finish_DateTime - however, they...
  2. farside11

    Large Delimited Text Files

    Has anyone ever experienced limitations on the file size for an exported, delimited text file from Crystal v10? We run reports through CE v10 off an Oracle 9i database on a Unix (Solaris) platform. Up to now, no problems, but the largest file size is about 30MB. We expect to increase to...
  3. farside11

    Stored Procedure Summarisation Issue

    I am using Crystal Enterprise XI, oracle 10g and have the following issue with a very large financial reconciliation report. The report needs to run for a date range and for a Location and then for a site or sites within that location. I have created an SP which has the from & to dates as...
  4. farside11

    Oracle Stored Procedure Not appearing in data source

    Hi, I am using CR10 with oracle 9i and native driver connection. I have created a stored procedure within a package ie consisting of the package & package body - all as per the BO white paper. However, when selecting SP for data source it does not show up and yes the SP option is ticked under...
  5. farside11

    CR10 csv output format unsuppressing records

    We are running CE10 on a unix platform and need to produce monthly stat files. These can be VERY large and the output needs to be to pipe delimited txt files. However, due to the ongoing bug in crystal, of csv exports not doing the suppression, this a real headache for me. I cannot export to...
  6. farside11

    How to force collate for duplex printing from CE10

    We have a report which is printed in duplex, (controlled by printer settings), however, it will not collate when multiple copies requested. ie. the 2nd page 1 prints on the back of the first page 1 etc. Is there any way to imbed a proscript command to force collation? Thanks.
  7. farside11

    Text File Date Output Reversed

    Hi there, We have CE 10 (on a Unix platform) reporting from an Oracle 9i DB using the Native Oracle driver (CE doesn't support ODBC on Unix). If I schedule reports to output as Crystal Reports, or Excel files, the date format appears as DD/MM/YY, which is correct - for Australia! However...
  8. farside11

    Default Date Parameters in CE

    Hi there, I am having trouble running reports from CE 10 which needs to run automatically for the previous day. In CR, when running a report with a date parameter, the parameter defaults to the CurrentDate. This makes it easy to create conditional Record Selection, such as "if {?Date} =...

Part and Inventory Search

Back
Top