Search results for query: *

Hi, I get fields from db datetime tailnumber 2/07/2008 7:02PM N555 2/07/2008 7:02AM N333 2/07/2008 6:02AM N222 I need to create report as a letter where in text those 2 fields will be display as one line ...on 2/07/2008 at 7:02PM,2/07/2008 at 7:02AM and 2/07/2008 at...

Hi how can i sort records in chart i have month_ref and year_ref fields for ex month_ref year_ref 1 2008 1 2007 2 2007 3 2007 4 2007 5 2007 6 2007 ... in chart need to dispaly Jan-07 Feb-07 Mar-07 Apr-07 Jun-07... Jan-08 on change...

Hi How to display on the report revision number or last saved date from file ->summary info (document properties) -> statistics I was thinking to use modification date and time but the date and time are displaying when report run not a last saved time thank you in advance Nat

i have a field address1 : street,suburb,postcode,country. All of the words separeted by comma need to dysplay street suburb,postcode,country if one of them is missing (suburb,,country) then the comma not be dysplayed I have started with that and stuck NumberVar FirstReturn := InStr...

hi, i have cross tab report. Trying to conditionally show the color of cell based on another field . i have 2 fields as 2 row field1 and field2 if field2 >0 then field green what i did selected a cell(field2) ->right click->common->suppress->x+2 and enter: whileprintingrecords; numbervar...

Hi, I have create a advanced bar chart 'on change of'formula @RMT_Label and 'show' 2 values night and day for RMT. If I create group bar chart and show 1 value i can drill down .How to drill down on advanced bar chart? I am using crystal XI thank you in advance

hi, I have datetime field from oracle db 01/01/1000 5:59:59AM 01/01/1000 10:59:59PM How can i round the time to display in crystal xi 0600 2300 thank you in advance nat

Hi, I have a string field '2300 - 0559' .How to display in crystal xi 2300 - 0600 thank you in advance nat

Hi, i am wondering if i can do drilldown on crosstab in crystal XI Regards, nat

I have field(parameter) datetime (01/01/2006 22:59:00)so I create the formula to display time time(field_name) displays me 22:59 but client wants display 23:00 means rounding to next hour thank you nat

In Crystal XI I have a group NMTID and chart is in group header.At the moment it displays 1 chart per a page how to dispaly two charts per a page Thank you Nat

In Crystal XI The label and value on top of each other if you showing both outside slices. Any ideas how to fix it or that is a bug thanks in advance Nat

In the report i have two group first airport second airline.The line chart is in 2 group . the chart displays on change of airline and summ of cda% .Line style makers only. The customer wants display on x -axis name of the airline(British airoline) but on the top of markers code(BAA) not a...

How to display only column grand totals (crystal XI) Thank you Nat

In Crystal XI The label and value on top of each other if you showing both outside slices. Any ideas how to fix it or that is a bug thanks in advance Nat

the logo stores in oracle db as blob datatype when it inserts as a field into report it is not clear (blur)but if insert as picture (OLE objects )- no problem. is it crystal XI issue or oracle thank you in advance Nat

Hi , In crystal XI how can I split columns in cross tab. I am not able to fit across the page all columns .How can I show first 13 and then another 20 1 2 3 4 5 6 7.... 14 15 16 17 18 19 20 ... thank you in advance Nat

Hi, I am trying to display as 00:00 ,1:00 and ....in crystal xi currently I have field with number 0.00 ,1.00 and ... I have tryed the formula totext(left({field},2))+ ":00" does not work for me thanks in advance nat

hi , What I am doing wrong? In my script I have to subqueries first return rownum from 65 to 100 i want to return records with Lmax from 65 to 100 even they don't exist in secod subquery rmtid Lmax ne 1 65 0 1 66 0 1 67 5 2 65 20 2 66 15 ... select...

Hi there, I am using Toad for oracle 9i I am new to oracle.How can I create a stored prog with temp tables.I start with simply one and getting errors.I had created in sql server so now i have to use oracle Here is my code CREATE OR REPLACE PROCEDURE Spcryrpt_TEST (p_recordset OUT...