Search results for query: *

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

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

Dell, According to your suggestion, When i am leaving my parameter empty, getting "Zero" record (which is wrong) but when I am entering the parameter value (LEAP) "getting all LEAP records (fine now). As I said earlier, I would like to display records base of parameter's input. Parameter...

Thanks Pete for your reply. After modified my code according to your suggestion, When i am leaving my parameter empty "getting all Null values" (which is fine) but when I am entering the value (LEAP) "getting all values (Null + LEAP). My requirement is that if user leave Alert parameter...

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