Ad Hoc Report Not Returning All Data

When viewing an ad hoc report in JRS, only the first 36 pages are being returned.  By default, the input controls are all set to "is one of", with the "NONE" option selected to bring back everything that the view/domain finds.  If I switch the filters to "ALL" while viewing the report, all pages (approx. 1500) are returned.  Since this report is used against several sets of data, is there a way to display all the data on the report while having the input controls set to "NONE"?  This is a default tomcat/postgreSQL installation on a 64-bit, Windows 7 machine, connecting to an Oracle 11gR2 database using the TIBCO Oracle driver.

Thanks in advance.

majst2005's picture
Joined: Oct 28 2011 - 11:02am
Last seen: 7 years 6 months ago

in the adhoc designer there is a button to view the sql that is being generated to fetch the data. Can you check if this is showing up the correct sql?

nthapa - 8 years 8 months ago

0 Answers:

No answers yet