Hello all -

I've just started using Report Builder today, so go easy on me. I'm
trying to suppress a field with null values. Got this example from
the program documentation:

function M_G_DEPTNO1_HDRFormatTrigger return boolean is
begin
if :count_detail=0 then
return (FALSE);
else
return (TRUE);
end if;
end;

This is my actual code:

function B_ADDRESSLINE1FormatTrigger return boolean is
begin
if :count_detail=0 then
return (FALSE);
ELSE
return (TRUE);
end if;
end;

After compiling, I get the REP-0730 error message, "REP-0730. The
following bind variable is not defined: COUNT_DETAIL".

Any suggestions would be appreciated.

Amy Herrmann
aherrman (AT) mhp (DOT) mercy.net

"Amy Herrmann" <aherrman (AT) mhp (DOT) mercy.net> schrieb im Newsbeitrag
news:8f373182.0402201316.2d1f398d (AT) posting (DOT) google.com...
As the doco is only demo, :count_detail is not yet deckared in *your*
report.
Look at Your Query, wher Your bind variables are defined:

Select
a, b, c ...
From [yourTable]
Where [yourConditions]

Then You have bind variables :a, :b, :c.

And so your code becomes

function B_xyzFormatTrigger return boolean is
begin
if :a=0 then
return (FALSE);
ELSE
return (TRUE);
end if;
end;

And if You want to have counts whatsoever,
set aliases:

Select
a, b, c,
Count(c) count_c
....

Then You have a bind variable :count_c to deal with.

hth, Jan