Subreport and Custom Datasource

[2006 IR Open Dicussion]

By: mtor - mark_v_torres

Subreport and Custom Datasource

2006-01-12 10:05

I want to call Oracle stored procedures/functions on my report, I accomplished this by creating a custom datasource and datasource provider.

 

My problem is related to subreports, I want to use my datasource or datasource provider in my subreport as well us the query string defined in the subreport to perform the query.

 

What is the best way to accomplish this?

 

 

 

 

By: Paul Connor - paul_connor

RE: Subreport and Custom Datasource

2006-01-19 07:06

I'm interested in this problem and its solution too.

 

 

 

 

 

By: Teodor Danciu - teodord

RE: Subreport and Custom Datasource

2006-01-19 08:07

 

Hi,

 

We now have two new interfaces that could be

implemented and used for that.

The JRQueryExecuter and JRQueryExecuterFactory.

Implement those instead of the data source provider

interface.

To see how, take a look at the provided "hibernate"

sample.

 

This is all on CVS and will be part of the next

release.

 

I hope this helps.

Teodor

 

 

 

 

 

By: mtor - mark_v_torres

RE: Subreport and Custom Datasource

2006-01-19 10:52

Thanks Teodor,

 

We ended up having a similar solution, we created an OracleQueryExecuter, and plugged it in the filler class which was calling the query executer. Its nice to know that we dont need to maintain that custom code anymore now that we can plug a custom QueryExecuter.

 

Thanks a lot for the excellent support.