Add Student Selector to Publish SQL Report
How do I add the Student Selector when creating a Jasper Report based upon SQL?
-
Official comment
Hi Marianna,
To add the the Student Scope Selector to your SQL-Based reports, you need to attach the magical "visibility_sql" custom report to your BI Tool report.
- Open your BI Tool report in Illuminate
- Click the "Edit" button
- Where it says, "Select Custom Report", search for "visibility_sql"
- Select the "visibility_sql" custom report.
- Click Save.
IMPORTANT: Your report's query MUST use the $P{visibility_sql} parameter in the WHERE clause. Otherwise, the Student Scope Selector will not work, and your report will not respect visibility. Feel free to reach out to me if you need any help with this.
NOTE (for users who have been using the BI Tool pre-2019): You no longer need to attach the visibility_sql custom report in a separate step. You can now install your JRXML and attach the visibility_sql custom report in a single step. Yay! That also means, you can update your reports without having to remove and re-attach the visibilty_sql custom report. Yay!
Comment actions
Please sign in to leave a comment.
Comments
4 comments