"nicknack" wrote:

> Hello. I have a query whice look like this:
> select a,b,c,d from table1;
> Now - when pressing a cell in the first column we are jumping to
> another report with the value as parameter (called- p_param);.
>
> In the other report the query is:
> select * from table1 where a=::p_param.
>
> What I want to do is taht in the first report I'll will check if the
> second query return any result and if so to leave it as a link. If the
> second query does't return any result (zero rows) to remove the link so
> the user won't go to an empty report.
>
> So first i need to know how to check in the first report what will be
> the result of the second query.
>
> Can u help me?
>
> Thanks in advance,
> Roy.
>