Re: OEM Reports: How to do a report with a parameter ?

From: Claude Comtois <claude.comtois_at_sdc-dsc.gc.ca>
Date: 29 Jul 2004 15:02:57 -0700
Message-ID: <9dfedaf1.0407291402.1a163b03@posting.google.com>

Hi there.

If you want to add parameters to your Oracle Report, you must go in the report editor and go to the Object Navigator, then colapse your report node, then the "Data Model" node and finaly you should see a "User Parameter" node. Click this node and make sure it is selected and then to your right (like a little toolbar), you should see a little green + (PLUS) sign. Click the plus sign and add your parameter. Now you can access this user parameter in the following fashion:

THIS IS A BATCH FILE

C:\ODS10g\BIN\rwrun.exe C:\Temp\Reports\ROE_Print.rdf USERID=login/Password_at_databasename DESTYPE=FILE DESNAME=C:\mine_p.pdf DESFORMAT=PDF P_SERIAL_NBR=W00000687

If you look at my last parameter in this particular string, ("P_SERIAL_NBR"), this is a user parameter that I have created. Whatever value you pass to this parameter will be passed back to your report.

You do not always have to call your report with a Batch File but I'm sure you get the idea.

I hope you accomplish your Oracle tasks because I thought that Oracle Reports had a sharp learning curve.

Have a good one. Received on Thu Jul 29 2004 - 17:02:57 CDT