At 09:16 PM 8/18/2004 -0500, Doug Hamilton wrote:
How do I get a crosstab report to display a row
in the report for the rows in the table where the
column (Subdivision) in the table has a null value.
Doug,
By default, NULL values are skipped in a CrossTab
report.
But, if you would like to include the NULL values
in R:BASE 7.1 CrossTab report, you need to set the
option of Skip Nulls to False.
Here's how to do that:
01. While in Report Designer, right-click on the
CrossTab control placed on the band and then
select Configure...
02. While in Configure CrossTab window, click on
the "Subdivision" cell (in your case) and
then right-click to un-check the option for
"Skip Nulls".
03. Click on [OK] to save CrossTab configuration.
04. Use [Report Preview] tab to preview while in
Report Designer.
05. Save the report.
That's all there is to it. That is your tip of the day!
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
