J
Jumbo Shrimps, Jr.
Have a report based on a cross-tab
query that doesn't always have data
for each variable.
List of offices with sales by month as in
Office Month Sales
08388 Dec-06 48,448
09212 Mar-06 22,321
08388 Feb-06 52,338
09212 Jan-07 14,987
etc.
Have a cross-tab query that arrays
data like this:
Office Dec-06 Jan-06 Feb-06
08338 48,448 41,212 52,338
09212 11,288 10,222 9,421
However, for some months there
are no sales for some offices!!
No, I don't care, but when I generate
the report from the cross-tab query,
no values, not even a '0' appears on the
report.
Finance types, of course, cannot have
blanks on their reports, as they think you
are stupid and left that month out.
Is there some way in a report to format
a control (based on the cross-tab query)
such that a "-" appears if
no data - and therefore no control -
for that month doesn't exist?
Or is this a problem that has to be solved
at the cross-tab query with some kind
of IIf expression?
query that doesn't always have data
for each variable.
List of offices with sales by month as in
Office Month Sales
08388 Dec-06 48,448
09212 Mar-06 22,321
08388 Feb-06 52,338
09212 Jan-07 14,987
etc.
Have a cross-tab query that arrays
data like this:
Office Dec-06 Jan-06 Feb-06
08338 48,448 41,212 52,338
09212 11,288 10,222 9,421
However, for some months there
are no sales for some offices!!
No, I don't care, but when I generate
the report from the cross-tab query,
no values, not even a '0' appears on the
report.
Finance types, of course, cannot have
blanks on their reports, as they think you
are stupid and left that month out.
Is there some way in a report to format
a control (based on the cross-tab query)
such that a "-" appears if
no data - and therefore no control -
for that month doesn't exist?
Or is this a problem that has to be solved
at the cross-tab query with some kind
of IIf expression?