ilikejasper

Hi I have the following series but is not being displayed in the XY LineChart. FISCAL_YEAR MONTH YTD 2,006.00 1.00 3.30 2,006.00 2.00 6.84 2,006.00 3.00 9.27 2,006.00 4.00 10.29 2,006.00 5.00 13.05 2,006.00 6.00 15.06 2,006.00 7.00 18.01 2,006.00 8.00 19.89 2,006.00 9.00 23.59 2,006.00 10.00 26.15 2,006.00 11.00 28.95 2,006.00 12.00 30.68 2,007.00 1.00 2.66 2,007.00 2.00 4.39 2,007.00 3.00 6.42 2,007.00 4.00 7.90 2,007.00 5.00 9.71 2,007.00 6.00 12.24 2,007.00 7.00 15.47 2,007.00 8.00 17.29 2,007.00 9.00 18.37 2,007.00 10.00 21.01 2,007.00 11.00 22.07 2,007.00 12.00 22.16 I am using the $F{FISCAL_YEAR} as series exoression $F{MONTH} as X value expression $F{YTD} as Y value expression any suggestion ??? why is this happening?? thanks ilikejasper

hi I want to create the Report styles in the master report and pass the styles to sub report so that i do not need to create the styles in the sub report. I am sure there must be the way to do this. Any pointers are highly appreciated. Thanks ilike jasper

hi As you have mentioned "The rectangle solutions would not work for HTML and XLS, where overlapping elements do not show up." so how to make the solution work for html and xls ilikejasper

Hi I have attached the pdf. I can use the frame but what about doing rows with alternate colors. For this again i have to use the rectangle. Thanks ilikejasper [file name=LatestInteractions.pdf size=1810]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/LatestInteractions.pdf[/file]

hi I have attached Pdf file. I am coloring the alternate rows. At the same time i have used "Stretch with overflow" to expand the text of the textfield.Now if the text overflows then the rectagle below the textfield does not overfow to cover the background the complete row. Have a look. How can i cover the complete background Thanks ilikejasper

Hi If i want to call the utlilty method in the label expression then how to do that. thanks ilikejasper

Hi I found solution for this. You can also drop "percentage" from the library. It also has the evaluation time to auto. thanks for the reply. ilikejasper

Hi I tried doing this in this label expression if ( $F{QUALITY_IND}.equalsIgnoreCase( "R" )){ return "Risk";} but it gives me error. Can u please point me to some sample showing how to call the utility method. This will help me lot. thanks ilikejasper

Hi Thanks for the reply. I was looking for the same thing. Thanks ilikejasper

Hi I have data in the format Region ytd Asia 5,789,777.43 Australia 1,553,008.88 Europe 30,546,788.71 Japan 8,134,018.72 US 113,661,762.06 I want to display Asia and percentage. percentage = 5,798,777.43/159,685,355.80(sum of all the columns) In the report i have made a sum function which calculate the total and the other field variable which point to ytd column I am displaying the records in the detail band. I do not get the correct percentage for any column because the total in the detail for the first time is 5,789,777.43 in detail band. In the second loop it changes to (5,789,777.43+1,553,008.88) IS their any way i can calculate the total before execution of the detail band so that i get correct percentages. Your expertise is required. Thanks ilikejasper

Hi I have data in the format Region ytd Asia 5,789,777.43 Australia 1,553,008.88 Europe 30,546,788.71 Japan 8,134,018.72 US 113,661,762.06 I want to display Asia and percentage. percentage = 5,798,777.43/159,685,355.80(sum of all the columns) In the report i have made a sum function which calculate the total and the other field variable which point to ytd column I am displaying the records in the detail band. I do not get the correct percentage for any column because the total in the detail for the first time is 5,789,777.43 in detail band. In the second loop it changes to (5,789,777.43+1,553,008.88) IS their any way i can calculate the total before execution of the detail band so that i get correct percentages. Your expertise is required. Thanks ilikejasper

Hi I am displaying the piechart. In the label expresion i am trying to show the percentage. My data is in the following format Quality_ind fiscal_year ytd NR 2007 698471.19 P 2007 562028.86 R 2007 19751415.09 I am calulating the total of the ytd column and displaying in label expression of pie chart for the test purpose but it doesnot represent the correct data. Please help me out. I am real stuck on this. Thanks in Advance. Below is the .jrml file. <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="FormatClientCreditsByTradeClassification" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="280" pageHeight="310" columnWidth="280" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select decode(quality_ind,'NR','Non Risk','R','Risk', 'P','Priority') quality_ind, fiscal_year, sum(mtd_gross_sales_credit) as ytd from fimis_datamart.v_sales_credit_mtd where client_name like 'JP Morgan Chase & Co (P), USA' and fiscal_year=2007 and month<=10 group by quality_ind, fiscal_year order by quality_ind, fiscal_year]]></queryString> <field name="QUALITY_IND" class="java.lang.String"/> <field name="FISCAL_YEAR" class="java.math.BigDecimal"/> <field name="YTD" class="java.math.BigDecimal"/> <variable name="TotalSum" class="java.math.BigDecimal" resetType="None" calculation="Sum"> <variableExpression><![CDATA[$F{YTD}]]></variableExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="310" isSplitAllowed="true" > <pieChart> <chart evaluationTime="Report" hyperlinkTarget="Self" > <reportElement x="6" y="32" width="260" height="260" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartTitle color="#000000" > <titleExpression><![CDATA["Client Credits Trade Classification"]]></titleExpression> </chartTitle> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" > </chartLegend> </chart> <pieDataset> <dataset > </dataset> <keyExpression><![CDATA[$F{QUALITY_IND}]]></keyExpression> <valueExpression><![CDATA[$F{YTD}]]></valueExpression> <labelExpression><![CDATA[$V{TotalSum}.toString()]]></labelExpression> <sectionHyperlink > </sectionHyperlink> </pieDataset> <piePlot isCircular="true" > <plot labelRotation="20.0" /> </piePlot> </pieChart> <staticText> <reportElement x="6" y="-437" width="126" height="25" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <text><![CDATA[Key client Contacts]]></text> </staticText> </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> Thanks ilikejasper

Hi How can i display the data in the tabel format.I want to display line to show the rows and columns. I have attched an pdf file which shows the data but how should i put line for rows and columns. thanks in advance ilikejasper [file name=ClientCredit_USD_.pdf size=1537]

Hi I want to chnage the value of the labels of pie chart at run time. I am displaying the data in the PiChart. I have the data in the form QUAL_IND , GROSS NR 789 P 415 R 4898 These are column names QUAL_IND , GROSS. Now in the PieChrat Label i want to display "Non Risk" instead of "N" "Risk" instead of "R" "Profit" instaed of "P" I am using the class public class PieChartCustomize extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { System.out.println("Hello Wold " + getFieldValue("QUALITY_IND")); } } When i run this I get the out put only "R" Why i am not getting the output for the other two rows? and how to change the labels. Please help me. ilikejasper.

Hi I am also facing the same problem. did u get the answer to this? Thanks ilikejasper

Hi I have records which are coming form the datasource. after the records are displayed i display the graph.but i am unable to set the location of the graph because i am not aware hom many records are coming form the database. If the records are more then it overlaps the chart and if it is less then it works fine.both the graph and the table records are being used as sub reports. any pointers are highl appreciated. Thanks ilikejasper

Hi svenn You are 100% correct and it worked. thanks a lot. thanks ilikejasper.

Hi I have two independent query. These two query gives me two different results. But i want the results displayed in the same report. so i am creating master report and one subreport. but when i run the master report i does not get the results for the sub report. though i am able to get the records for the sub report if i run it independently. Please help me. I am new to iReport and jasper. I am struggling for two days. Thanks ilikejasper Master jrml file <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="ReportDoc" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="SUBREPORT_DIR" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["C:\jasperreport\excercise\compile\"]]></defaultValueExpression> </parameter> <queryString><![CDATA[select client_segmentation,client_type from client where client_name =JP Morgan Chase & Co (P), USA]]></queryString> <field name="CLIENT_SEGMENTATION" class="java.lang.String"/> <field name="CLIENT_TYPE" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="50" isSplitAllowed="true" > <subreport isUsingCache="true"> <reportElement x="61" y="14" width="361" height="26" key="subreport-1"/> <subreportExpression class="java.lang.String"><![CDATA["C:\jasperreport\excercise\compile\ClientCredit(USD).jasper"]]></subreportExpression> </subreport> </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > <staticText> <reportElement x="39" y="3" width="84" height="19" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <text><![CDATA[Client Sector]]></text> </staticText> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="140" y="3" width="100" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{CLIENT_SEGMENTATION}]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="30" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="50" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="50" isSplitAllowed="true" > </band> </lastPageFooter> <summary> <band height="50" isSplitAllowed="true" > </band> </summary> </jasperReport> subReport.jrml <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="ClientCredit(USD)" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="250" pageHeight="300" columnWidth="190" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false" isIgnorePagination="true"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select client_name, fiscal_year,month, global_manacs as ProductName, sum(ytd_gross_sales_credit) as YTDGrossSalesCredit from sales_credit_ytd where client_name = 'JP Morgan Chase & Co (P), USA' and fiscal_year=2007 and month=11 group by client_name, fiscal_year, global_manacs, month order by fiscal_year, month, global_manacs]]></queryString> <field name="CLIENT_NAME" class="java.lang.String"/> <field name="FISCAL_YEAR" class="java.math.BigDecimal"/> <field name="MONTH" class="java.math.BigDecimal"/> <field name="PRODUCTNAME" class="java.lang.String"/> <field name="YTDGROSSSALESCREDIT" class="java.math.BigDecimal"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="50" isSplitAllowed="true" > <staticText> <reportElement x="5" y="30" width="69" height="17" key="staticText-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font size="8"/> </textElement> <text><![CDATA[Products]]></text> </staticText> <staticText> <reportElement x="81" y="30" width="58" height="17" key="staticText-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <text><![CDATA[YTD 20007]]></text> </staticText> <staticText> <reportElement x="5" y="0" width="174" height="19" backcolor="#CCCCCC" key="staticText-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <text><![CDATA[Client Credits (USD)]]></text> </staticText> </band> </columnHeader> <detail> <band height="21" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="5" y="2" width="69" height="17" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PRODUCTNAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="###0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="80" y="3" width="59" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8" isPdfEmbedded ="true"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{YTDGROSSSALESCREDIT}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> Post edited by: ilikejasper, at: 2007/12/07 14:57 Post edited by: ilikejasper, at: 2007/12/07 14:57

Hi I have a web application in which user will have customize panel.He can chose the font, chart types,langauges. Is it possible to generate the jrml file having to format depending upon the user selection at runtime. 1.Is it possible to print the data in the bar chart/pie chart or any other chart depending upon the user choice. 2.Is it possible to show the print view of the document before printing. 3.Can i make a jrml file at runtime.Do we have any limitaion to this? 4.Can the client design the report at runtime and print is generated without creating any file like pdf. 5.Can i do report scheduling? Please reply so that i can make the correct decison.If any lonks can be forwarde then it will be great. Thanks ilikejasper

Hi I am looking to use this tool but i cannot find information to generate the charts and export in to the excel sheet. I know JFreeChart can be used for creating charts but how to export these charts to the excel is missing. Any pointers are highly appreciated Thanks ilikejasper