Select Sifiso

SSRS 2012

Handling No Data in SSRS Controls

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 …

Handling No Data in SSRS Controls Read More »

XML Document Sourced SSRS Report Using HTTP URL

Introduction In my Business Intelligence development experience, most of my SQL Server Reporting Services (SSRS) Reports have largely been based off a relational data sources such Microsoft SQL Server and Oracle database. However, in some instances whereby an SSRS report is based off Operational Data Source (ODS) or Online transaction processing (OLTP) system, Extensible Markup Language …

XML Document Sourced SSRS Report Using HTTP URL Read More »

Failing to Preview Report in Report Builder

Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for 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 experience …

Failing to Preview Report in Report Builder Read More »