Report null values

[JonWayne]

I have a report that is based on a Crosstab query. The query returns
Year-Quarter columns based on a date field. I need the report to show 1st to
4th quarters and YTD values, even if there the underlying recordset doesnt
have dates in all 4 quarters. I created some dummy records and set their
amount fields to 0 (since my query groups records by summing the Amount
field - setting the dummies to 0 wont affect the total), but, in the report,
how do I get the dummy Amounts to display a 0 instead of Empty?

Thanks

 

[Wolfgang Kais]

Hi "JonWayne".

I have a report that is based on a Crosstab query. The query returns
Year-Quarter columns based on a date field. I need the report to show
1st to 4th quarters and YTD values, even if there the underlying
recordset doesnt have dates in all 4 quarters.

Open the properties window in design view of your crosstab query and
Set the ColumnHeadings property to the list of column headings you want.

I created some dummy records and set their amount fields to 0
(since my query groups records by summing the Amount field - setting
the dummies to 0 wont affect the total), but, in the report, how do I
get the dummy Amounts to display a 0 instead of Empty?

Don't use dummy records, Use column headings instead. In the report based
on the crosstab query, use textboxes with ControlSource like this:
=Nz([DataField],0)