bandaralsb
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by bandaralsb
-
-
thank you
Lahiru Bandara
-
I am using jasper report scriptlet --> beforeReportInit() and I want to call a Stored Procedure in oracle database so that a temporary table will be populated with data which i can then use to fill the report.
In other words I'm trying to achieve some oracle reports after parameter form trigger actions. How can I do this or what am i missing here?
/* before report is initialized */
public void beforeReportInit() throws JRScriptletException {
// gathering report connection
Connection conn = (Connection) this
.getParameterValue("REPORT_CONNECTION");
// calling stored procedure execution method.
boolean status = executeStoredProcedures(conn,
this.getParameterValue("P_NIC").toString(),
Integer.valueOf(this.getParameterValue("P_TYPE").toString()));
// if fails
if (!status) {
// setting the error on variable to display on the report
this.setVariableValue("ERROR_LOG", "PRE-REPORT TRIGGER FAILURE");
}
}
Thanks in advance!.
-
HI,
I'm wondering whether it's possible to load user details and roles from database instead of defining it at the JasperServer level. if this feature is avialable in any version (Community or Commercial), please let me know.
Thank you very much.
How to reuse JasperReports queried data
in Products
Posted
Need to reuse the already loaded fields in the report. How can I do this.
Here's the Problem area,
How can I achieve this?