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!

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

Recent content by jrennatc

  1. jrennatc

    Pull an inventory of recurring events information in .xls

    You can code a custom csp page to run a query of all the recurring instances and put it into an html table where it can be cut and pasted into excel. I haven't found a good way to get the complete list of parameters, but you can get the rest of the info fairly easily.
  2. jrennatc

    Java Class in Oracle Timeout

    I have a java class that was loaded to our Oracle 8i database. The java's purpose is simply to go out to a SQL Sever database and return some data in an XML string to our application. We've encountered a problem recently where it appears the statement that calls the java never completes which...
  3. jrennatc

    infoobject count stops at 1000, how to increase?

    The only way I've been successful at obtaining the path to a report is by using the parent id to query the parent object until you reach the top level. '*********************************************************** 'Get the path '*********************************************************** Dim...
  4. jrennatc

    CE Print Engine Error on Dates?

    My theory of too much data is blown. I just ran it successfully with a 4th quarter date parameter which includes all of October and part of November.
  5. jrennatc

    Re-publishing a report

    You could try temporarily renaming the report to get it to the top of the list, then saving over with Crystal Reports. Then just rename afterwards.
  6. jrennatc

    Re-publishing a report

    I have the same issue with user folders. When attempting to view the Enterprise folders from Crystal Reports, I can only see the top 20 or so.
  7. jrennatc

    CE Print Engine Error on Dates?

    I am running CE9. I have a report with a date range parameter like this: (IF {?DateType} = "Date Range" THEN {SW_CASE.SWDATECREATED} > {?Startdate} and {SW_CASE.SWDATECREATED} <= {?EndDate} ELSE IF {?DateType} = "Last Full Week" THEN {SW_CASE.SWDATECREATED} in lastfullweek ELSE IF...
  8. jrennatc

    Report to list all reports on Crystal Enterprise

    For CE9, I used a csp page that outputs to a table detailing the report name, report path, how many instances, and the average runtime. I believe CE10 will use similar syntax. The code could be altered to ouput in XML format which a report could be created against. <HTML> <META...
  9. jrennatc

    Extracting information from CE using XML/CSP

    If you want to return more than 1000, you have to specify in the query... SELECT TOP 6000 SI_NAME, SI_ID ... It's a Crystal limitation I believe.
  10. jrennatc

    Report Instances Hang in Running Status

    The query is no longer present on the database. I just made it occur again, and I watched the query running (went for about an hour) and then it disappeared from the database side. The instance in Crystal is still showing a "running" status and has been for at least two hours after the query...
  11. jrennatc

    Report Instances Hang in Running Status

    I determined they were hanging when they showed running status for over 10 hours when past runtimes had shown half an hour or less. It's happening on both recurring reports and single scheduled instances.
  12. jrennatc

    Convert Number to text Decimal Places

    the totext function will take a parameter of decimal places, so do totext(policyholder, 0) to get no decimals.
  13. jrennatc

    Report Instances Hang in Running Status

    I'm using CE 9 with Oracle 8i as the back end. We run a majority of our reports overnight. Occasionally we have report instances that show a status of running much longer than the normally should. A check of the datbase sessions shows that no Crystal Reports are currently running. I've...
  14. jrennatc

    Query to return all objects and last run-times from e-portfolio 8.5

    I use the code below as a standalone csp page on the production server, it returns a grid of all reports when they were created and the last time they were run. I'm using it on CE 9, but you should be able to modify it for CE 8.5. <HTML> <META HTTP-EQUIV="Content-Type" CONTENT="text/html...
  15. jrennatc

    Oracle SP returns no data in Crystal

    From the white paper: If you are using the native Oracle driver and using hard-coded date selection within the procedure, the date selection must use either a string representation of the format 'YYYY-DD-MM' or the TO_DATE function... Gist of the matter was that I had a hardcoded date that used...
See more

Part and Inventory Search

Back
Top