majst2005 Posted January 28, 2015 Share Posted January 28, 2015 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. Link to comment Share on other sites More sharing options...
nthapa Posted January 30, 2015 Share Posted January 30, 2015 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? 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