Recent content by kamkaro

Hi Skip, when I am using my following Main query, getting Invalid Number error; select fit.acct_id, sum(fit.kwh) kwh from ( select sa.acct_id, to_number(adjc.adhoc_char_val) kwh from cisadm.ci_ft ft, cisadm.ci_sa sa, cisadm.ci_adj_char adjc...

Skip, Still getting same error "ORA-01722: Invalid Number". It seems to me sum() can't convert varchar2 to Number data type in crystal report . Thanks.

Hi Skip, After run the above query, I got the total 93 records, for your reference, I am pasting few records below. If you want so I will past all 93 records. User wants to sum up KWH (amount) for each Account ID if there are more than one (same) Account ID. Account ID is not PK though...

Hi Skip, Group by acct_id only, still getting same error when I am using Sum() function for KWH. Any other thoughts? Thanks.

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, Code: where SA.SA_STATUS in {?status_flg} The above code is working perfectly fine. I can chose more than one values. 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...

I am sorry if I did not explain properly. Let me try again. If I have the following 4 Max fields or formula {Max of Command.STATUS_DECS_1} = F {Max of Command.STATUS_DECS_2} {Max of Command.STATUS_DECS_3} {Max of Command.STATUS_DECS_4} = K Currently, my output result is showing STATUS_DECS_1...

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 Dell, Yes you are right, I am using the command expert. After modified my code according to your suggestion, I am still getting the "Empty parameter value" error. What should I do? Thanks.

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