When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List, etc.), the result set can either be empty (which means no data returned) or actually show data. In cases whereby an empty result set is returned, SSRS controls, such as tables and charts, use NoDataMessage and NoRowsMessage properties to inform report users …
Introduction In my Business Intelligence development experience, most of my SQL Server Reporting Services (SSRS) Reports have largely been based on relational data sources such as Microsoft SQL Server and Oracle database. However, in some instances whereby an SSRS report is based on an Operational Data Source (ODS) or Online transaction processing (OLTP) system, Extensible Markup …
Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for the client’s business users to be able to design, develop and publish ad hoc reports using Report Builder 3.0. During unit testing we had one of the Business Analysts (BA) in our team simulate business user …
