Search results for query: *

Why dont you insert a Summary on that(MAX).I guess it should work

If ( Trim( Cstr({GermReadings.FinalGermDate})) = "" OR IsNull( Cstr({GermReadings.FinalGermDate})) OR Date{GermReadings.FinalGermDate} = Date(0,0,0) ) Then "**Germination will follow" Else

Yeah use the boave formula, it should work.

Yeah it should work, but are you having the time field too?, If ({GermReadings.FinalGermDate}) = (NullDate,Nulltime) then "**Germination will follow" Else " " You mentioned above statment, but you are using only DateField not Both Date and time field. So i guess you have to use If...

Oh Im sorry I dint see that was a time field.Try this If Isnull (ToCHAR({GermReadings.FinalGermDate}))=TRURE then "**Germination will follow" Else " " Not sure this will work. But give it a shot. COnvert the date field into string format first.Thanks.

Try this If Isnull ({GermReadings.FinalGermDate})=TRURE then "**Germination will follow" Else "

Try this Formula:Time2 if tonumber({Table.Field})<100000 then "0"+ totext(tonumber({Table.Field}))else if tonumber({Table.Field})<10000 then "00"+ totext(tonumber({Table.Field}))else if tonumber({Table.Field})<1000 then "000"+ totext(tonumber({Table.Field}))else if...

I will give this a try. Thanks for the info AKS. M

Actually I evaluated on chnage of record Called AISLE, and I did a group on zone. So I Gave reset on change og Grop (Zone). It works fine now. Sorry I was not clear before. Thanks LB, M

Im sorry, I figured there was a different field I can use that as condition in running total. Thanks. M

Yeah I tried that and did a running total but still it dosent work.

Hello friends, this is my case Example: ZONE Case Volume AB AB01 10 AB AB01 20 For this Case I should Get Total Volume 30 ZONE Case Volume AB AB01 10 AB AB02 10 For this case I should get Volume 10 ZONE Case...

Sorry forgot to mention I have to Sum the voulume only when fields Under case is constaant, even if it is blank i can sum. Problem is if there is Blank record and a data record are both combined.. Thanks.

I have data like this Zone Case Volume AB01 DCDC 10 AB01 DCD2 10 AB01 DCD3 10 For this Total Volume should be 10 for Zone AB01 Zone Case Volume AB01 10 AB01 10 AB01 10 AB01...

Im sorry LB, this was not even my report and they gave me a deadline this evening, was lil nervous. I am really sorry about that. And I want to thank you so much for your time, this worked awsome. I am learning lot of stuff from this site. Again I am sorry and many thanks. M

Any help please on this. M

Sorry LB, for some reason I am getting 0 for c and If i chnage that to B i get zero there too. I will give you my formula Formula1: If {E_AUD_LOG.ELEM_DESC} = "MAKE CARTON PACK" then {E_AUD_LOG.TA_MULTIPLIER} Formula2: whileprintingrecords; numbervar elementA :=...

Hello LB thanks a lot for quick reply I did what you suggested but I am getting 0 there like A 20--------------Group Header B 5--------------Group Header C 0--------------Group Header I am getting right data for A,B but not c . I will explain in more detail I did group on on...

Hello friends need some help on this I have group on field A and anfd Im showing Summary in Group Headrer on Units. Below is the example data Group Summary A 20--------------Group Header B 5 C 1 thing is i want to show whatever the summary value I get for A , I want to show...

I had this problem too, When we convert the string format date 1,166,801,760 to number in the formula and then if we group on it date field in the detail section will be messed up. For some reason it dosent show right data. But indtead if we group on the original string format data and use the...