Search results for query: *

Thanks a lot CoSpringsguy .... and I would like to know one more thing ... Why is it I dont see an option to edit my post .... If i want to make any changed to the post tht I already posted I dont see an edit option .... I have to type in the whole thing again with the changes .... or am I not...

we did that because without that we might not know which one is null DBfield1 DBFieldTest1 DBFieldTest2 bike, bike, car NULL;2;3 abc;def;NULL without the NULL text it would look like this DBfield1 DBFieldTest1 DBFieldTest2 bike, bike, car 2;3 abc;def which is reallly gonna mess things up...

:) OK. we have made those null values to be displayed as NULL (- TEXT) in DB .. to make it easy ... when u get time help me out .. Thanks

sorry I copy pasted the last part in the above post ... so please ignore the last line which says null = blank value .... NULL is a text in DB and not blank and I want to omit it as shown above .... Does your formula handle that case?

sorry if it is null it ll b as NULL(text) not blank .. it ll have the value as NULL and I should not show that value ..... its more like DBfield1 DBFieldTest1 DBFieldTest2 bike, bike, car NULL;2;3 abc;def;NULL the above can be considered as the 8th case ...... this should display in the...

I have a different question though ... does your formula handle the case which I mention below DBfield1 DBFieldTest1 DBFieldTest2 bike, bike, car null(blank);2;3 abc;def;null(blank) the above can be considered as the 8th case ...... this should display in the report...

yes CoSpringsGuy I solved that issue ... Thanks for responding

CoSpringsGuy, I need your help again. WhilePrintingRecords; local stringvar array a1; a1 := split({Command.FF},"/"); local numbervar i; local stringvar R1; for i := 1 to ubound(a1) do ( ( R1 := R1 + " " + mid(a1[i],1) + "," ); R1 := left(R1,len(R1)-1); ); R1 I am...

CoSpringsGuy, I dont see why yu say its an unusual method .. your formula is awesome ... Thanks a lot again for the explanation ..

CoSpringsGuy, Thanks a lot for the help but I am sorry if its too much to ask , I figured out the rest but can you tell me what this part of ur code is doing. I want to learn and am very much interested how this works ..... local numbervar array max := [p1,p2,p2]; if p1+p2+p3 = 0 then...

CoSpringsGuy, You are awesome ... it works like a dream ... Thanks a lot .... I would have treated you for this if I got a chance ;) .... Thanks a Tonne

Madawc, Thanks for the response. Can you tell me how to handle that Null value case in the formula. Thats the problem I am having now.

Giving a clearer view of what I want as the post above did not come up clearly . DBfield1 DBFieldTest1 DBFieldTest2 flight null null cycle 2 null...

Hi all, I need some help with CR 2011 formula Need to do something like this DBfield1 DBFieldTest1 DBFieldTest2 flight null null cycle...