[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9226
  • Last Modified:

How to execute rwrun with user parameters?

I have daily/weekly/monthly reports to generate in pdf format.
Currently they are being run via Report Builder 10.1.2.0.2
These reports have 2 User Parameters for dates (START_DATE, END_DATE).

Is there a way to pass the 2 paramenters into the rwrun syntax?
Is rwrun the method to use?
rwrun REPORT=C:\report1.rdf DESTYPE=FILE DESNAME=C:\report1_MMDDYYYY.pdf DESFORMAT=pdf USERID=username/passwd@database

Open in new window

0
JayAZ
Asked:
JayAZ
1 Solution
 
MilleniumaireCommented:
While rwrun does work with 10g, you should be using Oracle Reports Server which uses rwclient instead of rwrun.  The syntax for using rwclient is the same as rwrun, however you will have to have a Reports Server configured and running.

Both rwrun and rwclient tend to be run from the o/s command line so getting user defined parameters to them requires a user interface to be built.  This may be as simple as a shell script on unix which prompts the users for the parameters.

To pass the parameters to rwrun or rwclient, simply include the parameter names on the command line, for example, using your sample code:

rwrun REPORT=C:\report1.rdf DESTYPE=FILE DESNAME=C:\report1_MMDDYYYY.pdf DESFORMAT=pdf USERID=username/passwd@database START_DATE=dd-mon-yy END_DATE=dd-mon-yy

Obviously the format of the date values passed to the report depends on how you have defined these parameters in the report.
 

0
 
JayAZAuthor Commented:
date I needed to was in format mm/dd/yyyy
START_DATE="mm/dd/yyyy"     (with quotes)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now