2006 JR Open Discussion

By: jaspertest - jaspertest Grid not visible in xls file 2006-07-13 06:06 Grids are not visible in excel file created through JExcel API but visible when created through JRXLS..... JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE) is not working. Any help would be appreciated. By: Teodor Danciu - teodord RE: Grid not visible in xls file 2006-07-17 04:38 Hi, This was indeed a problem and is now fixed on the CVS repository. It will be part of the next release. Thank you, Teodor

By: farruco_el_Turco - farruca NoClassDefFoundError 2006-07-17 00:59 I would be very grateful if anyone could help me with this error. I have every library imported. But it still gives this message. What can I do?? java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/xml/JRXmlLoader

By: kalam2006 - kalam2006 Form Layout Report 2006-07-14 22:16 Hi, I am Using Japer Reports.In My Report it Contains 2 Pages or Forms.Report is Used For Form PrintOut.So i designed First Page as Normal Report. It's Details Band Height is 790.Now i need to design 2nd page.It's Content Height is 500 pixel.How can i design Each Form as single report.Sorry For my English.Thanks in advance.

By: dreporter - dreporter dyanmic colorization of detail section 2006-07-11 14:37 Hi, I am new to jasper reports and to java. I am using version 1.2.4 of iReport designer. I need to dispaly detail section in white and grey colors. Like one line white and the second line grey and till the end of the report. I have searched almost all posts here but could't find any sample. Any ideas how can this be done? By: Lucian Chirita - lucianc RE: dyanmic colorization of detail section 2006-07-11 23:50 This can be easily achieved with a conditional style that specifies a gray backcolor when $V{REPORT_COUNT} is even. Such a conditional style can be applied, for instance, to a frame that contains all the (transparent) detail band elements. Check the scriptlet sample (from the JR distribution), you can find a working example there. HTH, Lucian By: dreporter - dreporter RE: dyanmic colorization of detail section 2006-07-12 08:25 Thanks Lucian. It worked. I am now able to display the details in two colors. Also I tried to run the scriplet sample but it gave following error: 1. Scriptlet cannot be resolved to a type value = (java.lang.String)(((Scriptlet)parameter_REPORT_SCRIPTLET.getValue()).hello()); <-------> Any idea what I am missing? Do I need to add some jar files etc? By: Lucian Chirita - lucianc RE: dyanmic colorization of detail section 2006-07-12 09:22 How are you running the sample? The samples are meant to be executed using Ant, therefore you need to do something like: ant javac compile fill pdf HTH, Lucian By: dreporter - dreporter RE: dyanmic colorization of detail section 2006-07-12 14:49 I am running them in iReport designer. Is there any documentation that would help me in setting up ant correctly? thanks. By: Lucian Chirita - lucianc RE: dyanmic colorization of detail section 2006-07-13 02:18 You can consult generic Ant documentation at http://ant.apache.org/. Regarding iReport, I think that what you need to do is to include the directory where you have the compiled scriptlet in the classpath. Or maybe there is some special way of handling report scriptlets in iReport, I'm not very familiar with this.

By: Lucho - rebprotizer Jasper fillReport method failed in struts 2006-07-12 03:15 I would like to create a PDF file in a struts action, but the fillReport method doesn't work and any exception is catched. My source here : logger.info("Etape 1"); String reportName = "C:/DRA-Reports/maquette_REC02.jasper"; logger.info("Etape 2"); String pdfName = "C:/DRA-Reports/namePdf.pdf"; logger.info("Etape 3"); try { JasperPrint jasperPrint = JasperFillManager.fillReport(reportName, new HashMap(), new JREmptyDataSource()); } catch (JRException e) { e.printStackTrace(); } catch (RuntimeException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } logger.info("Etape 4"); JasperExportManager.exportReportToPdfFile(jasperPrint, pdfName); When I execute my action, i have an error : null, but any exception is catched. So i didn't know why the Etape 4 logger is not displayed. I have replace reportName by : this.getClass().getClassLoader().getResourceAsStream("maquette_REC02.jasper") for a relative path, but I have the same error. I have the feel that the fillReport crashed the system but I don't know why. Can you help me please, it's very urgent. Thank you. Luc LABBE By: dreporter - dreporter RE: Jasper fillReport method failed in struts 2006-07-12 08:37 Does your report require any parameters and are you passing any values? Here is how I have done it in java. hm = new HashMap(); JasperReport report = (JasperReport) JRLoader.loadObject(reportName); JasperPrint jprint = (JasperPrint) JasperFillManager.fillReport(reportName, hm, myconn); JasperExportManager.exportReportToPdfFile(jprint,pdfName);

By: dotimin - dotimin images scaling in Excel 2006-07-12 02:10 Hi, in my report I have several images and charts. I try to export a report to Excel (JExcelApi)format. Export works but all images and charts are shown with bad quality (if I export the same report to PDF I get excellent quality. Also I noticed that all images are scaled (about 133%). This is not what I need to get.. Do you know any solutions for that? Thanks!

By: dotimin - dotimin chart print from PDF problem 2006-07-12 02:04 Hi, I use JaspertReports and iReport 1.4 and put a chart. Then I create a PDF file and print it. In pdf file everything looks fine, but on paper I get a black box instead of a chart. If I try to make a padding for a chart (the same from all borders so chart should appear in the middle) it appears in left top corner and above it in the middle I see black box again (I guess this black box should be a place for this chart). Is it a bug or I should do some special tuning? Thanks!

By: Teodor Danciu - teodord Using JasperReports/iReport with SAP ... 2006-07-03 23:59 Hello, The JasperSoft team would like to know if there are any applications out-there successfully using JasperReports/iReport with SAP. If you know of such combination, please contact us at teodord@users.sourceforge.net. Thank you, Teodor By: spoorthi - spoo_anu RE: Jasper Server -Oracle DB 2006-07-11 03:01 Hi Team, This is Shivaraj from Surya software systems, Bangalore- India. We are working on Jasper Server related project. We have some queries: By default when we install jasper server, it’s installed in Tomcat with MySQL as database (DB used by jasper application). • How can we configure jasper to work with Oracle? • Are there any Oracle specific scripts for creating jasper server database? • We converted the MySQL scripts to oracle and tried creating the database/tables, but the problem is that there are some tables like USER, ROLE etc which are used in jasper database. These table names are keywords in Oracle, so we are not able to create this. How we can overcome this? These tables are used by jasper server for implementing the functionalities like creating users, creating roles, role-user mapping ….etc. Waiting for your response at the earliest. Thanks & Regards, Shivaraj Surya Software Systems Pvt. Ltd Bangalore, India By: Sherman Wood - sgwood RE: Jasper Server -Oracle DB 2006-07-11 19:16 This post should have gone on the JasperIntelligence forums. I have posted a patch with instructions that show how to have JasperIntelligence 1.0.1 use Oracle as the metadata repository. See http://sourceforge.net/tracker/index.php?func=detail&aid=1520756&group_id=162962&atid=825863 You can use Oracle as a data source for reports and OLAP, by creating a JNDI or JDBC data source in the JasperIntelligence metadata, independent of using MySQL or Oracle as the metadata repository. Sherman JasperSoft

By: Teodor Danciu - teodord [ANN] JasperIntelligence 1.0.1 released 2006-07-11 07:21 We are pleased to announce this release that significantly broadens the platform into the following areas: * Scheduled Reports with email notifications * Content Repository for scheduled report output * OLAP User interface * OLAP Server * Custom Data Sources for Reports * Fine grained Security * Enhanced iReport plugin for JasperIntelligence * Expanded Documentation * Scheduled Event Viewer * Installers covering reporting and/or analytics Release notes are here: http://jasperintel.sourceforge.net/index.php?p_module=page&pageid=45 Downloads are here: http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243. JasperSoft Team

By: Sri - ceenu display csv content on web browser 2006-07-10 09:01 Hi all, Is there a way to display the CSV or XLS output generated using jasper on the fly in the Web browser on a user click of the report button. I see the options to generate the CVS content is to output the result content to physical output file. thanks ceenu By: stone_cold - bssai RE: display csv content on web browser 2006-07-11 06:27 sinu, create a href link in the jsp file that u r writing pointing to the report that u have generated and open it as a file which wud indeed open a file dialog and will ask u to open the file with which software u want..like open with option. Sai

By: sanju - javasanjay Stopping the Tomcat window(console) 2006-07-11 04:42 Hi All, I am working on JasperReports using iReports Designer. I am using JDK1.4.2 , Mysql-4.2, JasperReports. I am calling the JasperReports from the Jsp Page and i have written the code in Java for calling the report. My problem is, when the report preview comes, if i close the preview browser automatically Tomcat is also getting closed.What may be the Problem.. Please Help me... thanks in Advance.. By: Edgar Dollin - edollin RE: Stopping the Tomcat window(console) 2006-07-11 05:26 This is because the tomcat JVM is opening the preview browser. First this will not work outside of a development environment as when the preview browser opens on a web site it won't be visible to the user. Second, you should be emitting either HTML or PDF for the user. Edgar

By: mslepak - mslepak Bar3DChart font size - please help 2006-07-10 11:32 I will appreciate any help on how to change font on Bar3DChart. It seems like the only element that might possibly affect the font size (of labels, etc.) on the Bar3DChart is the style attribute of the reportElement under chart. However, it doesn't work for me. By: bpatel@exitrealty.com - bpatel96 RE: Bar3DChart font size - please help 2006-07-10 12:47 Its good to learn jfree chart . it comes with the manual which is really good for customization for now you can a class in same directory as jasper file . I did this with piechart public class HSrptCustomChart implements JRChartCustomizer { public void customize(JFreeChart jFreeChart, JRChart jRChart) { PiePlot plot = (PiePlot) jFreeChart.getPlot(); plot.setSectionPaint(0, new java.awt.Color(160, 160, 255)); plot.setSectionPaint(1, new java.awt.Color(128, 128, 255 - 32)); plot.setSectionPaint(2, new java.awt.Color(96, 96, 255 - 64)); } }

By: kalam2006 - kalam2006 Calling Oracle Stored Procedure 2006-07-07 04:15 Hi, Following Is My Stored Procedure : ------------------------------------ CREATE OR REPLACE PROCEDURE Sample ( PSEARCHSTRING1 VARCHAR2, PSEARCHSTRING2 VARCHAR2, PSEARCHSTRING3 VARCHAR2, PORARC1 OUT PKG.REF_CURSOR ) AS V_STRSQL VARCHAR2(4000); V_STRSEARCHSTRING VARCHAR2(1000); BEGIN IF OBJECTEXISTS('VERASYS', 'TEMPCHPROCESSTYPES', 'TABLE') > 0 THEN EXECUTE IMMEDIATE 'TRUNCATE TABLE TEMPCHPROCESSTYPES'; /*EXECUTE IMMEDIATE 'DROP TABLE TEMPCHPROCESSTYPES';*/ ELSE EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE TEMPCHPROCESSTYPES ( CLEARINGHOUSEID INTEGER, CLEARINGHOUSECODE CHAR(10), CLEARINGHOUSEDESCRIPTION VARCHAR2(100), PROCESSTYPE VARCHAR2(20), DESCRIPTION VARCHAR2(100), PROCESSTYPEFLAG CHAR(1), NEEDSETTLEMENTFLAG CHAR(1), REPRESENTCOUNTLIMIT INTEGER, DIRECTION CHAR(1), DEBITCREDITFLAG CHAR(1), ROLE VARCHAR(5) )ON COMMIT PRESERVE ROWS'; END IF; V_STRSQL := ' INSERT INTO TEMPCHPROCESSTYPES SELECT CHM.CLEARINGHOUSEID, CHM.CLEARINGHOUSECODE, CHM.CLEARINGHOUSEDESCRIPTION, PT.PROCESSTYPE,PT.DESCRIPTION, LTRIM(RTRIM(NVL(PT.PROCESSTYPEFLAG,'''')))PROCESSTYPEFLAG, LTRIM(RTRIM(NVL(PT.NEEDSETTLEMENTFLAG,'''')))NEEDSETTLEMENTFLAG, LTRIM(RTRIM(NVL(PT.REPRESENTCOUNTLIMIT,0)))REPRESENTCOUNTLIMIT, LTRIM(RTRIM(NVL(PT.DIRECTION,'''')))DIRECTION, LTRIM(RTRIM(NVL(PT.DEBITCREDITFLAG,'''')))DEBITCREDITFLAG, CASE PT.ROLE WHEN 1 THEN ''PAYEE'' WHEN 2 THEN ''PAYOR'' END ROLE FROM CLEARINGHOUSEMASTER CHM, PROCESSTYPES PT, CLEARINGHOUSEPROCESSTYPES CHPT WHERE CHM.CLEARINGHOUSEID=CHPT.CLEARINGHOUSEID AND CHPT.PROCESSTYPE=PT.PROCESSTYPE '; V_STRSEARCHSTRING := PSEARCHSTRING1 || PSEARCHSTRING2; IF V_STRSEARCHSTRING IS NOT NULL THEN V_STRSQL := V_STRSQL ||' AND CHM.CLEARINGHOUSEID IN(' || V_STRSEARCHSTRING || ')'; END IF; V_STRSQL := V_STRSQL || PSEARCHSTRING3; EXECUTE IMMEDIATE V_STRSQL ; OPEN PORARC1 FOR 'SELECT * FROM TEMPCHPROCESSTYPES'; END; ----------------------------------------------------------------------------------------- In This PORARC1 is Used AS Ref Cursor Following Code IS My Pkg Code -------------------------------------------- CREATE OR REPLACE PACKAGE Pkg AUTHID CURRENT_USER AS Identity INTEGER; TYPE REF_CURSOR IS REF CURSOR; END Pkg; ---------------------------------------------- AnyBody Tell Me How Can I call The Above StoredProcedure. Give Me Detail Syntax. Thanks In Advance.

By: Christian - christian3003 chart types 2006-04-20 00:44 Hi, is it possible with JasperReports to combine chart types, e.g. a bar-line-chart like this? http://www.k12science.org/curriculum/weatherproj2/en/popup/graph1a.shtml I need a chart containing 5 series, one as bar and the others as dot/line. Christian By: Jacqui - szhym RE: chart types 2006-07-04 22:48 Hi Christian, Have u found a solution for ur problem? I also need to make a bar line chart in JasperReport. Was thinking of putting a line chart above a bar chart and making the front one with transparent background, but it doesn't work :( Could u plz let me know asap? got the deadline coming. By: Teodor Danciu - teodord RE: chart types 2006-07-05 01:16 Hi, Note that you could use JFreeChart or any other chart too directly with JasperReports, in case the built-in chart component does not support a certain feature. If you know JFreeChart or some other chart tool supports what you want, then you could take a look at the supplied /demo/samples/jfreechart sample to see how a charting API could be used to draw charts directly. I hope this helps. Teodor

By: gonzalro - gonzalro calling a method of an DataSource obj 2006-05-01 07:18 Hi, here dealing with JR. I'm sending a CustomDataSource to the report that is crowed of Beans, but my beans have Strings, Integers and other beans. Im trying to declare a field of type Object and after write an expression trying to cast and call the getXXX method, but.. not even compile! any clue ? tks guys. Rodrigo

By: tmaasland - tmaasland Problem with nested subreports 2006-04-25 03:23 Hello, in the help forum there seem to come no more answers, so i thought to try here: How do I tell JasperReports to: Get first FirstSubReport, fill it with data of id 14 Get first NestedSubReport, fill with first row of attribute xy in id 14 Get first NestedSubReport, fill with second row of attribute xy in id 14 Get first NestedSubReport, fill with third row of attribute xy in id 14 Now get second FirstSubReport, fill it with data of id 42 Get first NestedSubReport, fill with first row of attribute xy in id 42 Get first NestedSubReport, fill with second row of attribute xy in id 42 Get first NestedSubReport, fill with third row of attribute xy in id 42 Get first NestedSubReport, fill with fourth row of attribute xy in id 42 Continue with Report... More to this subject on http://sourceforge.net/forum/forum.php?thread_id=1487193&forum_id=113530 I hope someone can help me because I think it is very easy but I'm missing the point. Thanks in advance! By: tmaasland - tmaasland RE: Problem with nested subreports 2006-04-28 07:28 I'm pushing this one up, because I still don't get it. Could someone please look into it and give me a tipp? Thanks

By: chenwj - cwscwj couldnt save my crosstab, xml codes r changed 2006-04-24 20:06 i use Ireport(1.2 edition) to open a demo named of shipmentReport.jrxml which is located in demo folder of jasperreport project.., its original xml codes displays : ********************************** <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="ShipmentsReport" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="812" leftMargin="15" rightMargin="15" topMargin="10" bottomMargin="10"> <style name="Arial_Normal" isDefault="true" fontName="Arial" fontSize="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <style name="Arial_Large" isDefault="false" style="Arial_Normal" fontSize="10"/> <style name="Arial_Bold" isDefault="false" fontName="Arial" fontSize="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <subDataset name="Country_Orders"> <parameter name="Country" class="java.lang.String"/> <queryString><![CDATA[ SELECT ShippedDate, ShipRegion, ShipCity, Freight FROM Orders WHERE ShipCountry = $P{Country} AND ShippedDate IS NOT NULL ]]></queryString> <field name="ShippedDate" class="java.sql.Timestamp"/> <field name="ShipRegion" class="java.lang.String"/> <field name="ShipCity" class="java.lang.String"/> <field name="Freight" class="java.lang.Float"/> </subDataset> <queryString><![CDATA[ SELECT DISTINCT ShipCountry FROM Orders ]]></queryString> <field name="ShipCountry" class="java.lang.String"/> <detail> <band height="50"> <textField> <reportElement x="0" y="0" width="500" height="15"/> <textElement> <font fontName="Arial_Bold" size="10"/> </textElement> <textFieldExpression>"Shipments to " + $F{ShipCountry}</textFieldExpression> </textField> <crosstab isRepeatColumnHeaders="false"> <reportElement x="0" y="20" width="812" height="20"/> <crosstabParameter name="Country" class="java.lang.String"> <parameterValueExpression>$F{ShipCountry}</parameterValueExpression> </crosstabParameter> <crosstabDataset> <dataset> <datasetRun subDataset="Country_Orders"> <datasetParameter name="Country"> <datasetParameterExpression><![CDATA[$F{ShipCountry}]]></datasetParameterExpression> </datasetParameter> </datasetRun> </dataset> </crosstabDataset> <crosstabHeaderCell> <cellContents> <box border="2Point"/> <staticText> <reportElement x="4" y="4" width="112" height="42" style="Arial_Large"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text>Shipments total freight</text> </staticText> </cellContents> </crosstabHeaderCell> <rowGroup name="Region" width="50" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String">$F{ShipRegion}</bucketExpression> </bucket> <crosstabRowHeader> <cellContents> <box leftBorder="2Point" bottomBorder="2Point" rightBorder="2Point"/> <textField> <reportElement x="5" y="5" width="40" height="26"/> <textFieldExpression><![CDATA[$V{Region} == null ? "No region" : $V{Region}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#60FFFF" mode="Opaque"> <box leftBorder="2Point" bottomBorder="2Point" rightBorder="2Point"/> <textField> <reportElement x="5" y="0" width="110" height="22"/> <textElement verticalAlignment="Middle"/> <textFieldExpression>$P{Country} + " Total"</textFieldExpression> </textField> </cellContents> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="City" width="70" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String">$F{ShipCity}</bucketExpression> </bucket> <crosstabRowHeader> <cellContents> <box bottomBorder="2Point" rightBorder="2Point"/> <textField> <reportElement x="5" y="0" width="60" height="16"/> <textElement verticalAlignment="Middle"/> <textFieldExpression>$V{City}</textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#E0FFFF" mode="Opaque"> <box bottomBorder="2Point" rightBorder="2Point"/> <staticText> <reportElement x="5" y="0" width="60" height="20"/> <textElement verticalAlignment="Middle"/> <text>Total</text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="ShipYear" height="25" totalPosition="End" headerPosition="Stretch"> <bucket> <bucketExpression class="java.util.Date">CrosstabApp.truncateToYear($F{ShippedDate})</bucketExpression> </bucket> <crosstabColumnHeader> <cellContents> <box topBorder="2Point" bottomBorder="2Point" rightBorder="2Point"/> <rectangle radius="10"> <reportElement x="4" y="4" width="52" height="17"/> <graphicElement pen="1Point"/> </rectangle> <textField pattern="yyyy"> <reportElement x="5" y="5" width="50" height="15"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression class="java.util.Date">$V{ShipYear}</textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#FFFF60" mode="Opaque"> <box topBorder="2Point" bottomBorder="2Point" rightBorder="2Point"/> <staticText> <reportElement x="5" y="5" width="20" height="15"/> <text>Total</text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <columnGroup name="ShipMonth" height="25" totalPosition="End"> <bucket> <bucketExpression class="java.util.Date">CrosstabApp.truncateToMonth($F{ShippedDate})</bucketExpression> </bucket> <crosstabColumnHeader> <cellContents> <box bottomBorder="2Point" rightBorder="2Point"/> <textField pattern="MMM"> <reportElement x="5" y="2" width="20" height="21"/> <textFieldExpression class="java.util.Date">$V{ShipMonth}</textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#FFFFC0" mode="Opaque"> <box bottomBorder="2Point" rightBorder="2Point"/> <textField> <reportElement x="5" y="2" width="20" height="21"/> <textFieldExpression>msg("{0,date,yyyy} Total", $V{ShipYear})</textFieldExpression> </textField> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="FreightSum" class="java.lang.Float" calculation="Sum"> <measureExpression>$F{Freight}</measureExpression> </measure> <crosstabCell width="30" height="16"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="16"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="30" columnTotalGroup="ShipMonth"> <cellContents backcolor="#FFFFC0" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="16" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="35" columnTotalGroup="ShipYear"> <cellContents backcolor="#FFFF60" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="30" height="16" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell height="20" rowTotalGroup="City"> <cellContents backcolor="#E0FFFF" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="20"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="City" columnTotalGroup="ShipMonth"> <cellContents backcolor="#E0FFC0" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="20" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="City" columnTotalGroup="ShipYear"> <cellContents backcolor="#E0FF60" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="30" height="20" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell height="24" rowTotalGroup="Region"> <cellContents backcolor="#60FFFF" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="12" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> <textField> <reportElement x="0" y="12" width="25" height="12" style="Arial_Bold"/> <textElement textAlignment="Right"/> <textFieldExpression>msg("({0,number,percent})", new Float($V{FreightSum}.floatValue() / $V{FreightSum_ShipYear_ALL}.floatValue()))</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="Region" columnTotalGroup="ShipMonth"> <cellContents backcolor="#60FFC0" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="25" height="12" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> <textField> <reportElement x="0" y="12" width="25" height="12" style="Arial_Bold"/> <textElement textAlignment="Right"/> <textFieldExpression>msg("({0,number,percent})", new Float($V{FreightSum}.floatValue() / $V{FreightSum_ShipYear_ALL}.floatValue()))</textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="Region" columnTotalGroup="ShipYear"> <cellContents backcolor="#60FF60" mode="Opaque"> <box bottomBorder="1Point" rightBorder="1Point"/> <textField pattern="#0.0"> <reportElement x="0" y="0" width="30" height="12" style="Arial_Bold"/> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression class="java.lang.Float">$V{FreightSum}</textFieldExpression> </textField> <textField> <reportElement x="0" y="12" width="30" height="12" style="Arial_Bold"/> <textElement textAlignment="Right"/> <textFieldExpression>msg("({0,number,percent})", new Float($V{FreightSum}.floatValue() / $V{FreightSum_ShipYear_ALL}.floatValue()))</textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> </band> </detail> </jasperReport> *************************************** as i repeted save shipmentReport.jrxml again without any changes , the xml codes r changed to ______________________ <?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="ShipmentsReport" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="812" columnSpacing="0" leftMargin="15" rightMargin="15" topMargin="10" bottomMargin="10" 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 DISTINCT ShipCountry FROM Orders]]></queryString> <field name="ShipCountry" class="java.lang.String"/> <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="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="50" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="0" width="500" height="15" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial_Bold" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Shipments to " + $F{ShipCountry}]]></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> ____________________________________ i dont know why its xml codes r differ to the origial one , ... a urgent issue.. many thanks~!!!!!!!! By: chenwj - cwscwj RE: couldnt save my crosstab, xml codes r changed 2006-04-25 18:50 as i complied the shipmentReport.jrxml ,it occured the err like that " Element type "crosstabHeaderCell" must be declared.", but i check that it 's really have a declaration on element crosstabHeaderCell in its .dtd file like this"<!ELEMENT crosstabHeaderCell (cellContents)>", i really need your help, many thanks again By: chenwj - cwscwj RE: couldnt save my crosstab, xml codes r changed 2006-04-27 18:39 remark my issue again,,anyone could give me some suggesionts on how to slove it , thanks a lot

By: manish - tasty_mani Aggiragate Function 2006-04-10 04:48 I want use jasper reprot in my current project, and don't want to use .jrxml file. want to create report template on the fly rather then using .jrxml file.We need to implement some aggrigate(SUM,AVG) function at report Summary part Please help me if you have any information or example ....Thanks in advance By: jasperkan - jasperkannan RE: Aggiragate Function 2006-04-26 12:27 Why cant u use jasper ? it has all the aggregate function features and subreports too . Is there any specific reason not going for jrxml ? it allows run time customization by letting us modify the jasperDesign object so we can change the template dynamicallly .

By: Wesley - wesleyyau Excel Formula (Jasper? POI?) 2006-04-18 19:59 Hi, I have a question on how to set formula in the cell of Excel worksheet through Jasper. Now, I'm using two JRXML to define the layout of XLS and PDF. My question is... should I use POI only instead of using Jasper? The reason is POI has setCellFormula method for setting formula in the cell but Jasper seems didn't has this feature. By: jasperkan - jasperkannan RE: Excel Formula (Jasper? POI?) 2006-04-26 12:23 U can have a custom Xls exporter which Extends jasper XlsExporter and override the default exportText method .

By: mdilloncsc - mdilloncsc Does a Powerpoint Exporter exist 2006-04-25 05:47 Hi all, Does anyone know of a powerpoint exporter for jasperreports? By: Dave G - dgarratt New Thread Option - Where has it gone 2006-04-25 13:51 Sorry but I cannot see how to start a new thread any more - is there a problem with the site ? By: David Sachdev - dsachdev RE: New Thread Option - Where has it gone 2006-04-26 11:36 Having the same problem!

By: Teodor Danciu - teodord [ANN] JasperServer 0.9.2 released 2006-04-24 07:12 JasperSoft is pleased to announce the release of JasperServer version 0.9.2. You can learn more about this product and the new release here: http://sourceforge.net/forum/forum.php?forum_id=564993 Thank you, Teodor

By: Rodrigo Mascarenhas - cmascarenhas Images not appearing sometimes 2006-04-21 14:06 Hi everybody... My problem is that I have a report and this report has images. Some images are appearing sometimes and sometimes not. I mean...the same image that doesn't appear now, if I reload the report, appears. Does anyone here know what is happening? Thanks in advance, Rodrigo By: Rodrigo Mascarenhas - cmascarenhas RE: Images not appearing sometimes 2006-04-21 14:08 Just to complete, the images are in a directory in a server and I have the name of the images in my SELECT, so it's dynamic.

By: jasperkan - jasperkannan Subreport causing Blank Page Issue 2006-04-06 14:10 Subreport is added to main report in the summary area With the <isSummaryNewPage="true"> 2: Subreport PrintwhenExpression set to false conditionally. The problem is subreport is hidden if the condition is not matching,But it leaves a BLANK Page as the last page . I dont want to show a blank page . How to avoid theis ? Thanks for any hints. By: C-Box - c-box RE: Subreport causing Blank Page Issue 2006-04-10 07:57 Good topic... would also like to know why the printWhenExpressions are not considered at the page height(break) calculation. hoping for an answer too! C-Box By: jasperkan - jasperkannan RE: Subreport causing Blank Page Issue 2006-04-11 03:06 Hi I got the soln for the same . I was adding subreport to the summary area of the main report . I set the PrintWhen expression to the entire summary area and now its not showing the blank page. By: kishore - mvskishore not getting the dynamic data in subreport 2006-04-16 21:51 i am not getting the dynamic data with in the subreport.this is the test report if i got this then only i step further to do main report. i used customdata source. i am sending JRdatasource,subreport as a parameter to the main report. i added <dataSourceExpression> $P{SubReportSource} </dataSourceExpression> <subreportExpression class="dori.jasper.engine.JasperReport"> $P{StudentSubreport} </subreportExpression> these lines in my main report but problem is iam getting the static part, dynamic data is not getting in mainreport currently i am using 0.51 jasper vesion. pls send any sample prog to fill subreport to kishore.mvs@gmail.com that really helpful to me thanking u kishore By: Pavitra - pavitra_saxena Blank PDF is being generated .. 2006-04-17 08:47 Hello, I want to use jasper to print the data of my screen (JSP deployed over a web server), with the expectation of opening a pdf document as a popup which could be printed. My Servlet opened an empty popup which led me to write a PSVM program to check it faster. Now this PSVM program also is generating an empty PDF document instead of a document filled with data. Can any one help me out there? Only difference with the sample (working) program is I do not want to use a database rather using a HashMap (parameters) to provide the actual values. For this purpose , following were the steps followed. 1) modified ‘C:jasperreports-1.2.1demosamplesjasper FirstJasper.jrxml’ in order to remove ‘<queryString><![CDATA[sELECT * FROM Orders WHERE OrderID <= $P{MaxOrderID} ORDER BY ShipCountry]]></queryString>’ This was done with the intention of removing database dependency. 2) Run ant clean, 3) Run ant 4) Run ant compile: generated ‘FirstJasper.jasper’ 5) copied this FirstJasper.jasper to C:/ 6) Compiled JasperTest.java and run the same. FirstJasper.pdf is generated but the same is empty. Why? Any guess? Same PSVM is mentioned below. HashMap paramerets = new HashMap(); paramerets.put("ReportTitle","My Title"); paramerets.put("MaxOrderID",new Integer(1)); ..... poulated all parameters . byte[] bytes = JasperExportManager.exportReportToPdf(JasperFillManager.fillReport(new FileInputStream("c:\FirstJasper.jasper"),paramerets)); FileOutputStream fout = new FileOutputStream("c:\FirstJasper.pdf"); fout.write(bytes); fout.close(); Any type of quick help would be most very helpful. Thanks and Regards Pavitra By: daloch - rasco RE: Subreport causing Blank Page Issue 2006-04-20 08:33 there is page height wrong calculation also in PrintWhen expression for a group band https://sourceforge.net/forum/message.php?msg_id=3680344 please help

By: nsorochan - nsorochan HTML Data 2006-04-18 10:28 My data in my database is in html format, how can I display this data in a report with the html markup. Currently, it displays all the text. This data is a clob in the database, but I force it to a string and it displays, just does not mark it up.

By: Daniel Severo Junior - dseverojr nested VO report 2006-04-17 15:24 I have a collection that it keeps customer information. Each customer has a collection of addresses, another one of telephones and another one of sales, and inside of sales still she has a sub-collection of itens. Somebody has idea of as to integrate a report in these layouts?