calling report for printing from oracle 10g developer

25 pts.
Tags:
Oracle 10g
Oracle Developer
Oracle Developer 10g
Oracle printing
Oracle Report Printing
i am using oracle 10g developer. i want to call a report with parameter from menu and also want to see print preview as well as to do print. how can i do it?
ASKED: July 7, 2009  4:29 PM
UPDATED: November 8, 2009  9:03 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I suggest delivering your report as a PDF file to the user. This then acts as a “print preview”, and they can then print it if they want to.

To “call a report” with parameters, direct the user to a specially crafted URL that will request the report.

If your report file name is myreport, your Oracle Reports service name is webreport1 and it runs on the server named web.example.com, and the report service is accessible on secure port 443, and your parameters are named p_param1 and p_param2, and your parameter values are val1 and val2, your URL might look light this:

<pre>https://web.example.com/reports/rwservlet?server=webreport1+report=myreport+destype=cache+desformat=pdf+userid=username/password@tns+p_param1=val1+p_param2=val2</pre>

The above example specifically requests the report in PDF format, but there are other formats to choose from.

The parameters listed in the URL will populate any user parameters in your report that are named the same.

Case is not important in parameter names — sending parameters in lowercase will match uppercase parameters.

Null values are denoted by listing the parameter but just not giving a value, like “p_param1=”

Finally, it important to note that the login parameter should be sent URL encoded, as in “%75%73%65%72%69%64%3D” equates to “userid=”, etc. — not terrific security, since it’s reversible, but better than no security. People looking over the user’s shoulder aren’t likely to be able to visually decode the username and password in the URL if it’s like that. I think it really helps to use a secure port for your Oracle Reports web delivery too, as I have in my example.

Regards,
Eldon

PS: You didn’t mention the environment from which you would be wanting to “call a report”. So I have assumed a html page environment, since calling it from Oracle Forms is a little more tricky and I didn’t want to confuse the answer with unnecessary detail.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Asifj
    i am using oracle 10g developer. i want to call a report with parameter from menu and also want to see print preview as well as to do print. how can i do it?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following