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 SkipVought 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: *

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

    Oracle SP returns no data in Crystal

    Since I wanted to check my result set, all I did was dump all fields on the detail section -- hadn't gotten to the point to set any filters or try and get fancy with suppressing groups. Browsing the data in the field explorer shows no results. I'm pretty much grasping at straws as well.
  17. jrennatc

    Oracle SP returns no data in Crystal

    I'm using native and the connection name is the same that I use with both SQL Developer and SQL*Plus. I tried running the procedure in both tools because the white paper says it has to return data in SQL*Plus. I'm getting data in both tools, but not Crystal.
  18. jrennatc

    Oracle SP returns no data in Crystal

    Using IN OUT because white paper says the ref cursor has to be defined that way. How do I determine which connection I'm using. My CR was already set up with all the connections when I started my position, so I'm not sure. Usernames and passwords are the same (we only have one).
  19. jrennatc

    Oracle SP returns no data in Crystal

    I've written a stored procedure in Oracle 8i that takes no input parameters and returns (IN OUT) a ref cursor. When checking the cursor through SQL Developer, the cursor returns data. Using Crystal 9 developer edition, I can see the stored procedure, I can add it to my new report, all the...
  20. jrennatc

    Populating a Reference Cursor

    Is it possible to populate a reference cursor with any other method than a select from a database table? I'm trying to build a table variable and put this data into a ref cursor to pass back to Crystal reports.

Part and Inventory Search

Back
Top