Re: oracle report problem

Hi Sabine,

Instead of using "select name,......from <table>.....where

                            "name=:p_name"

use this:
                            "select name,......from <table>.....where
                            "name=nvl(:p_name,name)"

If :p_name is null (nothing) then :p_name will be replaced with name. This is allways true, so you will get all the data

Greetings, Martijn

Sabine Hoffmann wrote in message <8nrkko$9b75o$1_at_ID-83.news.cis.dfn.de>...
>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
>
>
Received on Tue Aug 22 2000 - 11:00:42 CEST