bandaralsb

Need to reuse the already loaded fields in the report. How can I do this. Main query loads 20 records It's grouped by field1 and then by field2Display(print) all grouped records in the report Up to this is OK. Here's the Problem area, In the summery band I need to give a summery of field1 group and field2 group seperately To do this i intend to use two datasets with tables in the summery band to display field1 and field2 group summaries.I need to do this without using the same query on both the datasets copied from main report just to reprint group summary. How can I achieve this?

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.