Search results for query: *

thank you LB.It works perfect!!!!!!!!! .Only one little thing - the comma should not be before "and"

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

the report needs to be run from application i can not save with data. is any other option. We need to keep track of last update of the report Nat

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

thank you for the code i have tested and it is showing all previous addresses as well in one string.(record1address ok then for record2 showing record1address and record2 address and so on ) I need for each record. Example :string in db Private Bag 92007,Auckland 1020,,New Zealand need to...

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

lbass it is working now .I have deleted everything and did again. Thank you all of you for your time . PS dgillz i did not want to upset you

sorry digillz , I am not ignoring you :).I did not understand u ask me if it was evaluated i said yes if you look at my first post whileprintingrecords; numbervar mis_days :=currentfieldvalue; true -- no needs to display a field in cross tab that what i have. For Lbass yes i am...

it is evaluated to true no need it to show in cross tab

no error no color

I have tried lbass and dgillz options did not work for me. I may be a bit more specific I am using crystal XI in cross tab rows: rmtid,location columns: @Label_month_year(MonthName (tonumber({t.MONTH}),True)+' '+totext({t.YEAR})) , timeofday(day,night) summarized fields: @missing_days(if...

the field1 and field 2 are summarized fields

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

ok let me give your more info the report based on stored procedure which returns rmtid and night ,day rtmid night day 1 20 10 2 30 10 .... the chart shows bars 'on change of'formula @RMT_Label and 'show' night and day values.I need to drill down by clicking on bar...

I have created group RMT_label and hided them I can not base the bar on the group.I need to show 2 bars(night and day ) for one RMT and then once they click on one of the bar for RMT1 will drill down for the details

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

it was nothing wrong I have used your and lbass formulas. thank you for that .The question a bit different to previous so i thought it would be better to post a new question.next time i'll post as the same question Thank you

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