Jump to content
Changes to the Jaspersoft community edition download ×

Can we have dataset(sql query) for each cell(table) in Jasper iReport 5.6.0


SudhirKumar
Go to solution Solved by SudhirKumar,

Recommended Posts

I would like to create table in jasper iReport with every cells having different queries(data-sets).

 

I am able to do by creating different tables with limiting to one cell and merging the multiple tables in Detail component. But looks like its not a optimal solution.

 

In short, I wanted to fill each cell with different query in a given table. Is that possible?

 

Following code is written for two data-sets for two different tables:

 

FROM patientbill

where id = 463

FROM patientbill

where id = 463

 

Any help is highly appreciated!

 

Thank you!

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

I found alternative. Perhaps, its an hack. As, I have mentioned in my question that you cant have sub-dataset to single cell. To accomplish multiple queries in report use different tables with sub-datasets.


Bottom line is that you can't have sub-datsets in Jasper iReport.


-Thank you


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...