Hello Need your help.

I have an oracle report test.rdf.

I configure my web.xml file AS:

<context-param>
       <param-name>reportCommand</param-name>
       <param-value>C:\DevSuiteHome_1\BIN\rwrun.exe</param-value>
</context-param>
<context-param>
       <param-name>fileDirectory</param-name>
       <param-value>c:\reports</param-value>
</context-param>
<context-param>
       <param-name>tempDirectory</param-name>
       <param-value>c:\reports</param-value>
</context-param>
<context-param>
    <param-name>databaseTNSName</param-name>
    <param-value>C:\DevSuiteHome_1\NETWORK\ADMIN\tnsnames.ora</param-value>
</context-param>
<context-param>
    <param-name>databaseUsername</param-name>
    <param-value>cobra</param-value>
</context-param>
<context-param>
    <param-name>databasePassword</param-name>
    <param-value>cobra</param-value>
</context-param>

Then my procedure to run report is:

procedure showReport is
 -- report url
 v_reportUrl_tx              varchar(32767);
begin

 v_reportUrl_tx := 'http://192.168.175.110/formspider/oraclereportsservlet?';

 v_reportUrl_tx := v_reportUrl_tx || 'rep_name=test.rdf';

 v_reportUrl_tx := v_reportUrl_tx || '&application_id=' || api_application.getid;

 -- show report
 api_component.seturl('mainPanel.renderer', v_reportUrl_tx);

end;

END; -- end body

On my formspider Application when I press button to call the previous procedure and run my report I have a the following message : The server have refused the connection

please could you help me?

asked 06 Sep '15, 08:33

mekueko's gravatar image

mekueko
111
accept rate: 0%

edited 15 Sep '15, 11:17

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5


Hi,

If you are having problem with the internal Formspider Servlet, you don't really have to use it to show reports.

If you can successfully run a report using a different URL of an Oracle Reports installation then you can use that URL.

As mentioned in this thread we are planning to deprecate this feature.

Is this an option for you?

Kind Regards,
Yalim

link

answered 07 Sep '15, 05:25

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

But I cannot successfully run my report. so I would like to know what is wrong in my code

(07 Sep '15, 05:28) mekueko

Hi,

I understand. No problem. I am trying to make sure if this is a problem worth solving because I don't want to hold you up or waste your valuable time.

If you can move forward using an external Oracle Reports installation, I think we don't need to spend any effort in solving this issue because we will deprecate this feature anyway.

Kind Regards,
Yalim

(07 Sep '15, 05:34) Yalim Gerger ♦♦

Hello Excuse me to come back about the above issue. I don't understand your proposed solution(using an external Oracle Reports installation) . Please could you describe with an example? Thanks

(13 Sep '15, 18:57) mekueko

Hi,

Do you have an Oracle Reports Server running in your environment? Can you open a report from this reports server in a browser? If your answer is yes to both questions, you can use the URL you use to see the report in the browser, to call the report from Formspider using the api_application.run API.

You can also set the URL of the Formspider HTML Renderer Component to this URL. api_component.seturl('mainPanel.renderer', [Your Report URL]);

In other words, the report does not have to be created by Formspider. As long as there is a URL pointing to the report you can show it in Formspider or open it from Formspider.

Hope this helps.

Kind Regards,
Yalim

(15 Sep '15, 11:22) Yalim Gerger ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×7

Asked: 06 Sep '15, 08:33

Seen: 755 times

Last updated: 15 Sep '15, 11:22


© Copyright Gerger 2017