knguyen_2 Posted January 10, 2017 Share Posted January 10, 2017 Hello,When I go to the Ad Hoc views and add all the fields, I am getting multiple rows of data. Checking the "View SQL Query", it is using 'select', and I need it to use 'select distinct'. Is there a way to do that? There are about 9 join statement for this so I need a way to select distinct values. Link to comment Share on other sites More sharing options...
hozawa Posted January 11, 2017 Share Posted January 11, 2017 Have you looked at the following thread?http://community.jaspersoft.com/questions/543632/unique-rows-ad-hoc-table 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