Home » Developer & Programmer » Forms » How to call a report?
icon14.gif  How to call a report? [message #318543] Wed, 07 May 2008 02:40 Go to next message
saeedsani
Messages: 6
Registered: June 2006
Junior Member
Hi
I am using form and reports 10g.Calling reports from forms.Every thing is going well.but when i reset value "separateFrame=true" in formsweb.cfg file , after that when i pressed button for report nothing happened.it is not opening browser for report. please sombody help me.

thanks
saeedsani

[MERGED by LF]

[Updated on: Thu, 08 May 2008 00:25] by Moderator

Report message to a moderator

Re: separateFrame [message #318759 is a reply to message #318543] Wed, 07 May 2008 20:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the code that you are using to launch your report.

David
Code to call report [message #318787 is a reply to message #318543] Thu, 08 May 2008 00:05 Go to previous messageGo to next message
saeedsani
Messages: 6
Registered: June 2006
Junior Member
Hi David

I am using following code in when_button_press trigger. It is working when i set "separateFrame=false" but it is not giving any response when i change it to "separateFrame=true".Separate forms is opening but on that form it is not calling report through this code.

DECLARE
  VAR_AL     NUMBER;
  alert_id   ALERT                 := Find_Alert ('ALERT_CALC');
  PLR_ID     PARAMLIST;
  PRNO       PROPOSAL.PR_NO%TYPE;
BEGIN
--ALLERT FOR PREMIUM CALCULATION BUTTON
  SET_ALERT_PROPERTY (ALERT_ID,
                      ALERT_MESSAGE_TEXT,
                      'Are You sure you want to generate Proposal Letter ');
  VAR_AL  := SHOW_ALERT (ALERT_ID);
  IF VAR_AL = ALERT_BUTTON1 THEN
    PLR_ID  := GET_PARAMETER_LIST ('TMPDATA');
    IF NOT ID_NULL (PLR_ID) THEN
      DESTROY_PARAMETER_LIST (PLR_ID);
    END IF;
    PLR_ID  := CREATE_PARAMETER_LIST ('TMPDATA');
    SELECT PR_NO
      INTO PRNO
      FROM POL_CAT_MAS
     WHERE :PREM_RATE_CALC.C_CODE = POL_CAT_MAS.C_CODE;
    ADD_PARAMETER (PLR_ID, 'P_1', TEXT_PARAMETER, PRNO);
    ADD_PARAMETER (PLR_ID, 'PARAMFORM', TEXT_PARAMETER, 'NO');
    WEB.SHOW_DOCUMENT
      ('http://gr:8890/reports/rwservlet?destype=CACHE&desformat=PDF&report=PROP.rdf&userid=phs/phs@phs&P_1='
       || PRNO);
  END IF;
END;

please guide me.

Thanks
saeedsani

[Updated on: Thu, 08 May 2008 01:03] by Moderator

Report message to a moderator

Re: Code to call report [message #318809 is a reply to message #318787] Thu, 08 May 2008 01:15 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You seem to be short a few parameters. Search this forum for 'ADD_PARAMETER WEB.SHOW_DOCUMENT'. There aren't that many to review.

David
Previous Topic: show forms at the center of the window
Next Topic: Can't paste OS clipboard into Web ORACLE FORM
Goto Forum:
  


Current Time: Tue Dec 06 06:28:55 CST 2016

Total time taken to generate the page: 0.08575 seconds