Hello Everyone,

   I have a group based on table.desc with customized group name as follows:

if table.desc = ""
then "...."
else
REPLACE({table.desc},"Total ","")

   I have a suppress formula for Group Header as below:

 

{table.desc} = ""

OR {table.desc} = "SUBHEADER"

OR{ table.desc } = "Total Net Income"

or { table.desc } = "Total Unrealized Gain/Loss"

 

   I have fields in Group Footer, Whenever there is no data for {table.desc}="Unrealized Gain/Loss"(I mean if the entire row is 0) then I am suppressing the Group Footer section as below by having a formula for suppress property of Group Footer section:

(Sum ({@Act Amt CM Inc}, {table.desc}) = 0 and
Sum ({@Bud Amt CM Inc}, {table.desc}) = 0 and
Sum ({@Bud Var CM Inc}, {table.desc}) = 0 and
Sum ({@LY CM Inc}, {table.desc}) = 0 and
Sum ({@Act Amt YTD Inc}, {table.desc}) = 0 and
Sum ({@Bud Amt YTD Inc}, {table.desc}) = 0 and
Sum ({@Bud Var YTD Inc}, {table.desc}) = 0 and
Sum ({@LY YTD Inc}, {table.desc}) = 0)or
{table.desc} = "Unrealized Gain/Loss" or
{table.desc} = "" or
{table.desc} = "SUBHEADER"

   The problem is I still see the "Unrealized Gain/Loss" in the group tree even there is no data on report. How to suppress this in the group tree .

   I mean whenever there is no data for {table.desc}="Unrealized Gain/Loss" then I don't want to have it in the group tree.

   Please suggest how to resolve this. Any help is greatly appreciated.

 
Thanks in advance