Ravi Kumar

Hi Every one, i am trying to desing a Report using IReport Designer, when i created Two Data sets for two diffent charts it only reads main Data set Report(Table Report) and is there any Specific place for charts in Designer Window ? Report looks like following Can any one Please Help to do this Report

Hi, we Found another apporach, we make Batch Queries into Stored Procedure, and called that Stored Procedure under Plsql Section in IReport Designer. and we made the following changes for Running that Report in Jasper server The plsql executor can be installed on JasperReports Server as follows: Shut down JasperReports ServerCopy <ireport dir>ireportmodulesextjasperreports-extensions-x.x.x.jar to <appserver dir>jasperserver-proWEB-INFlib. In iReport Designer v4.5 the jar is named jasperreports-extensions-3.5.3.Edit the file <appserver dir>jasperserver-proWEB-INFclassesjasperreports.properties and add this line to it: net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory Save the jasperreports.properties file and restart JasperReports Server.Finally it works for me. Reference URL :: http://community.jaspersoft.com/wiki/using-stored-ms-sql-procedure-data-source

Hi, i am using MS SQL Stored procedure In Jasper Server to generate the Report, but my stored procedure Returns Two Results Sets for two differnet Charts in Dash board Report how to use those two results Sets? i am designing the Report using IReport designer 5.6.0.

Hi hozawa, we are already integrated Jasper Server into <XXX> ERP system. we dont have an option to use any other tool like you sugested to us. and also we tried with the Joins, but we are getting the duplicated data because Data exist in multiple times. in a single query we won't get the Report, we need to use some Declare Statements and temporary tables to get Final Report. and also havig the problem to pass Null Values for some parameters.

Hi all, I am trying to design a Report using Jasper Server, here i am trying to Add new Query, here the Problem is Report data consists of differet tables and i need to get that data based on diffenet conditions, when i try to write the Query with some Temp tables and some Declare Statments Jasper Server won't accepts thees kind of Query's. can any one please help me to Achieve these Kind of Reports, because i need to Generate These kind of Reports Regularly.