Any database view that starts with the “rpt” prefix is designed as a reporting view, and intended to be consumed by a reporting tool such as Crystal Reports, SSRS (SQL Server Reporting Services), PowerBI, Excel, Cognos or any other reporting tool.
View design considerations
The views are designed around an “inheritance” pattern - that is, views reference other views. This allows for ease of use and construction of reporting views and report design, but is generally not considered best practice. Views that reference other views can become bloated with unnessesary database fields, and this can in turn affect performance and network traffic.
Optimizing report views
A basic view that display client information. Contains the Primary Site only
Extends rptClient_Basic by including additional site details, including the site hierarchy for the client’s primary site
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.