mkhan523

hi, My reports contain 3D bar charts....... Can any one tell me how to make the bars cylindrical in shape????

Can anyone please provide me with an example or help me out with how to display jasper reports directly into the browser?? i have seen the example given in jasper reports......... but the problem i am facing is i have to display some external images along with jasper reports on the browser........ i am unable to do so......... only report is being displayed....... Please check out the attachment to understand the requirement clearly........ Code:JRHtmlExporter htmlExporter=new JRHtmlExporter(); request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE,jasperPrint); htmlExporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint); htmlExporter.setParameter(JRExporterParameter.OUTPUT_WRITER,out); htmlExporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,"image?image="); htmlExporter.exportReport();

Hi Sanda, Thanks for your Help......... I changed the condition ....... m using Boolean.FALSE instead of 0 and its working fine............ Thanks :):):)

M Using JDK 1.5.0.......... But still facing the same problem:(:(:

Thanks Sanda....... Thank you so so so much.......... it Works:):):) One more doubt.......... i am using printwhenExpression tag in my reports..... its working fine in ireports but raising an exception when m compiling it manually using java class....... this is the expression: <printWhenExpression><![CDATA[(($F{participantName}!=null)?$V{CommitteeGroup_COUNT}:0)!=0]]></printWhenExpression> where particpant name is a field <field name="participantName" class="java.lang.String"> <fieldDescription><![CDATA[participantName]]></fieldDescription> </field> this is the exception........ 1. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)!=0); //$JR_EXPR_ID=13$ <----------------------------------------------------------------------------------------------------------------------------> 2. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)!=0); //$JR_EXPR_ID=14$ <----------------------------------------------------------------------------------------------------------------------------> 3. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)==0); //$JR_EXPR_ID=25$ <----------------------------------------------------------------------------------------------------------------------------> 4. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)!=0); //$JR_EXPR_ID=13$ <----------------------------------------------------------------------------------------------------------------------------------> 5. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)!=0); //$JR_EXPR_ID=14$ <----------------------------------------------------------------------------------------------------------------------------------> 6. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)==0); //$JR_EXPR_ID=25$ <----------------------------------------------------------------------------------------------------------------------------------> 7. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)!=0); //$JR_EXPR_ID=13$ <-------------------------------------------------------------------------------------------------------------------------------------> 8. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)!=0); //$JR_EXPR_ID=14$ <-------------------------------------------------------------------------------------------------------------------------------------> 9. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)==0); //$JR_EXPR_ID=25$

Thanks Sanda............ This Works:) Thanks for your help:):):):)

I am using print when expression in my report............. the static text should not be shown.. when that condition occurs......... <printWhenExpression><![CDATA[(($F{participantName}!=null)?$V{CommitteeGroup_COUNT}:0)!=0]]></printWhenExpression> where particpant name is a field <field name="participantName" class="java.lang.String"> <fieldDescription><![CDATA[participantName]]></fieldDescription> </field> its working fine in ireports.............. but not when i am manually compiling the .jrxml file......... i am getting the following exceptionnet.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)!=0); //$JR_EXPR_ID=13$ <----------------------------------------------------------------------------------------------------------------------------> 2. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)!=0); //$JR_EXPR_ID=14$ <----------------------------------------------------------------------------------------------------------------------------> 3. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getValue()):0)==0); //$JR_EXPR_ID=25$ <----------------------------------------------------------------------------------------------------------------------------> 4. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)!=0); //$JR_EXPR_ID=13$ <----------------------------------------------------------------------------------------------------------------------------------> 5. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)!=0); //$JR_EXPR_ID=14$ <----------------------------------------------------------------------------------------------------------------------------------> 6. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getOldValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getOldValue()):0)==0); //$JR_EXPR_ID=25$ <----------------------------------------------------------------------------------------------------------------------------------> 7. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)!=0); //$JR_EXPR_ID=13$ <-------------------------------------------------------------------------------------------------------------------------------------> 8. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)!=0); //$JR_EXPR_ID=14$ <-------------------------------------------------------------------------------------------------------------------------------------> 9. Incompatible conditional operand types Integer and int value = (java.lang.Boolean)(((((java.lang.String)field_participantName.getValue())!=null)?((java.lang.Integer)variable_CommitteeGroup_COUNT.getEstimatedValue()):0)==0); //$JR_EXPR_ID=25$

Thanks Sanda for you help.............. But i am facing a little problem......... this is the chart customizer i am using import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.JFreeChart; import org.jfree.chart.plot.CategoryPlot; public class BarChartCustomizer implements JRChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { CategoryPlot categoryPlot = (CategoryPlot)chart.getPlot(); categoryPlot.getDomainAxis().setCategoryMargin(0); } } But the problem here is the space between two different category axis values is set to zero......... not... the distance between two series.............. PLEASE CHECK OUT THE IMAGE ATTACHED......

Is it possible to not to display Category axis values in Bar charts??? If Yes........ Please let me know how to do that...........

Can anyone please tell me how to reduce the space between two series of a bar chart........ I have two series in my bar chart......... i dont wnt any space between them.......... Just check out the attachment to know the exact requirement

HI, I have to display 5 bar charts in my report.. I am doing this in the summary section.. Now i want to provide page break after every bar chart...... Can anyone tell me how to do this??? I have tried using break--page break..........Its working fine but height of each page is 1200........ height of bar chart is 250 height of summar section is 1160 i want height of each page to be not maximum than 300 can any one suggest me what to do...... Code:<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="im3reports" language="groovy" pageWidth="595" pageHeight="1200" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="11"/> <queryString> <![CDATA[]]> </queryString> <field name="DS" class="java.lang.Integer"> <fieldDescription><![CDATA[DS]]></fieldDescription> </field> <field name="CS" class="java.lang.Integer"> <fieldDescription><![CDATA[CS]]></fieldDescription> </field> <field name="dimension" class="java.lang.String"> <fieldDescription><![CDATA[dimension]]></fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <summary> <band height="1160" splitType="Stretch"> <bar3DChart> <chart> <reportElement x="67" y="22" width="398" height="186"/> <chartTitle> <font size="12" isBold="true" isItalic="true"/> <titleExpression><![CDATA["Chart 1"]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend> <font isBold="true" isItalic="true"/> </chartLegend> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Current Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{CS}]]></valueExpression> <labelExpression><![CDATA[$F{CS}]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Desired Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{DS}]]></valueExpression> <labelExpression><![CDATA[$F{DS}]]></labelExpression> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot/> <itemLabel color="#000000" backgroundColor="#FFFFFF"> <font isBold="true" isItalic="true"/> </itemLabel> <categoryAxisFormat> <axisFormat> <labelFont/> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Score"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart> <bar3DChart> <chart> <reportElement x="67" y="234" width="398" height="186"/> <chartTitle> <font size="12" isBold="true" isItalic="true"/> <titleExpression><![CDATA["Chart 2"]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend> <font isBold="true" isItalic="true"/> </chartLegend> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Current Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{CS}]]></valueExpression> <labelExpression><![CDATA[$F{CS}]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Desired Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{DS}]]></valueExpression> <labelExpression><![CDATA[$F{DS}]]></labelExpression> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot/> <itemLabel color="#000000" backgroundColor="#FFFFFF"> <font isBold="true" isItalic="true"/> </itemLabel> <categoryAxisFormat> <axisFormat> <labelFont/> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Score"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart> <bar3DChart> <chart> <reportElement x="67" y="456" width="398" height="186"/> <chartTitle> <font size="12" isBold="true" isItalic="true"/> <titleExpression><![CDATA["Chart 3"]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend> <font isBold="true" isItalic="true"/> </chartLegend> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Current Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{CS}]]></valueExpression> <labelExpression><![CDATA[$F{CS}]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Desired Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{DS}]]></valueExpression> <labelExpression><![CDATA[$F{DS}]]></labelExpression> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot/> <itemLabel color="#000000" backgroundColor="#FFFFFF"> <font isBold="true" isItalic="true"/> </itemLabel> <categoryAxisFormat> <axisFormat> <labelFont/> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Score"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart> <bar3DChart> <chart> <reportElement x="67" y="675" width="398" height="186"/> <chartTitle> <font size="12" isBold="true" isItalic="true"/> <titleExpression><![CDATA["chart 4"]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend> <font isBold="true" isItalic="true"/> </chartLegend> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Current Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{CS}]]></valueExpression> <labelExpression><![CDATA[$F{CS}]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Desired Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{DS}]]></valueExpression> <labelExpression><![CDATA[$F{DS}]]></labelExpression> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot/> <itemLabel color="#000000" backgroundColor="#FFFFFF"> <font isBold="true" isItalic="true"/> </itemLabel> <categoryAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Score"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart> <bar3DChart> <chart> <reportElement x="67" y="899" width="398" height="186"/> <chartTitle> <font size="12" isBold="true" isItalic="true"/> <titleExpression><![CDATA["Chart 5"]]></titleExpression> </chartTitle> <chartSubtitle/> <chartLegend> <font isBold="true" isItalic="true"/> </chartLegend> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["Current Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{CS}]]></valueExpression> <labelExpression><![CDATA[$F{CS}]]></labelExpression> </categorySeries> <categorySeries> <seriesExpression><![CDATA["Desired Score"]]></seriesExpression> <categoryExpression><![CDATA[$F{dimension}]]></categoryExpression> <valueExpression><![CDATA[$F{DS}]]></valueExpression> <labelExpression><![CDATA[$F{DS}]]></labelExpression> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="true"> <plot/> <itemLabel color="#000000" backgroundColor="#FFFFFF"> <font isBold="true" isItalic="true"/> </itemLabel> <categoryAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont> <font isBold="true" isItalic="true"/> </tickLabelFont> </axisFormat> </categoryAxisFormat> <valueAxisLabelExpression><![CDATA["Score"]]></valueAxisLabelExpression> <valueAxisFormat> <axisFormat> <labelFont> <font isBold="true" isItalic="true"/> </labelFont> <tickLabelFont/> </axisFormat> </valueAxisFormat> </bar3DPlot> </bar3DChart> <break> <reportElement x="0" y="208" width="100" height="1"/> </break> <break> <reportElement x="0" y="433" width="100" height="1"/> </break> </band> </summary></jasperReport>

Hi, I am using the existing ImageServlet class... and i have mapped it in my web.xml ............ But stil facing the same problem Code:<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE web-app PUBLIC"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN""http://java.sun.com/dtd/web-app_2_3.dtd"><web-app id="WebApp_1"> <display-name>Web-Application</display-name> <!-- Standard Action Servlet Configuration (with debugging) --> <servlet> <servlet-name>action</servlet-name> <servlet-class>org.apache.struts.action.ActionServlet</servlet-class> <init-param> <param-name>config</param-name> <param-value>/WEB-INF/struts-config.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <!-- Jasper Reports Changes - Start --> <servlet> <servlet-name>ImageServlet</servlet-name> <servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class> </servlet> <!-- Jasper Reports Changes - End --> <!-- Standard Action Servlet Mapping --> <servlet-mapping> <servlet-name>action</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <!-- Jasper Reports Changes - Start --> <servlet-mapping> <servlet-name>ImageServlet</servlet-name> <url-pattern>/servlets/image</url-pattern> </servlet-mapping> <!-- Jasper Reports Changes - End --> <!-- The Usual Welcome File List --> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <!-- Struts Tag Library Descriptors --> <taglib> <taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri> <taglib-location>/WEB-INF/struts-bean.tld</taglib-location> </taglib> <taglib> <taglib-uri>/WEB-INF/struts-html.tld</taglib-uri> <taglib-location>/WEB-INF/struts-html.tld</taglib-location> </taglib> <taglib> <taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri> <taglib-location>/WEB-INF/struts-logic.tld</taglib-location> </taglib> <taglib> <taglib-uri>/WEB-INF/struts-form.tld</taglib-uri> <taglib-location>/WEB-INF/struts-form.tld</taglib-location> </taglib> <taglib> <taglib-uri>/WEB-INF/struts-nested.tld</taglib-uri> <taglib-location>/WEB-INF/struts-nested.tld</taglib-location> </taglib> <taglib> <taglib-uri>/WEB-INF/struts-template.tld</taglib-uri> <taglib-location>/WEB-INF/struts-template.tld</taglib-location> </taglib> <resource-ref> <description>Oracle Database 11g DataSource</description> <res-ref-name>jdbc/oracle11g</res-ref-name> <res-type>oracle.jdbc.pool.OracleDataSource</res-type> <res-auth>Container</res-auth> </resource-ref></web-app>

But how do i know where will the images be generated.??? there is someting called img_0_0_0 when i view source of the jsp page....... but i could not located where that is located in my enitre workspace.......... can you pls tell me what exactly is happening and when will img_0_0_0 be generated and in which folder??

Hi Sanda... I couldnt get you. what should be the image path??? i am not using any images in my jasper reports rather i am having bar charts to be displayed in the browser..... i have generated jasperReports.jrxml file using iReports 3.7.6 IDE....... My knowledge about jasper is very poor.....Please help me out with this..........

I have build the Sample application given in the web apps.But some unwanted images are being displayed when iam trying to export JR in HTML format and then include it in my JSP. I have attached the printscreen of it.Please check it and let me know if you have any solution for this problem. Ihave attached the screenshot of what the problem actually is....... I have even pasted the code which i am using to display the jasper report in jsp page Note: I am developing a web application in struts 1.2 Code: Post Edited by mkhan523 at 02/02/2011 08:50

I tried using JasperPrintManager but i am getting the following exception java.lang.ClassCastException: net.sf.jasperreports.engine.JasperReport Please suggest me some thing and get me out of this problem..........Plealse Code:Image p=(Image)JasperPrintManager.printPageToImage(s, pageIndex, zoom);//exception is raised at this lineAsessmentChartsMap.put(Jasper_Report,p ); session.setAttribute(JASPER_CHARTS,Jasper_Report)

Hi Sanda... Thanks for your advice it helped me alot.As said by you ,I have build the Sample application given in the web apps.But some unwanted images are being displayed when iam trying to export JR in HTML format and then include it in my JSP. I have attached the printscreen of it.Please check it and let me know if you have any solution for this problem. I have even pasted the code which i am using to display the jasper report in jsp page Note: I am developing a web application in struts 1.2 Code: Post Edited by mkhan523 at 02/02/2011 07:36 Post Edited by mkhan523 at 02/02/2011 08:35

Hi, am using struts 1.2 framework..... i am unable to display jasper reports on to my jsp page.... every time i try to do that i am getting some blank page with (X) marks....... like we get wen we dont have the said image in the given path....

Is there any method which accepts compiled jasper file and returns image as an out put............ i am facing a problem in displaying the report in my JSP page...........