Re: oracle report problem

Hi Sobine,

This is a one of the solutions:

1. Define character parameter :p_NameClause enough length
2. Edit report trigger AFTER-PARAMETER-FORM

function AfterPForm return boolean is
begin

  if :p_name is null then
    :p_NameClause := '';
 else

    :p_NameClause := 'and name = ' || :p_name;   end if;

  return (TRUE);

end;

3. Use the next query
  select
    name,
    ...
  from
    <table>,
    ...
  where
    ...
    &:p_NameClause
  ;

Regards,
Aleksandr Kononov

In article <8nrkko$9b75o$1_at_ID-83.news.cis.dfn.de>,   "Sabine Hoffmann" <shoffmann_at_infeurope.lu> wrote:
> Hi,
>
> Thanks for the answer !!!
> And now we have an other problem. Please help us !
>
> I have a group-above report avec 2 groups (level 1 and level 2)
> For the level 1 i have a parameter :p_name with a select statement
 for a
> value-list. (without the option restrict) - and in the
 selectstatement from
> the datas i have "select name,......from <table>.....where
> ....."name=:p_name"
> When i execute the report i have the list and i can also write an
 other
> value. And the report will be execute. But when i write nothing for
 the
> parameter i have nothing ! But i want to have all the data ! What can
 i do ?
> I think its nessary to write a trigger or a function ?!
> who can help us ?
>
> I hope for an answer - Thanks in advance. Sabine
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 22 2000 - 15:37:47 CEST