Search results for query: *

Hi All, I am having difficulties for sum() function, getting ORA-01722: Invalid Number error. Problem: My following simple query working fine in both Oracle(Toad) and Crystal Report (SQL Expression) select sa.acct_id, adjc.char_val KWH from cisadm.ci_ft ft...

Hi All, Problem: In my store procedure, I have a column ABC which data-type has varchar2. Column ABC contain numeric and non-numeric values. I would like to convert varchar2 to in Number. When I am using to_Number() function, it throw me "invalid Number" error. When I used "regexp_like(ABC...

Hi All, For Multiple value Parameter, my following code is working fine in Expert command. Code: where SA.SA_STATUS in {?status_flg} Now I am using the following code for default value (If user does not enter anything then crystal report use default); Code: WHERE SA.SA_STATUS_FLG in...

Hi All, Please help me here. I have 4 columns where I used max formula in order to get only one value. Now I want to display all four values on report header. After insert the following filed into the Report header I am getting all values accordingly with no issues. {Max of...

Hi All, Requirement: Created one String parameter {?status_flg} where user can chose multiple values. Using: After created the String parameter, I selected the "Allows multiple values" check box, but when I am calling this parameter {?status_flg} in my Command(SQL expert), getting error 'right...

Hi All, Please give me your expert suggestions, when I am creating the formula, getting the following error. Function: if {?Start_date} = '' then {Command.LAST_MONTH_ST_DT} else {?Start_date} Error: A date Time Required Here for {Command.LAST_MONTH_ST_DT} . Where: {?Start_date} is String...

Hi All, As I am new CR developer, please help me regarding to sub report parameter's links. My main report is pointing to DB package along with 3 parameters (P_start_dt, P_end_dt, Leap_flag) and my Sub-report has Command query where I created 3 parameters (start_dt,end_dt,leap_flag) which I...

Hi All, I am using Crystal Reports 2008, I have two parameters setup ... one is for a string and one is a date. I added these to the Select Expert and if they are both filled out by the user then the report works fine ... For scheduling, if date parameter leave blank than date parameter...

Hi All, I created one main Report and couple sub reports with the on-demand and Suppress options. Both Main and sub reports are working fine from Crystal Report designer but when I am opening from InfoView "sub reports" are not showing/displaying, only Main Report is displaying from InfoView...

Hi All, I am trying to create one User parameter (Data type is string) where if user does not enter any value, crystal report should consider NULL value. When i am creating parameter from Command, does not allow to change Optional prompt (False to True) in Edit parameter though. Could...

I would like to allow my users to enter 2 parameters (Start and End date) in the primary report and have that parameters be passed in some manner to the sub report. Ideally, user makes one parameter selection and have that parameter work in my primary report as well as in the sub reports as...

Hi All, I have 1 Main Report and 3 Sub Reports (same Database), and would like to Export into Excel file/format. Please see the following questions where I am facing issues; 1) If I choose on-demand and Suppress option in Sub report format, I am not able to see Sub Report data in Excel. 2) If I...

Hi All, I created one main Report and couple sub reports with the on-demand and Suppress options. Both Main and sub reports are working fine from designer but when I am opening from InfoView "sub reports" are not showing/displaying only Main Report is displaying. In order to display Sub reports...

Hi all, I am using Crystal report 2008, Exporting Main and sub-reports into the one Excel file, Main report is fine but sub-reports appear blank when I am selecting the Suppress option under Format Editor (my sub report is under Page Header section not in detail though). Basically, I am doing...