Power View and Reporting Services 2012 Book

Several projects kept me very busy over the past year. I will talk more about a few of these in subsequent postings now that some are publicly disclosed in the meantime. In this posting, I am very happy to announce the availability of “Professional Reporting Services 2012”. After the successful Report Design Recipes book focusing…

0

Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)!

Reporting Services 2005 with Matrix In a matrix in Reporting Services 2005, accomplishing multiple or different subtotal calculations at the same grouping level was difficult, but possible.  If you wanted to accomplish custom subtotal calculations in RS 2005, you may have heard about using the InScope function to dynamically determine the scope of a matrix…

0

Tablix – Stepped Layout

Tablix enables the separation of data groupings and layout header areas.  A stepped layout can help with horizontal spacing, because nested groups can then share the same horizontal space, which was previously not possible in a matrix layout.  This provides very powerful layout capabilities, and is one among several new features introduced with Tablix. A…

1

Tablix – The Matrix Revolution

Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008.  Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below.  If you use a list, table, matrix, chart, gauge, or custom report item in RS 2008, you are really using a tablix beneath the covers. …

2

Repeat Header / Keep Header Visible in Tables in RS 2008

You selected “Repeat header rows on each page” or “Keep header rows visible while scrolling” in the tablix properties dialog, but it doesn’t seem to work as expected?  You might want to try the following four steps if you are using a “table”-style layout: in the grouping pane, click on the small triangle and select “Advanced…

2