Search results for query: *

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

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

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

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

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

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

Hi, My main report is grouped by a formula (QTR_Desc) and my subreport is grouped by a formula (QTR_Desc). Both formulas are the exact code: DatePart (&quot;q&quot;, {NEW_BUS_DM.TRANSACTION_DT}) & &quot;Q&quot; I have my subreport in GH1a in the main report so that it runs first. All the...

Hi, I have a main report with 2 subreports (sub1 and sub2). Both subreports are in the report footer in the main report. Sub1 is grouped by months of 2002 and sub2 is grouped by months of 2003. I need the grouped amount of 2003 in sub2 to go to sub1 because in sub1 I will need to do a group...

Hello, Is there a formula or method to join 2 tables each with a date (YMD) field by using only the year and month (ignoring the day) of each table? For example: Table A Table B Trans_date Plan_Date Color 2003-10-21 2003-09-01 Blue 2003-10-22...

Is there a Date function or or do I have to write a formula to determine the week number of a given month (see output example below) Week Total Premium Period Amount Sept 2003 Week 1 $45.00 (ex. this input date would be between 09/01/2003...

Hello, My questions 1- is there a function or formula to determine the week number of a given month (see output example below) 2- is there a function that shows the number of workdays in a given week (see output example below) My final report is to group them by week number Input...