SSRS Reports and Data Type Security Over VRL

Posted: Monday, 22 March 2021 at 09:18PM

By default, SSRS reports when piped over VRL do not support Data Type security for criteria such as job. The reason for this is that VRL uses a common, shared service SSRS account to access and query data over SSRS. This makes normal SSRS-based data type security impossible over VRL.

To address this issue it is necessary to work around this problem by creating a Custom View within the Vista database. The Custom View is then used by the SSRS report to appropriately limit the data points that are returned to only those that are allowed to be returned by the jobs or other criteria to which the user has access. The logged in user in Vista is used as the criteria for the custom view.

Example:

A view is created where it is based upon a SELECT * WHERE statement tied to the user's login ID. This will allow for a query of data points that are filtered by the jobs to which the user is intended to access.