Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

how to print directly from Reports through Forms

dannyerldannyerl Member Posts: 20
Hey guys, I made a report that is called and printed by a Form passing a parameter list; it works fine but now i need that the report prints directly without passing through the parameter window of Reports, I almost tried everything. Please i need a little help, this is the code that call the report, tks.

PROCEDURE IMPRIME IS
pl_id ParamList;
FECHADESDE CHAR(8);
BEGIN
FECHADESDE := TO_CHAR(:COLINFOCREDITO.COLFECHADESDE,'MON-YYYY');

pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');

Add_Parameter(pl_id,'FECHADESDE',TEXT_PARAMETER,FECHADESDE);
Run_Product(REPORTS,'REPCOLORD04',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id, NULL);

END;

Comments

  • MorianoMoriano Member Posts: 11
    Hello,

    In order to avoid the parameter form, you have to add a new parameter to the parameter list:

    Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');

    Hope this helps


    : Hey guys, I made a report that is called and printed by a Form passing a parameter list; it works fine but now i need that the report prints directly without passing through the parameter window of Reports, I almost tried everything. Please i need a little help, this is the code that call the report, tks.
    :
    : PROCEDURE IMPRIME IS
    : pl_id ParamList;
    : FECHADESDE CHAR(8);
    : BEGIN
    : FECHADESDE := TO_CHAR(:COLINFOCREDITO.COLFECHADESDE,'MON-YYYY');
    :
    : pl_id := Get_Parameter_List('tmpdata');
    : IF NOT Id_Null(pl_id) THEN
    : Destroy_Parameter_List( pl_id );
    : END IF;
    : pl_id := Create_Parameter_List('tmpdata');
    :
    : Add_Parameter(pl_id,'FECHADESDE',TEXT_PARAMETER,FECHADESDE);
    : Run_Product(REPORTS,'REPCOLORD04',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id, NULL);
    :
    : END;
    :
    :



Sign In or Register to comment.