Report [message #77799] |
Wed, 21 November 2001 23:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Fernando
Messages: 10 Registered: September 2000
|
Junior Member |
|
|
Cuando llamo un report desde un form, pasando paramétros, antes de ver la previsualización me vuelve a saltar la pantalla de parámetros del propio Report ¿Cómo puedo ocultarla?
When i call a report from a form, show the parameter screen just before preview. ¿How i can hide it?
Gracias
----------------------------------------------------------------------
|
|
|
Re: Report [message #77800 is a reply to message #77799] |
Wed, 21 November 2001 23:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
waris
Messages: 115 Registered: November 2001
|
Senior Member |
|
|
hi fernano..
hope this answers ur question...
PROCEDURE Run_Emp_Report IS
pl_id ParamList;
BEGIN
/*
** Check to see if the 'tmpdata' parameter list exists.
*/
pl_id := Get_Parameter_List('tmpdata');
/*
** If it does, then delete it before we create it again in
** case it contains parameters that are not useful for our
** purposes here.
*/
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
/*
** Create the 'tmpdata' parameter list afresh.
*/
pl_id := Create_Parameter_List('tmpdata');
/*
** Add a data parameter to this parameter list that will
** establish the relationship between the named query
** 'EMP_QUERY' in the report, and the record group named
** 'EMP_RECS' in the form.
*/
Add_Parameter(pl_id,'EMP_QUERY',DATA_PARAMETER,'EMP_RECS');
/*
**Pass a Parameter into PARAMFORM so that a parameter dialog will not appear
**for the parameters being passing in.
*/
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
/*
** Run the report synchronously, passing the parameter list
*/
Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);
END;
hope thih gets u going..
cheers
waris
----------------------------------------------------------------------
|
|
|
Report [message #81514 is a reply to message #77799] |
Wed, 26 February 2003 06:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
anand sagar
Messages: 1 Registered: February 2003
|
Junior Member |
|
|
pls give me some tips to format a report so that more number of records could be adjusted in a page.
regards,
anand
|
|
|