Online Help > Support/Resources > Tips And Tricks

Data Report

Description

 

The Data Report session type can be use to empower any/all users to generate reports, without having to grant them access to the actual server.

 

Settings

 

General

Data Report Session

Data Report Session

 

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

Data Report Session - Paramaters tab

Data Report Session - Paramaters tab

 

Specify the parameters by setting the name, type and default value of all parameters.

 

Query

Query Tab

 

Enter the query in the Query tab, which features a SQL syntax-highlighted text box with line numbers.

 

Ensure that your DBA sets the proper security groups, and that each specific user(s) has access to it.