Search results for query: *

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

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

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

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

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.

I have a particular report in CE9 that has 11 instances in the history all listed as Acrobat format. When I click on the link to view 9 of the reports, they give me a pdf viewer error. I did a little digging into the CE instances and found the following data: SI_PROGID SI_FILE1...

I have a report (version 9) that uses running totals to get conditional counts. I then use the counts to suppress sections. The report runs great from my PC and shows 0's for the counts when no records exist. When I put it in Crystal Enterprise, the zeros do not appear (just Nulls) which...

I'm working in Crystal 9. I have a Top N report where the business unit wants to see the Top 5 groups along with the percent of total records and the percent of top 5 records. I can get the percent of total, but can't seem to get the percent of top 5. The structure should look like... Call...

I have a report that distributed via FTP that I frequently get the error: connection error. CrystalEnterprise.Ftp: WSA10054. Does anyone know where to obtain an error list so that I can try to figure out why this FTP fails?

We are running CE 9 across two servers. I had one report fail last night out of over a hundred due to the error listed above. When I checked the application log, I see that it goes more than ten times a day (8/25/2004 7:25:31 AM Crystal_pageserver Error PageServer 35209 N/A USWISNTWS414 File...

There was a previous post on how to modify the schedule.csp page to restrict access to scheduling reports by userid. Does anyone know the appropriate syntax for the csp page to reference a user group. We run reports out of our productions system and we want to restrict users in particular...