compressing rows in report details

[Jean]

Using some previous advise to use Can Shrink to compress blank rows in a
report I wondered if anyone could advise on something slightly more
complicated.

I have built a database for billing and have item descriptions, item net
value and item VAT value all on the same row. The Can Shrink will only work
if the empty field is on a row of it's own and if there is no net or VAT
value for that row it shows a 0.00. Is there anyway to suppress zero fields
to fool the report into thinking it's a blank line? Or can anyone with more
knowledge advise if there is any point, I wonder if the Can Shrink purely
picks up that there in another field regardless of whether it is empty or
not to block the Can Shrink feature.

My output report looks scruffy having a column of zero's for no apparent
reason.

Thanks for any help on this

Jean

 

[Douglas J. Steele]

You could put a computed field in the query along the lines of IIf([MyField]
= 0, Null, [MyField]) and use that computed field rather than [MyField].

 

[Jean]

Thanks Douglas

I have have made some trials on my report using this method and with a
little more thought I think I can come up with a workable solution (I have
fields that calculate totals but obviously any null value in the calculation
results in a null total and leaves blanks now where I would like show 0's on
the summary). I shall sort it by formulae - it's only a matter of time.

Jean

You could put a computed field in the query along the lines of
IIf([MyField] = 0, Null, [MyField]) and use that computed field rather
than [MyField].

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Using some previous advise to use Can Shrink to compress blank rows in a
report I wondered if anyone could advise on something slightly more
complicated.

I have built a database for billing and have item descriptions, item net
value and item VAT value all on the same row. The Can Shrink will only
work if the empty field is on a row of it's own and if there is no net or
VAT value for that row it shows a 0.00. Is there anyway to suppress zero
fields to fool the report into thinking it's a blank line? Or can anyone
with more knowledge advise if there is any point, I wonder if the Can
Shrink purely picks up that there in another field regardless of whether
it is empty or not to block the Can Shrink feature.

My output report looks scruffy having a column of zero's for no apparent
reason.

Thanks for any help on this

Jean