Search results for query: *

Never mind. I found the problem. There was no need to put the Uppercase() function. Now it looks like this and I did not get the error: {ZEKE_JOB_HIST_V.JOB_NM} = {?Job_name}

Hi, I'm using Crystal Reports XI with an Oracle database. I changed my dynamic parameter field {?Job_name} to allow multiple values. When I run the report, an error message is displayed in the Records Selection Formula Editor with the parameter field {?Job_name) highlighted...

Here is my SHOW SQL in Crystal Reports: SELECT "BACKUP_HIST_V1"."START_TIME", "BACKUP_HIST_V1"."END_TIME", "BACKUP_HIST_V1"."TIME_TAKEN_DISPLAY", "BACKUP_HIST_V1"."OUTPUT_BYTES_DISPLAY", "BACKUP_HIST_V1"."OUTPUT_BYTES_PER_SEC_DISPLAY", "BACKUP_HIST_V1"."DF_SIZE", "BACKUP_HIST_V1"."AL_SIZE"...

I tried MJRBIM's suggestion and I am still getting the same results. RESULTS: DB Name {BACKUP_HIST_V1.START_TIME} {BACKUP_HIST_V1.END_TIME} DDD 04/FEB/08 16:49:25 04/FEB/08 18:40:43 EEE 04/FEB/08 16:49:57 04/FEB/08...

Hi, No, those 2 records SHOULD NOT be included based on the record selection. I have an AND condition in the record selection. PARAMETERS: Start_date -> 2008/02/03 End_date -> 2008/02/04 RESULTS: DB Name {BACKUP_HIST_V1.START_TIME} {BACKUP_HIST_V1.END_TIME} DDD...

Hi, CR 10 Oracle Ora10gR2 I have 2 parameters {?Start_Date} and {?End_Date} with the following record selection criteria: ( If {?Database_Name} <> 'ALL' then {BACKUP_HIST_V1.DB_NAME} = {?Database_Name} else if {?Database_Name} = 'ALL' then true ) and ( if {?Start_Date} <>...

Using DB2, I put the double quotes around the qualifier which is "BP" and the table name which is "DATE_DMN_T". I removed the double quotes only on the qualifier and then tried other combinations and still got the same error message when compiling the SQL expression: Error in compiling SQL...

I'm using DB2 database. You may be right. I cannot use subqueries in the SQL Expression. As you suggested, I removed the alias "A" and also enclosed the table names with double quotes or parenthesis and it was not successful. Still got the error message when compling the SQL expression...

Hi, I'm using Crystal Report 10 (will soon be upgrading to XI) and using DB2 tables. Every month, I open Crystal reports and change the dates in the record selection criteria. I would like to stop manually changing the dates in Crystal and automate this report and then schedule it in CE. I do...

Hi, I have CR 10 and having problems in the record selection. There is a field in a DB2 table that all it has is YYYYMM values. For example this field FSCL_YR_MTH_NUM has 200501, 200502, ... 200712. The field datatype is NUMERIC. My report needs to extract the previous month. For example today...

Thanks all and I appreciate it. I can't use SP because you must go thru hell to have DB2 dba approve it. I used GJParker's suggestion 1) Insert as a subreport in the report header. In the subreport, I created 5 formulas: (one formula for each total, below is one of the five formulas, called...

Hi, In CR 8.5, how can you create a summary page in the Report Header as follows: Top 25 Premiums 9999.99 Next 50 Premiums 9999.99 Next 100 Premiums 9999.99 Balance 9999.99...

Hi, I have Crystal Reports 8.5. My GH#3 is grouped by Birthdate and it has the following fields: Birthdate Contract_no Min of Transdate Min of Transdate field was created because a Contract_no could repeat in the table and I only need the first occurence (i.e. earliest Transdate) of...

Your suggestion worked !! Thank you very much. The only problem is the time it takes for the report to go to page 2. There are 700,000 records and running on a Pentium II (RAM 256M). In the Preview tab, when I click the right arrow to go to page 2, the Status Bar displays Formatting Page 2...

Hi and Happy New Year to all ! I was given this DB2 SQL subquery to convert to Crystal Reports 8.5. My company won't allow me to create a SP or View and want to know what other options I have. Here is the SQL subquery: select A.CONTRACT_NUMBER, A.AGENT_ID, B.DIST_GRP_NAME from NEW_BUS A inner...

Hi, I have Crystal Reports 8.5 and for our french clients we need to put a space as a thousand separator and a comma as a decimal separator in a field that is defined as TEXT. For our english clients, we use commas as thousands and a point as a decimal separator. How can we do this in a TEXT...

Thank you for your response! About the theory that you mentionned is flawed, I forgot to specify that this report is scheduled to run only on Mondays, which I think the theory is not flawed now. I am eager to use the @startdate and @enddate fomulas you created. But for the @enddate, if the...

Hi, I am using a CR 8.5 with an ODBC connection to a DB2 table on the mainframe. The table has about 45,000 records. The problem I have is that the simple report takes very long too run. It takes about 5 minutes to run. It is not a problem now but in 2 years when there will be hundreds of...

Yes it worked !!! I got all the the 4 values from each quarter of each subreport and the divisions are correct in my main report. Thank you very much LB ! [smile]

Thank you for the response LB. Good idea on the underlay feature. This means that based on the last example above, I should have a total of 8 shared variables that will be passed to the main report and displayed in the main report. Is this correct? In your example above; whileprintingrecords...