[subreport into crosstab]

Hi all!

 

I have to do a school hours report like this

 

__|D1______||D2______|...|Dn

__|H1|H2|H3||H1|H2|H3|...|

T1|C1|C1|C2||C3|C4|C4|...|

T2|C4|C3|C1||C1|C1|C2|...|

...

Tn|

 

I wold like to use a .xml file like this to fill the report

 

<db>

<teacher>

<id></id>

<lastname></lastname>

<firstname></firstname>

</teacher>

...

<class>

<id></id>

<year></year>

<section></section>

<studies></studies>

</class>

...

<teaching>

<teacherid></teacherid>

<classid></classid>

<day></day>

<hour></hour>

</teaching>

...

</db>

 

the primary xPath query is /db/teaching teacherid, classid, day and hour fields are defined into the master report

 

In the crosstab, teacherid field is the row group, day field is the first column group

hour field is the second column group and classid field is the datail element.

 

I would like to print teacher's firstname and lastname instead of teacherid and class's year, section and studies instead of classid but I can't use subreport into a crosstab.

 

Is there a way to do this??

 

Tnx in advance

[xmldatasource and crosstab]

Hi all and.. sorry for my english :)

I'm new to jasperreports.

I am starting with a simple report like this

 

__|C1_|C2_|..|Cm

R1|V11|V12|..|V1m

R2|V21|V22|..|V2m

................

Rn|Vn1|Vn2|..|Vnm

 

My datasource is a xml file

 

<db>

<element>

<r></r>

<c></c>

<v></v>

</element>

</db>

 

I've created a new XML datasource

("Use the report xPath expression to fill the report" radioButton selected)

 

looking at this I used /db/element as primary query

I've also made a subdataset with /db/element[$P{POSITION}]

POSITION is a java.lang.Integer

I pass $V{REPORT_COUNT}

 

In this subdataset I've defined the r, c and v fields

 

I've put a crosstab in summary (I've also tried to put it in detail)

I've used the subdataset with the crosstab, setting r as row group, c as column group and v as detail (function: nothing).

In the crosstab property windows, I've added the POSITION parameter.

 

The report compiles without problems.

When I try to fill the report (Build->Execute with active connection) the result is a empy page.

 

I also tried to change the "Connection/Data Source Expression" to "Use a data Source" XML_DATA_DOCUMENT and passing

the xml file like in the xmldatasource example

 

Map params = new HashMap();

Document document = JRXmlUtils.parse(JRLoader.getLocationInputStream("db.xml"));

params.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, document);

...

JasperFillManager.fillReportToFile(fileName, params);

 

when i fill the report an exception is throw

JRXPathQueryExecuterFactory org.w3c.dom.Document document is null??

 

What's wrong??

Can you show me a simple example with xmldatasource and crosstab?

 

Tnx in advance!