Re: Reports / Querys

You can use Column Formula for each row in the report query.

It is PL/SQL program unit - just return 0 for example, but before that you can fill next row in a PL/SQL table by using fields of the current selected row. So, in afterreport-trigger you can use the PL/SQL table to delete all corresponding rows from DB.

Hope this helps.

Feel free to ask me if you still have the problem.

F. Schmitt wrote:
>
> I have a query where most paramters take effect and filter my data-out.
>
> some of the printed (reported) rows I'd like to delete after report, so I
> wrote a little code for afterreport-trigger.
>
> There I tried to delete from <table> where <column1> in <Query1>. (where
> Query1 is the Query designed in section Data-Model.
>
> that doesn't work unfortunately because Query1 is unknown in my
> PL/SQL-Editor. Any hint how to realise this?

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru