data section labeling of data

[mart10]

I am using Crystal XI

I have the following possibility in the data section and output records

LABEL AMOUNT
interest 10 ( or -10)
interest 1 (or -1)

I need it to read

interest 10 (or -10)
WHT 1 (or -1)

but sometime the data maybe

interest 1
interest 10

in which case it needs to be

WHT 1
interest 10

etc

In other words the word WHT is allways to be applied to the lowest absolute amount

To complicate it further sometimes there is just 1 interest line

eg

interest 10

in this case then the wording needs to remain just interest as no WHT is being applied on this account (Withholding Tax)


How can I do this if the info is in the detail section- , is it through evaluate while printing or something?

This is very urgent I know everyone says this but it is

 

[lbass]

So you are disregarding the sign in determining what is the lowest amount? If so, you could use the following instead of your label field:

if int({table.amt}) = int(minimum({table.amt},{table.groupfield})) and
count({table.amt},{table.groupfield}) <> 1 then
"WHT" else
{table.label}

I'm assuming you have some group you are evaluating this within.

-LB

 

[mart10]

Yes from memory it groups on the account no and then the data just comes in randomly on the data line

I will try this and get back to you if not sucessful

thanks