visert

Hi to all I would like to know if it's possibile have in last page a sort of summary with number of pages of groups. I'm trying to do it using some temp variable, but I don't able to populate it a runtime during print of report.... There's a way that is not a workaround? Thank you

Hi main report "MR"... and its sub report "SR". Data into XML are in 1:n relationship cardinality between MR -> SR records (mr01 -> sr01, mr01->sr02... ecc ecc). Data source is a JRXMLdatasource ( a XML file). Without sorting, the report is printed correctly, But I need to sort both MR and SR records. I pass the datasource from MR to SR with tipical sentence: "((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("field") If I try to sort a field into MR: the JRXMLDataSource "became" ListOfArrayDataSource and so I need to change the sentence into ((net.sf.jasperreports.engine.data.ListOfArrayDataSource)$P{REPORT_DATA_SOURCE}) otherwise I ("correctly") receive a cast exception ClassCastException ListOfArrayDataSource cannot be cast JRXmlDataSource. Well... no compile error, no runtime error, but SR is empty. I think because to sort MR the engine has "finished" records? It's possibile inside SR command the restart of scanning of record? If yes... will be correctly assigned to MR records? Thank you to all for help. bye best regards to all!

Hi to all I generalize my situation. A file XML is a xpath datasource for main report A that has a subreport A.1 I have to sort data into A....and then into A.1 Without sort all work properly, but when I try to set sorting parameter into A, I receive this error at runtime: Error filling print... Error evaluating expression : Source text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//ind") net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("//ind") at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:336) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:263) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2036) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:760) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:270) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:989) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.ClassCastException: net.sf.jasperreports.engine.data.ListOfArrayDataSource cannot be cast to net.sf.jasperreports.engine.data.JRXmlDataSource at RPT0845MYP_obi_1316392794181_244349.evaluate(RPT0845MYP_obi_1316392794181_244349:242) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) ... 18 more where "ind" is a sub xml element of data that is main data for subreport A.1 If i delete sorting parameter option into report A....all work, but not sorted. Someone can help me? bye thank you in advance.

Hi to all I develop the template in my development pc (environment) and I use file style reference (for information Windows machine). In testing & production environments the file style as different path (for information Linux machine). I want to pass as parameter to template the name file of style file but does not work. In development environment (ireport designer ide) I put the file name into the pop-up windows for insert parameter values. But into testing & production does'not work (obviously the file path is correct and different and passed into source code of execution of reporting class). Could some one help me? Thank at all. bye

I have a trouble with updating to 4.0.2 -> generating PDF file the text field go down (carriage return) for no apparent reason. The same report in 4.0.1 not show this "bug" (?) ... and if I generate the same jrxml in two design ambient (4.0.1 and 4.0.2) the report in 4.0.1 is printed in pdf correctly...in 4.0.2 not correctly (see attach). Is caused by linespacing new properites? I dont know... but for the moment I return to 4.0.1 because of my urgency iussue :-) bye

Hi to all I need to produce a PDF using a ireport template in a J2ee web-app. I see two main way: 1) passing a XML file to ireport class and produce PDF. 2) build the report with a JDBC connection that take data using SQL (SELECT) directly on database. PRO/CONS? are there some contraindications to use 1) or 2) ? For example... using a jdbc connection could be critical for DBMS calling it by a j2ee back-end EJB class? In solution 2) the transaction of SELECT QUERY is managed by ireport template class...is secure for eventual loop o error ( could be?) of the query? Is DBMS secure in this way? thank u

Hi... When I try to set Wingdings font I don see the symbol...but always little rectangle. Can some one help me? thank u in advance

but... It's impossbile in design view delete font dimension... I have to delete into XML code?

Hi I installed latest release 4.0.1 but... the designing bugs persists Copy/Paste from a template to another does not work (...a blank, empty, sad white page is printed) without error...while some item is possibile to see into design view,...other pasted items does not visibile. It's there some tips that I don't know to make COPY & PASTE from template? I tryed also pasting XML code.... but nothing. thank u bye

Hi I installed latest release 4.0.1 but... the designing bugs persists Copy/Paste from a template to another does not work (...a blank, empty, sad white page is printed) without error...while some item is possibile to see into design view,...other pasted items does not visibile. It's there some tips that I don't know to make COPY & PASTE from template? I tryed also pasting XML code.... but nothing. thank u bye

Hi sanda thank for u response... but the stile is the same for the two object: a label and a textfield. <textField pattern="" isBlankWhenNull="false"> <reportElement style="testo" mode="Transparent" x="0" y="0" width="162" height="13" forecolor="#000000" backcolor="#FFFFFF"/> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single" markup="none"> <font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{nome_assessore}]]></textFieldExpression> </textField> but ... I think that applying style to textfield is not work properly. I set three VERY different style... and when I select one for a textfield in "design" view does'not change... if apply the same style to another textfield ... I see the change... to another ..no. I don't know if style are overwritten by other setting, but I assume that style have to overwrite ANY configuration... otherwise how can they help us? Thank for u help bye (copy/paste format does not work...)

hi i'm using style referenced into a report. Well... when I put a text field with a style...I don't understand why the font & dimension do not change according with style. If i put a "label" then work correctly. thank for your help v

Hi Ditti thank you a lot for your suggestion, but I just had tried this ...and does not work. I think that page break + sub report is not a good couple. thk u visert

Hi to all I have two level of data nested. Call X and Letter (say attach). I want to print X data alwyas on the top of page ...and the Letter data on detail....but, when finish Letter data the page have to break and start new page. I put (see attach) a PAGE BREAK in band LAST FOOTER PAGE of the sub report...but does not BREAK :-) Could anyone help me? (onestly my report is very very more complex...with six level of sub-report, but to solve my issue and present the problem on forum I simplified the question). thk to all! bye

I'm working now using nested List... a problem is that the WYSIWYG editor is not able to select nested element (both list that their elements)... neither selecting it into "report inspector". List (I read) that is less time consuming to compute and seems better to fit into report (is easier). bye Post Edited by visert at 02/17/2011 10:21

Hi to re-create a pivot table (similar to ms excel pivot) which is the best design to create it? The pivot does'not make statistics but list values...(no sum or other) and there're 6 level of row subgrouping. 1) sub report? I'm using subreport ...but is very difficult to align...manage dimension 2) crosstabs? I understood that crosstab can only make calculation and not listing... 3) grouping? with 6 level of grouping ... is not "possibile" use group because the final graphic layout is too much dispersive 4) list? I'm not sure if it's possibile grouping list...with sub...list? So...which could be the best ? thank you

Hi to all I'm fighting against a strange situation. XML datasource... where are defined: <dataroot> <responsabili> <responsabile> <name>mario rossi 1</name> </responsabile> <responsabile> <name>mario rossi 2</name> </responsabile> <responsabile> <name>mario rossi 3</name> </responsabile> <responsabile> <name>mario rossi 4</name> </responsabile> </responsabili> <QRY_output> <COD_PROGRAMMA_RPP>RPP01</COD_PROGRAMMA_RPP> <COD_LDS>LDS18</COD_LDS> <VALORE_TARGET>4</VALORE_TARGET> </QRY_output> <QRY_output> <COD_PROGRAMMA_RPP>RPP01</COD_PROGRAMMA_RPP> <COD_LDS>LDS18</COD_LDS> <VALORE_TARGET>5</VALORE_TARGET> </QRY_output> ... ...and so on... ... </dataroot> I want a list on title band (with the list of all "responsabile" record) and in detail band a grouped report of "VALORE_TARGET"... grouping for COD_PROGRAMMA_RPP and then for "COD_LDS".... The BIG PROBLEM is.. without SORTING field...the grouping does not work (I read on the "iReport Ultimate Guide"... "JasperReports groups records by evaluating the group expression. Every time the expression’s value changes, a new group instance is created. The engine does not perform any record sorting if not explicitly requested, so when we define groups we should always provide for the sorting. For instance, if we want to group a set of addresses by country, we have to sort the records before running the report." But if I sort the field to use the groups...then I receive this error on the LIST (SEE CODE BELOW).... WHY????? :-( I attach the files... I hope that someone could help me! bye Code:Error filling print... Error evaluating expression :     Source text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).dataSource("/dataroot/responsabili/responsabile") net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :     Source text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).dataSource("/dataroot/responsabili/responsabile")Â

Hi to all I'm new to this forum and to iReport Designer. I buy & studied the ultimate guide to iReport, but I did not found fully how XML data source are parsed and transformed (used) into report. I mean... only with some attempts I vaguely understood how to use complex XML data source and mapped into report with List and Grouped Report. 1) A question could be: "When I put an xPath expression into report datasource definition, how xml data are transformed and mapped into record?"... (obviously I know xPath synta, but I did not found what's up if I define more than one node ...using pipe "|" for example. 2) generally... can I define only (and exctaly one) one recordset (using xPath exp) for main report when design the report? All other data must be managed with List, crossTab and subReport?... Thank in advance to all! bye best regard