Lynne said:
I have a report that lists various employee benefits. If
a particular employee doesn't have a particular benefit,
my report originally printed the label for that benefit
with 0.00 in the amount field. Now they want me to
change it so that if the employee doesn't have a benefit
it just skips it altogether. I tried setting the fields
and their labels to invisible in the ON FORMAT property
if the amount is 0 but it leaves spaces. How can I get
it to print only those benefits that the employee has
without leaving big gaps in my columns?
To close up the space used by control that you've made
invisible, you need to set the control's (and its
section's)CanShrink property to Yes.
I should have mentioned that next to my column listing
benefits, I have a graph showing the relation of total
benefits to total salary. When the graph is there, the
CanShrink won't work. If I remove the graph, the spacing
will shrink but the remaining items aren't evenly spaced
ie if it skips 4 fields the space is larger than if it
skips 1 or 2 fields. The result is a very uneven look. Is
there some way to even out the spacing and keep my graph?
Lynne
