ylva.degerfeldt Posted February 1, 2017 Share Posted February 1, 2017 Hi!I have created a large report (which should generate > 40000 rows), but when I run it in JasperServer only 84 rows are shown (and I think it was 7 pages).I also tried running the same report by using a schedule and converting it to both csv and xls format, but the data in the generated files has the same limitations.Does anyone know if there's a default row limit or maybe page limit that I didn't know about?Also, the jasperserver.log shows no errors when I try to run the report.I'm using JasperServer 5.5.0 and I used Jaspersoft Studio 6.1.1 for creating the report.Any kind of help with this problem would be much appreciated!/Ylva Link to comment Share on other sites More sharing options...
Solution dprogrammer Posted February 1, 2017 Solution Share Posted February 1, 2017 Click Window--> Preferences--> Jaspersoft Studio--> Report Execution: Make sure there is no limit under check box 'Limit Number of Records'. Link to comment Share on other sites More sharing options...
ylva.degerfeldt Posted February 2, 2017 Author Share Posted February 2, 2017 Thanks for the answer, but I found out what the problem was!It was all My fault and I'm sorry for taking up your time! :-(I tried different versions of the SQL - mostly from DbVisualizer - and for performance reasons I've only been able to run the report in JasperServer a few times and the version that was uploaded there had a SQL limitation to the number of rows. :-/Like I said - I'm really sorry for taking up your time with this! 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