multiple datasources

[adamzrk]

I have to use in my jrmxl template multiple JRBeanCollectionDataSources with different beans. Report will contain a few crosstabs. Can anyone tell me is this possible? Can I pass somehow multiple JRBeanCollectionDataSources to jrxml file and proceed it?

 

Regards

Adam

[lucianc]

If you only intend to use each data source for a single crosstab, you can take the following approach:

• create a subdataset corresponding to the data source

pass the JRBeanCollectionDataSource as a report parameter

connect the crosstab to the subdataset and use the JRBeanCollectionDataSource parameter as data source:

Code:

<crosstab>
  <crosstabDataset>
    <dataset>
      <datasetRun subDataset="myCrosstabDataset">
        <dataSourceExpression>$P{myCrosstabDataSource}</dataSourceExpression>
      </datasetRun>
    </dataset>
  </crosstabDataset>
</crosstab>
[/ul]

 

HTH,

Lucian

[adamzrk]

But what about <rowGroup>, <crosstabRowHeader> and other tags specific for <crosstab> ? Can have I multiple different crosstabs in my report?

 

Regards

Adam

Post edited by: adamzrk, at: 2007/02/20 10:24

[lucianc]

What about <rowGroup> and <crosstabRowHeader>? I don't understand the question.

 

And yes, you can have several crosstabs in a report.

 

Regards,

Lucian

[adamzrk]

Thanks. When I use Your suggestion I used JRBeanCollectionDataSource as parameter I got exception:

 

15:01:22,380 ERROR [Digester] End event threw exception

java.lang.NoSuchMethodException: No such accessible method: setDataSourceExpression() on object: net.sf.jasperreports.crosstabs.design.JRDesignCrosstabDataset

at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:248)

at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:216)

[lucianc]

How does your <crosstabDataset> look like?

[adamzrk]

<crosstabDataset>

<dataset >

<datasetRun subDataset="globalVisitCountPerPageDS" />

<dataSourceExpression>$P{globalVisitCountPerPage}</dataSourceExpression>

</datasetRun>

</dataset>

</crosstabDataset>

 

and on the start of my jrxml:

<subDataset name="globalVisitCountPerPageDS">

<field name="pageName" />

<field name="userName" />

<field name="visits" class="java.lang.Long" />

</subDataset>

 

Th fields come from java code:

parameters.put("globalVisitCountPerPage", new JRBeanCollectionDataSource(someDao.getData()));

[lucianc]

adamzrk wrote:

<crosstabDataset> <dataset > <datasetRun subDataset="globalVisitCountPerPageDS" /> <dataSourceExpression>$P{globalVisitCountPerPage}</dataSourceExpression> </datasetRun> </dataset> </crosstabDataset>

 

This is not well-formed XML.

[adamzrk]

Hmm.. Why isn't it well-formed?

The exception I showed doesn't tell anything about well-formed xml...

 

Exception:

net.sf.jasperreports.engine.JRException: Error at line 115 char 58: No such accessible method: setDataSourceExpression() on object: net.sf.jasperreports.crosstabs.design.JRDesignCrosstabDataset

 

at line 115 in my jrxml I have:

<dataSourceExpression >v</dataSourceExpression>

the exception is the same even if it looks like:

<dataSourceExpression >$P{globalVisitCountPerPage}</dataSourceExpression>

or

<dataSourceExpression ><![CDATA[$P{globalVisitCountPerPage}]]></dataSourceExpression>

 

I have no idea what is wrong :(

 

regards

Post edited by: adamzrk, at: 2007/02/20 13:52

[lucianc]

As I said, the XML fragment is not well-formed:

 

<dataset> start data set element

<datasetRun subDataset="globalVisitCountPerPageDS"/> empty element (closed)

<dataSourceExpression>..</dataSourceExpression>

</datasetRun> datasetRun was already closed two lines ago

[adamzrk]

me stupido....

Thanks!

 

regards

adam