Partition in a crosstab query

[Jeff]

Someone a few months ago explained to me how to use a partition
command in a cross-tab query to create 3 distinct categories based on
a number value. It's been working great, but in some cases, there is
no data for the categories and in the report, an error message pops up
that [1:12] is not a valid field name. (That's correct because no
values are between 1 and 12.) Is there a way to populate 1:12 with a
zero in the crosstab, so that the message will not appear?

Thanks

Jeff

 

[Marshall Barton]

Someone a few months ago explained to me how to use a partition
command in a cross-tab query to create 3 distinct categories based on
a number value. It's been working great, but in some cases, there is
no data for the categories and in the report, an error message pops up
that [1:12] is not a valid field name. (That's correct because no
values are between 1 and 12.) Is there a way to populate 1:12 with a
zero in the crosstab, so that the message will not appear?

Not at all elegant, but if you can determine the exact
headings from the Partition function, enter them into the
query's Headings property.