Supressing the group using formula

[PD81]

I have written a formul BP_name
Which is 2nd group in the report. I want to supress the Bp_Name group where:-
1) the formula "not found"
2) data value doesn't start with "C2" or "C3" (i have not written this in formula.

I am supressing the group using below :-
{@BP_Name}="not found" and
not({@BP_Name} startsWith "C2") or
not({@BP_Name} startsWith "C3")

But it not showing any value for the group where is I have lot of data. not sure why?

Formula BP_name as below

if not isnull({BusinessProcesses.Name}) then
{BusinessProcesses.Name}
else if not isnull ({BusinessProcesses_1.Name}) then
{BusinessProcesses_1.Name}
else if not isnull ({BusinessProcesses_2.Name}) then
{BusinessProcesses_2.Name}
else if not isnull ({BusinessProcesses_3.Name}) then
{BusinessProcesses_3.Name}
else if not isnull ({BusinessProcesses_4.Name}) then
{BusinessProcesses_4.Name}

else
"not found"
;



-cheers
Puneet

 

[lbass]

It sounds like you only want the BP_Name group to appear if it starts with C2 or C3. Instead of using suppression, why not just limit your record selection to these values?

left({@BP_Name},2) in ["C2","C3"]

Or the report might process faster if you used:

(
{@BP_Name} like "C2*" or
{@BP_Name} like "C3*"
)

-LB