Home » Developer & Programmer » Forms » Report
Report [message #77799] Wed, 21 November 2001 23:00 Go to next message
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 messageGo to next message
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
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
Previous Topic: Create sequence
Next Topic: default_where.......URGENT
Goto Forum:
  


Current Time: Thu Apr 25 21:19:15 CDT 2024