rdevries Posted June 8, 2018 Share Posted June 8, 2018 After migrating from Jasperserver 6.3.0 to 6.4.2, reports that were previously many pages of results are now only displaying a single page. When looking at the SQL being run on the database that is generating this report, I also noticed in 6.3.0 it is doing a select top 200001, where in 6.4.2 it only does a select top 1000. Regardless, more results are returned by the SQL query than are displayed in the report.After some further testing, it seems like the reports are only pulling 15 rows of sample data. When I look at the view the report references, it also shows 15 rows when the drop down is set to "Sample Data". When I set it to "Full Data", the view pulls many more rows. However, if I save the view set to "Full Data", the report changes to only displaying a single row. Link to comment Share on other sites More sharing options...
hozawa Posted June 9, 2018 Share Posted June 9, 2018 Have you tried the resolution explained in the following page?https://community.jaspersoft.com/wiki/ad-hoc-row-limit 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