"View SQL Query" button to be reinstated in Advanced Reporting

Document ID : KB000073178
Last Modified Date : 14/03/2018
Show Technical Document Details
Question:
When viewing an Ad-Hoc view which we had developed we used to be able to view the background SQL via a button on the toolbar. That button is now no longer available. How can that functionality be reinstated to make the button available in the toolbar?.
Answer:
The 'View Sql Query' button can be enabled by carrying out these steps:

1. Login to Jaspersoft Report server
2. Click on 'Manage' menu on the top of the page and select 'Server Settings'
3.Under the 'Settings' section on the left of the page, click on 'Ad Hoc Settings'
4. In the 'General Ad Hoc Settings', tick the 'Enable View Query in Ad Hoc Editor' checkbox then click on the 'Change' button.