Home » Developer & Programmer » Reports & Discoverer » Urgent.Report printing more than one page
Urgent.Report printing more than one page [message #89624] Mon, 07 June 2004 22:21 Go to next message
seka
Messages: 11
Registered: November 2001
Junior Member
I have COPIES as one of my system parameter in a report. Even if I set initial value to 1 or I leave it blank, I still get 2 copies of the report when I print, how can I make it to print only one copy not two copies?

I have again made a form where I tried to restrrict it to print one page with the code below,still its printing two  pages.

Please someone help me. Thank you in advance.

******************************

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_Parameter(pl_id,'MAXIMIZE',TEXT_PARAMETER,'YES');
  Add_Parameter(pl_id,'DESTYPE',TEXT_PARAMETER,'PRINTER');
  Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');
  Add_Parameterpl_id,'ORIENTATION',TEXT_PARAMETER,'POTRAIT');
  Add_Parameter(pl_id,'COPIES',TEXT_PARAMETER,'1');
Re: Urgent.Report printing more than one page [message #89627 is a reply to message #89624] Tue, 08 June 2004 00:44 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Are you making use of a Distributed Report?
If yes then check what is the value you have defined for COPIES over there.
Also try removind the Qoutes from the COPIES parameter value & write it as :
Add_Parameter(pl_id,'COPIES',TEXT_PARAMETER,1;

HTH
Regards
Himanshu
Previous Topic: report calling
Next Topic: Why do frames print?
Goto Forum:
  


Current Time: Wed Feb 28 17:24:56 CST 2024