Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: Shortcomings - SSRS

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Tue, Aug 09, 2011, 3:48 PM


Overview

This article is simply a list of notable shortcomings I've encountered with SQL Server Reporting Services.

Repeating Row Headers

Issue: Repeating row headers is not as straightfoward as it could be, but it is possible. See the details here.

Multi-Column Subreports

Issue: A subreport that's configured for multiple columns (via its Columns property) will render as one column, even though running the subreport as a simple report renders correctly (i.e., with multiple columns). Per Microsoft (see links below), this is a known issue with no resolution planned.

  • http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4ec6e9f8-2d2e-46c2-b00a-93826097ddd1
  • https://connect.microsoft.com/SQLServer/feedback/details/362871/multi-column-subreports-do-not-work

Page Headers and Footers

Issue: Cannot put a subreport nor any field value from any dataset in a page header or page footer.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.