I wrote the Switch statement below and it works fine except that for the first condition were it test for NULL it does not display the text when that condition is true. By the way I am using it to group on six (6) departments. So it will display a group header for "Cost of Goods" or "Administrative" but for the group that test for null the group header text is BLANK. Any Ideas on how to fix this?

 

Switch
(
{@Null Test} = 1, "01 Sales",
{@Code Base 2} = 1, "02 Cost of Goods",
{@Code Base 3} = 1, "03 Marketing & Business Devel. Expenses",
{@Code Base 4} = 1, "04 Administrative",
{@Code Base 5} = 1, "05  Growth Expenses",
{@Code Base 6} = 1, "06 Other Operating & Administrative Expenses"
)

 

This null test works fine as far as I can see. It is evaluated correctly and let's me create the groups that I need for a report with the exception of returning text for the group.