Re: User parameters Developer/2000

From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/03/27
Message-ID: <6fhqhn$g3e_at_bgtnsc03.worldnet.att.net>#1/1

In the report, as the last line of the where clause, place your lexical paramater(user parameter with a "&" in front).

Then have the form build a valid where clause.

For example, my report has INDEPTNO user parameter, and I want to filter on multiple DEPTNOs. A comma delimited list of these IDs are stored in the field IDLIST. Your report query would look like this:

SELECT ---
FROM ---
WHERE ---

&INDEPTNO Here is the code in the form:
ADD_PARAMETER(pl_id,'INDEPTNO',TEXT_PARAMETER,' and deptno in('||:IDLIST::')');

ENSURE THERE IS A SPACE BEFORE THE AND!!!!! If not, the report will bomb.

Joe Strano
Dulcian, Inc.

Trond Dankertsen wrote:

> I have got a "document register" report where i can put in
> witch "document class" i want it to print ('PXE' or 'PXF' etc.),
> but i don't know what to do if i want to print out two or more document
> classes on the same report using only one parameter.
>
> Can anyone PLEASE help me ? ? ? ? ? ? ?
Received on Fri Mar 27 1998 - 00:00:00 CET