Chart

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 »

XML Document Sourced SSRS Report Using HTTP URL

Leave a Comment / HTTP Connection, SSRS, XML / By

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 …

XML Document Sourced SSRS Report Using HTTP URL Read More »