Is there a default row limit when running reports?

[ylva.degerfeldt]

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

[dprogrammer]

Click Window--> Preferences--> Jaspersoft Studio--> Report Execution: Make sure there is no limit under check box 'Limit Number of Records'.

[ylva.degerfeldt]

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!