Start a new topic

Conditional Format (Hide Line Items)...

Does anyone know of a way to supress a line item entirely from a purchase order format if the unit cost value is $0 OR a certain field ia empty?


Example..


I group three lines together...


Line A - descriptor only but is in the quote as a BLANK LINE with no part numbers or value.

Line B - a legitimate item.

Line C - a legitimate item.


I have an example attached.


Thanks for looking and help in advance!


pdf

.if.fieldnamehere<>"".or.fieldnamehere<>""


field name here, being something like documentitems->manufacturerpartnumber

Thanks Matt, I appreciate the quick feedback.  I do have a couple follow up questions if you don't mind...


#1.  Do I set this up via REPORT>CONIDTIONAL FONT>NEW? Or INSERT>FORMULA FIELD


I tried entering this into CONDITIONAL FONT and it came back "Field Type Mismatch".


.IF.DocumentItems->UnitCost<>""


Thanks again!

You add this as a filter in the detail section.

No need to worry about conditional fonts, or anything like that.


Basically, the filter in the detail section is used to include (or exclude) certain lines.

What we're saying is, if the part number is blank, skip it and don't display.


matt@prestigequoting.com

Worked like a charm, thank you so much.


-T

Login or Signup to post a comment