visert

April 30, 2012

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

October 28, 2011

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!

September 19, 2011

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.

June 23, 2011

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

June 11, 2011

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

March 21, 2011

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

March 8, 2011

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

March 8, 2011

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

March 8, 2011

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

March 8, 2011

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

March 7, 2011

Hi sanda

thank for u response... but the stile is the same for the two object: a label and a textfield.

</textElement>

</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...)

March 5, 2011

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

February 18, 2011

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

February 17, 2011

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

February 17, 2011

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

February 17, 2011

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

February 14, 2011

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")Â

February 14, 2011

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

Sign In

visert

Posts

Joined

Last visited

Content Type

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by visert

[HOW-TO] print in last page a index of group with page numbers

sorting main report and sub-report with xml datasource

sorting xpath datasource with subreport

style file passed as parameter... seems doesn\'t work

Specify line spacing by pixels

XML vs SQL

use font Wingdings for PDF (...and also internal viewer)

[iReport 4.0.1] issue with styles

WYSIWYG ? .... mmmhhh

MOVED:WYSIWYG ? .... mmmhhh

[iReport 4.0.1] issue with styles

[iReport 4.0.1] issue with styles

simple problem : page break & subreport

simple problem : page break & subreport

what is the best design to create pivot?

what is the best design to create pivot?

BIG ISSUE? -> correlation between SORTING and an error on datasource LIST

thread or guide that explain FULLY ther XML data source

Activity

Products

Explore