Search results for query: *

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.

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

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

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.

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.

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.

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

...& "</A></TD>" & _ "<TD>" & rsRow.Properties("SI_UPDATE_TS") & "</A></TD>" & _ "<TD>" & rsRow.Properties("SI_CREATION_TIME") & "</TD>" '************************************************************************** 'Get the path...

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.

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

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.

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

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

...& "</A></TD>" & _ "<TD>" & rsRow.Properties("SI_UPDATE_TS") & "</A></TD>" & _ "<TD>" & rsRow.Properties("SI_CREATION_TIME") & "</TD>" '************************************************************************** 'Get the path...

...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 a date format of 'dd-mon-yyyy' which worked fine in SQL*Plus. So I changed to use the TO_DATE function.

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.

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.

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

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.