Jump to content
We've recently updated our Privacy Statement, available here ×
  • "Change the input values" and "view SQL query" button in Ad Hoc Editor


    Tom C
    • Features: Ad Hoc Version: v5.2, v5.1, v5.0 Product: JasperReports® Server

    In JasperReports Server v5.x, there are two icon buttons in the AdHoc View Editor that users often wonder about how they are supposed to work:

    buttons.png.a802f65d21c2bd9c774b547edaf4f827.png

    The "change the input values" button is only available if your AdHoc view is created from a Topic and this Topic has input controls enabled.

    adhoc-topic(1).png.b1087491031338e170c3f9d191abc14b.png

    The "view SQL query" button, by default, is not enabled. You need to login as the admin user and go to Manage - Server Settings - Ad Hoc Settings to enable (check mark) "Configure View Query". This is discussed in the JasperReports Server Administartion Guide, section 7.9.1 Ad Hoc Query Settings. You can find this document in our Documentation Section of our wedsite.

    configure-view-query.png.ab64a7c927dbca8b0445a030cea29fc6.png

    After enabling, users will able to use "view SQL query" feature in the Editor.

    view-query.png.b6dbc842a4aed47b71f29b7608fad1b4.png


    TTC-20130725

    buttons.png.d777351c51bd78329891b06f71945550.png

    adhoc-topic(1).png.c187cb391e685e5a4e72097a41ebca4a.png

    configure-view-query.png.40c11dc96912dcfaec121a84306f2ee0.png

    view-query.png.a8715656e9dd827f4974eb326d4df8b3.png


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...