SQL Server Reporting Services (SSRS)

SSRS is Microsoft’s reporting platform which was designed to deliver reports with robust features to support analytical decision-making and part of the Business Intelligence (BI) lifecycle (SQL Server, SQL Server Integration Service (SSIS), and SQL Server Analysis Services (SSAS).  For more information, read An Overview. SQL Server Reporting Services (SSRS) 2008 Updates An Overview Calculation…

Business Intelligence

Business Intelligence (BI) encompasses leveraging descriptive and inferential statistical analysis upon massive organizational data stores to enable strategic decision-making. SQL Server Analysis Services (SSAS) SQL Server Analysis Services (SSAS) is Microsoft’s solution to the organization’s needs for Online analytical processing (OLAP) which leverage a data warehouse to provide self-service business intelligence capabilities to end users. SQL…

SSRS: Textbox with HTML Formatting

Providing rich formatting within text. Most reports require some type of rich formatting usually reserved for HTML.  However, SSRS provides such formatting utilizing expressions. Drag a textbox onto the Report Designer. Resize the textbox to fit. Here it is with some formatting. After setting the textbox expression to display the current date/time, my textbox looks…

SSRS: 2008 Updates

New features and updates to the latest version of Reporting Services. Here are just some of a few of my favorite improvements made to the 2008 release of SSRS. The most noticeable to me was the absence of the “Data” tab within the designer. Instead of having to click back and forth between tabs when…

SSRS: Report Header

Adding a graphic to the header of a report. Most reports require some sort of identifying header at the top of each page. While the header itself may be text, using a graphic provides a more polished look (though in my example I use a plain graphic). I’ll begin with the report created for the…

SSRS: Parameters

Providing control to the user to determine which records should be returned. As with most reports, reports might contain thousands of records, many of which the user doesn’t desire to view. To allow the user to decide upon a smaller subset of records, reports should be equipped with parameters commonly used with stored procedures. To…

SSRS: Nested Groups with Totals

Providing group totals within nested groups. Often a need arises with reports to group data. Grouping data provides the user with the ability to see records grouped based on shared values for certain fields, “Product Name” for example. As helpful as grouping may be, most people will need metrics to go along with those grouped…