[#4335] - Run stored procedure prior to report execution

Category:
Feature request
Priority:
Low
Status:
Assigned
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

It would be nice to see a way to set package variables before running the report. For example:

date_utils_pkg.set_date_tbl_inputs( p_start_dt => :p_start_dt,
p_end_dt => :p_end_dt,
p_iteration_type => :p_iteration_type);

This is done programatically by the framework (to simplify queries that run against Daily, Monthly, and Annual subreports). However, it means that the report cannot be tested in iReport.

thangalin's picture
2825
Joined: Apr 21 2008 - 4:34am
Last seen: 3 years 6 months ago

1 Comment:

#1

The best way to do it is to write a plugin or to provide a custom query executer to perform the required query before the report execution.

Giulio

Feedback