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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inset a blank section/line?

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
Using version 7.0

In the detail section we are listing the name of our products, and then we have a catchall category of "other" (there can be several others on the same page). After each occurance or the word other, we would like to add a blank section/line. My first thought to do this I would need to insert a detail b section and set it to appear only if the last product printed was other.

Is this the best way to do this? And how would I do this?

Thanks
Bennie
 
You must have a formula something like:

if {table.productname} in ["A","B","C"} then
{table.productname} else
"Other"

Because detail_b is reading the same row of data as detail_a, you can just suppress detail_b in the section expert (where you can also insert the b section) by using a formula like this:

{@prodnameformula} <> "Other"

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top