Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Line Nme show up more then wanted 1

Status
Not open for further replies.

CrystaLv

Technical User
May 12, 2006
121
US
Hi,
I have Line Name in Details.
It is part of the formula
If {Field1}= 'PP' then "<b>Line LineName:</b>&nbsp&nbsp&nbsp" & {FieldName} else ""

Sometimes I have 3 lines of text. I want to display words "Line Name" just once. And have 3 description underneath.


Sometimes condition {Field1}= 'PP' not met - so I want these Line Names to be invisible.

So I tried to have Line Name as a lable placed into section and supress if duplicate. Then if condition {Field1}= 'PP' not met and i need it blank - I can't have it.
So I made it part of the Formula and now i see it 3 times.

How to make it work, please?

Thanks

 
If you left it as a label you COULD suppress the label with:

isnull({table.field1}) or
trim({table.field1}) = "" or
{table.field1} <> "PP"

If you also need to suppress based on the number of rows, you need to provide more info. Is there a group that corresponds to these three rows?

-LB
 
No words to thank you lbass - just stars!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top