The Data Report session type can be used to empower any/all users to generate reports, without having to grant them access to the actual server.
Settings
General
Create a Data Report entry and define the connection string by either:- Specify the connection in the entry itself.
- Use a credential entry.
- Inherited from a parent.
- Prompt for credentials.
Parameters
Specify the parameters by setting the name, type and default value of all parameters.Query
Enter the query in the Query tab, which features an SQL syntax-highlighted text box with line numbers.Ensure that your DBA sets the proper user groups, and that each specific user(s) has access to it.