S
Suzi Carr
Hello,
We have a basic report that prints a customer's name followed by their order
detail lines (part#, qty, price, ext price, etc). We setup the detail
section to print the rows tightly together like we want. To ensure that all
customers appear on the report -- even those without orders -- we use a
query to LEFT JOIN the Customer file to the Orders file. However, customers
without orders have a blank detail line and we want to eliminate that wasted
space. We are running into trouble though and here is what we tried (btw,
there are no graphics/lines in the detail section)
1. Set Can Shrink=YES for the detail section. That didnt eliminate the blank
lines.
2. Set Can Shrink=YES for the controls in the detail section. That results
in no detail lines printing for ANY customer, even those with orders. Where
the orders should have printed, only white space now appears. For example,
if the customer had 10 order lines there are now 10 lines of white space for
that customer.
3. Set both Can Shrink=YES and Can Grow=YES for the controls in the detail
section. This did eliminate the blank line for customers without orders as
we wanted, and did print the order details for other customers too. However,
the detail lines are now not tightly grouped together.
I would like to eliminate those blank lines for orderless customers AND keep
the detail lines tightly together for customers who do have orders. Can
anyone tell me if this is possible.
Thanks, Suzi
We have a basic report that prints a customer's name followed by their order
detail lines (part#, qty, price, ext price, etc). We setup the detail
section to print the rows tightly together like we want. To ensure that all
customers appear on the report -- even those without orders -- we use a
query to LEFT JOIN the Customer file to the Orders file. However, customers
without orders have a blank detail line and we want to eliminate that wasted
space. We are running into trouble though and here is what we tried (btw,
there are no graphics/lines in the detail section)
1. Set Can Shrink=YES for the detail section. That didnt eliminate the blank
lines.
2. Set Can Shrink=YES for the controls in the detail section. That results
in no detail lines printing for ANY customer, even those with orders. Where
the orders should have printed, only white space now appears. For example,
if the customer had 10 order lines there are now 10 lines of white space for
that customer.
3. Set both Can Shrink=YES and Can Grow=YES for the controls in the detail
section. This did eliminate the blank line for customers without orders as
we wanted, and did print the order details for other customers too. However,
the detail lines are now not tightly grouped together.
I would like to eliminate those blank lines for orderless customers AND keep
the detail lines tightly together for customers who do have orders. Can
anyone tell me if this is possible.
Thanks, Suzi