Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 4  LAYING OUT A REPORT


Listing 4-4. Matrix RDL Listing

<Tablix Name="matrix1">
<TablixCorner>
<TablixCornerRows>
<TablixCornerRow>
<TablixCornerCell>
<CellContents>
<Textbox Name="textbox1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<ZIndex>3</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>

The completed report for the Matrix object is called Matrix.rdl and is available in the Pro_SSRS
project.

Summary

In this chapter, you learned that each report consists of defined elements that are based on a defined
schema in the RDL, which gives SSRS the advantage of standardization. We covered the report objects
that make up reports and viewed their properties and functionality. You also saw for each object how the
graphical design components are directly translated to RDL through the design process. Now that you’re
more comfortable with the design environment, you’ll learn how to use it to design and deploy some real
reports.
In the next chapter, we’ll show how to spice up reports by adding graphs and charts. You can look at
a graph or a chart as just another type of report, but they are visually different enough to treat separately
in their own chapter.
Free download pdf