Japersoft doesn't show all the data in report

0
Hi,
 
I've just started using Japersoft in AWS marketplace, created first data source, domain, and created some fisrt simple Ad Hoc View. 
In Ad Hoc View I'm trying to display chart with data of user registration dates grouped by month (also quarter, year). And problem is that it doesn't show all the data. We have user registrations started from 2008, and by default I see only data for 2008-2010 in chart. I'm pretty sure that there is all data available, because when I created filter by registration data with range between 2012-2015, it shows data for this period. But if I try to put whole period, so 2008-2015, it again shows only data for 2008-2010.
 
I tried everything I could, but still can't force it to show data for whole period. 
The question is how to do this?
Vovkin's picture
28
Joined: Sep 12 2015 - 2:24am
Last seen: 3 years 10 months ago

2 Answers:

0

As it turned out by default Jaspersoft shows only 200k items, to change that go to

Manage -> Server Settings -> Ad Hoc Settings

and set new value for field: Ad Hoc Dataset Row Limit

 

Vovkin's picture
28
Joined: Sep 12 2015 - 2:24am
Last seen: 3 years 10 months ago
0

JasperReports Server's adhoc view defaults to showing only "sample" data by default. There's a pull down list to select "sample data" or "All data".

Also, beware that JasperReports Server caches Adhoc View content. You'll need to clear the cache to get new updated content - Manage -> Server Settings -> Adhoc Cache

hozawa's picture
54688
Joined: Apr 24 2010 - 4:31pm
Last seen: 6 months 1 week ago
Feedback
randomness