Report Builder 3

Handling No Data in SSRS Controls

Leave a Comment / Report Builder, Report Builder 3, Report Manager, SQL Server 2012, SSRS / By

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

2 Comments / Execute Report Definitions, Permissions, Report Builder, Report Builder 3, Report Manager, SQL Server 2012, SSRS, System Role / By

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 …

Failing to Preview Report in Report Builder Read More »