The Report Services Module - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Database Reporting Guide
Foundation 23.1

This guide was written for the purpose of explaining the OnBase schema to aide in the writing of custom reports. Custom reports can be developed and implemented using a wide variety of reporting utilities, including OnBase Report Services.

As of OnBase 10.0 and later, an important change was made in the way Report Services connects to and executes reports against SQL Server databases. Report Services connects to the database using the Viewer account, and with this change it now sets an isolation level of READ UNCOMMITTED for this connection by default. This allows Report Services to possibly avoid blocking scenarios and gives it access to as much data as possible when querying the database. This enhancement does not affect product functionality or use.