Formula based on the value of a smallint type field value

[junction123]

Hi,

I am using Crystal 9.0 and Sql 2005.

If I have column in the report called PendingReds of type smallint,

If that flag(PendingReds) is set to 1

I want to do the folowing
a. add an * after the text object “Withdrawals” which is showed in the report.

I want to add the below to a text object called Footer

b. Add a footnote which should say: “ *Pending withdrawals not included.” This note should only appear if the flag is set.

I am told not to hide the footer by making it white…but use section expert, in order to avoid extra lines on the report

How do you suggest I go about doing this? SHould I first convert the string object PendingReds to a bit? How can I check whether it is set or not if it is defined as type smallint?

Also for b, do you suggest using section expert?

Thanks in advance for any help/ideas.

 

[junction123]

Assuming there is a flag defined the stored procedure that drives the report:

for a) where can I add the formula for text object 'Withdrawls'?
If IsPendingReds = 1 Then 'Withdrawls' + '*'

for b)
If IsPendingReds = 1 Then
'*Pending withdrawls not included'

 

[junction123]

How do I check for a smallint type field value and set the text object to something else? Pleae help