Select Sifiso

Report Manager

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 »

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 »