Bad bind variable - Oracle Reports v. 9i

[Amy Herrmann]

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
aher...@mhp.mercy.net

[Jan Gelbrich]

"Amy Herrmann" <aher...@mhp.mercy.net> schrieb im Newsbeitrag
news:8f373182.04022...@posting.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