lxpelevin Posted October 20, 2015 Share Posted October 20, 2015 I have one complex data set. The need is to put 4 tables in report based on this dataset. So the qutsions is:How to use data from dataset for 4 tables without executing query 4 times (without database overhead)?And the next question how to put each table on seperate page? without other pagination? Link to comment Share on other sites More sharing options...
ernestoo Posted October 20, 2015 Share Posted October 20, 2015 You can "share" a dataset between different tables, have you tried this already?And for putting table on separate page, you can use the page-break element and disable pagination Link to comment Share on other sites More sharing options...
lxpelevin Posted October 20, 2015 Author Share Posted October 20, 2015 No, i haven' tried "share". How i can do this?If pagination is diabled page-break element doesn't works. Link to comment Share on other sites More sharing options...
ernestoo Posted October 21, 2015 Share Posted October 21, 2015 I made a little video you can see how to "share" a dataset between N tables: http://screencast.com/t/hBsiEjV29dYSregarding pagination, please ask a new question (or do a new search) Link to comment Share on other sites More sharing options...
lxpelevin Posted October 21, 2015 Author Share Posted October 21, 2015 Thanks for yor video.In case you have demonstrated, the query "select * from orders" will execute 2 times. So you will have two independent instances of dataset for each table. I can tell you more, there is an ability to use different input parameters for query for each table. Eg. first table can contain orders from US and the second from UK if use parameter country as input on sql level. "select * from orders where country = P{country}".In my case i have heavy query with heavy logic, so for my case not impressible to have 4x database overhead. In my case i need to execute query for report only one time. Link to comment Share on other sites More sharing options...
ernestoo Posted October 22, 2015 Share Posted October 22, 2015 Are you parametrizing the query each execution run then? If that's the case you are talking about loading the entire dataset into memory and essentially having it do the WHERE clause in memory. If that's the case you might look at Domains - they can execute in memory but you'll need to load the data into memory first Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now