printing boxes

[edgare]

ok i got a field its a string ... I need to create a text box that will print lets say one * if the contents contains 10 and ** if contents contains 7.5. The string has alot of alphanumerical data sometimes not just the 10 and 7.5... How do I do this? I am using 8.5.

Thanks

 

[Naith]

The caveat here is that I haven't seen an example of one of the records with extraneous data in it, but the following would seem to address your concerns.

Create a formula along the lines of:

If InStr({Your.Field},'7.5') > 0
Then "**"
Else
If InStr({Your.Field},'10') > 0 
Then "*"
Else ""

This assumes that a record can't have both 10 and 7.5, but if it does, the 7.5 will take precedence.

Activate a border around the formula when placed on the canvas. Conditionally suppress the border with

If CurrentFieldValue in ["7.5","10"]
Then 1
Else 0

Naith

 

[Turkbear]

Hi,
Exactly what is the relationship between the data value in the field and the # of *s you want to show?

You can create a formula using the
ReplicateString function to do what you want, once the relationship is set:
For Instance, if you want a * repeated as many times as the value in the field:

@ShowAster
ReplicateString('*',tonumber({field}))

To Paraphrase:"The Help you get is proportional to the Help you give.."