THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

Home

Blogs

Forums

Downloads

Opml

Jorg Klein

Jorg Klein, Microsoft-only BI consultant from the Netherlands, blogging about BI on SQL Server with a focus on SSIS.

SSRS - Custom expressions for subtotals in a matrix

If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the default sum, you need to use the InScope() and Iif() functions in your data field…

When you create a matrix with SSRS you get the following default groups:
A row group named: matrix1_RowGroup1
A column group named: matrix1_ColumnGroup1

With the normal functionalities you can’t change much on the behavior of your subtotals in your matrix. When you create a subtotal it calculates a subtotal and that’s about it ;-)

If you use the following expression in the data field of your matrix you can take full control on the behavior of all your subtotals:

=Iif(InScope("matrix1_ColumnGroup1"),

Iif(InScope("matrix1_RowGroup1"),

"In Cell",

"In Subtotal of RowGroup1"),

Iif(InScope("matrix1_RowGroup1"),

"In Subtotal of ColumnGroup1",

"In Subtotal of entire matrix"))

Replace "In Cell", "In Subtotal of RowGroup1", "In Subtotal of ColumnGroup1" and/or "In Subtotal of entire matrix" with the expressions or fields that you want.

For example, if you want to calculate an average:

Replace "In Cell" with Sum(Fields!Amount.Value)

Replace "In Subtotal of RowGroup1" with Avg(Fields!Amount.Value)

More information about the InScope() function on MSDN

Published Thursday, December 06, 2007 11:10 PM by jorg

Filed under: SSRS

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	DebW said: I suspect I have to use the inscope function to get this working correctly in my matrix report =IIf(Sum(Fields!ACP_hrsPosted.Value)<First(Fields!SOW.Value, "DataSet1") , "Red","Black") here is the xml.... <?xml version="1.0" encoding="utf-8"?> <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> <DataSources> <DataSource Name="DataSource1"> <ConnectionProperties> <DataProvider>SQL</DataProvider> <ConnectString>Data Source=192.168.252.252;Initial Catalog=dev</ConnectString> </ConnectionProperties> <rd:DataSourceID>84303511-0bf1-489c-a287-812e8387e5c1</rd:DataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="DataSet1"> <Fields> <Field Name="ACPID"> <DataField>ACPID</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="caid"> <DataField>caid</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Name"> <DataField>Name</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="HomePhone"> <DataField>HomePhone</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AlternatePhone1"> <DataField>AlternatePhone1</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AlternatePhone2"> <DataField>AlternatePhone2</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ServicePhone"> <DataField>ServicePhone</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Email"> <DataField>Email</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="NetworkStartDate"> <DataField>NetworkStartDate</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="Starmaticid"> <DataField>Starmaticid</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ClientRequestedHrs"> <DataField>ClientRequestedHrs</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ClientSelectedHrs"> <DataField>ClientSelectedHrs</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ClientShortfallHrs"> <DataField>ClientShortfallHrs</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ClientShortfallPct"> <DataField>ClientShortfallPct</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ClientId"> <DataField>ClientId</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="CompanyName"> <DataField>CompanyName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ApplicationName"> <DataField>ApplicationName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AppAtRiskForShortfall"> <DataField>AppAtRiskForShortfall</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="version"> <DataField>version</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="AgreementStatusDate"> <DataField>AgreementStatusDate</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="weekof"> <DataField>weekof</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="IsPFApplication"> <DataField>IsPFApplication</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="PFApplicationIsPrimary"> <DataField>PFApplicationIsPrimary</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ACP_hrsPosted"> <DataField>ACP_hrsPosted</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="SOW"> <DataField>SOW</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="NoPoster"> <DataField>NoPoster</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="LowPoster"> <DataField>LowPoster</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="LastPostDate"> <DataField>LastPostDate</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> <Field Name="datestamp"> <DataField>datestamp</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>DataSource1</DataSourceName> <CommandText>select * from dbo.tmp_nopostlowpost</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> </DataSets> <Body> <ReportItems> <Tablix Name="List1"> <TablixBody> <TablixColumns> <TablixColumn> <Width>13.6875in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>1.34in</Height> <TablixCells> <TablixCell> <CellContents> <Rectangle Name="List1_Contents"> <ReportItems> <Tablix Name="matrix1"> <TablixCorner> <TablixCornerRows> <TablixCornerRow> <TablixCornerCell> <CellContents> <Textbox Name="textbox4"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>ACP Name</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>textbox4</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <VerticalAlign>Bottom</VerticalAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <RowSpan>3</RowSpan> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox57"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox57</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox5"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox5</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox61"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox61</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox15"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox15</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox79"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox79</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox53"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox53</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox49"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox49</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox45"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox45</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox41"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox41</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> </TablixCornerRow> <TablixCornerRow> <TablixCornerCell /> <TablixCornerCell> <CellContents> <Textbox Name="Textbox58"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox58</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox6"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox6</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox62"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox62</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox16"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox16</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox80"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox80</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox54"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox54</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox50"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox50</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox46"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox46</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox42"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox42</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> </TablixCornerRow> <TablixCornerRow> <TablixCornerCell /> <TablixCornerCell> <CellContents> <Textbox Name="Textbox59"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>ACPID</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox59</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox7"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>SOW</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox7</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox63"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Email</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox63</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox17"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Network Start Date</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox17</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox81"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Agreement Status Date</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox81</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox55"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Home Phone</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox55</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox51"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Alternate Phone1</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox51</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox47"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Alternate Phone2</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox47</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> <TablixCornerCell> <CellContents> <Textbox Name="Textbox43"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Service Phone</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox43</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> </TablixCornerRow> </TablixCornerRows> </TablixCorner> <TablixBody> <TablixColumns> <TablixColumn> <Width>0.67708in</Width> </TablixColumn> <TablixColumn> <Width>0.63542in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.21in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox12"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!ACP_hrsPosted.Value)</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Medium</FontWeight> <Color>=IIf(Sum(Fields!ACP_hrsPosted.Value)<20 , "Red","Black")</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox12</rd:DefaultName> <Style> <Border> <Style>Solid</Style> </Border> <BackgroundColor>LightGrey</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <rd:Selected>true</rd:Selected> </CellContents> <DataElementOutput>Output</DataElementOutput> </TablixCell> <TablixCell> <CellContents> <Textbox Name="textbox3"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!ACP_hrsPosted.Value)</Value> <Style> <FontFamily>Tahoma</FontFamily> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>textbox3</rd:DefaultName> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> <DataElementOutput>Output</DataElementOutput> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember> <Group Name="matrix1_weekof"> <GroupExpressions> <GroupExpression>=Fields!weekof.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!weekof.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>0.21in</Size> <CellContents> <Textbox Name="weekof"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!weekof.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Format>MM/dd/yy</Format> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Center</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>weekof</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.21in</Size> <CellContents> <Textbox Name="Textbox10"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Total</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox10</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>SlateGray</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.21in</Size> <CellContents> <Textbox Name="Textbox11"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>ACP hrs Posted</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox11</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>#8fa0b0</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> </TablixMembers> </TablixMember> <TablixMember> <Group Name="matrix1_ApplicationName"> <GroupExpressions> <GroupExpression>=Fields!ApplicationName.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!ApplicationName.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>0.21in</Size> <CellContents> <Textbox Name="ApplicationName"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!ApplicationName.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>ApplicationName</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>SlateGray</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.21in</Size> <CellContents> <Textbox Name="textbox6"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>ACP hrs Posted</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> </Style> </Paragraph> </Paragraphs> <rd:DefaultName>textbox6</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>#8fa0b0</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <KeepTogether>true</KeepTogether> </TablixMember> </TablixMembers> <DataElementOutput>Output</DataElementOutput> <KeepTogether>true</KeepTogether> </TablixMember> </TablixMembers> <DataElementOutput>Output</DataElementOutput> </TablixMember> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember> <Group Name="matrix1_Name"> <GroupExpressions> <GroupExpression>=Fields!Name.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Name.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>2.13542in</Size> <CellContents> <Textbox Name="Name"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Name.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Name</rd:DefaultName> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember> <Group Name="SOW"> <GroupExpressions> <GroupExpression>=Fields!SOW.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!SOW.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="ACPID"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=first(Fields!ACPID.Value)</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>ACPID</rd:DefaultName> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="SOW"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!SOW.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>SOW</rd:DefaultName> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Email"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Email.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Email</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="NetworkStartDate"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!NetworkStartDate.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Format>M/dd/yy</Format> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>NetworkStartDate</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="AgreementStatusDate1"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!AgreementStatusDate.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Format>MM/dd/yy</Format> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>AgreementStatusDate1</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1.17708in</Size> <CellContents> <Textbox Name="HomePhone"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!HomePhone.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Format>phone</Format> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>HomePhone</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1.19792in</Size> <CellContents> <Textbox Name="AlternatePhone1"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!AlternatePhone1.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>AlternatePhone1</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="AlternatePhone2"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!AlternatePhone2.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>AlternatePhone2</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="ServicePhone"> <CanGrow>true</CanGrow> <ToggleImage> <InitialState>true</InitialState> </ToggleImage> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!ServicePhone.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontWeight>Bold</FontWeight> <Color>White</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>ServicePhone</rd:DefaultName> <Visibility> <Hidden>true</Hidden> <ToggleItem>Textbox6</ToggleItem> </Visibility> <Style> <Border> <Style>Solid</Style> </Border> <TopBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color> <Style>Solid</Style> <Width>1pt</Width> </RightBorder> <BackgroundColor>#6e9eca</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> <DataElementOutput>Output</DataElementOutput> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <RepeatColumnHeaders>true</RepeatColumnHeaders> <RepeatRowHeaders>true</RepeatRowHeaders> <DataSetName>DataSet1</DataSetName> <Filters> <Filter> <FilterExpression>=Fields!PFApplicationIsPrimary.Value</FilterExpression> <Operator>Equal</Operator> <FilterValues> <FilterValue DataType="Integer">0</FilterValue> </FilterValues> </Filter> </Filters> <Top>0.5in</Top> <Height>0.84in</Height> <Width>12.82292in</Width> <Style /> </Tablix> <Textbox Name="CompanyName"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!CompanyName.Value</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontSize>14pt</FontSize> <Color>SlateGray</Color> </Style> </TextRun> <TextRun> <Value xml:space="preserve"> </Value> <Style> <FontFamily>Tahoma</FontFamily> <FontSize>14pt</FontSize> <Color>SlateGray</Color> </Style> </TextRun> <TextRun> <Value>= "Report as of "+First(Fields!datestamp.Value, "DataSet1")</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>CompanyName</rd:DefaultName> <Height>0.27in</Height> <Width>5in</Width> <ZIndex>1</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <Textbox Name="CompanyName2"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Click on the "+" or "2" to toggle</Value> <Style> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <Color>Blue</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>CompanyName</rd:DefaultName> <Top>0.26999in</Top> <Height>0.18834in</Height> <Width>5in</Width> <ZIndex>2</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <KeepTogether>true</KeepTogether> <Style /> </Rectangle> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <Group Name="list1_CompanyName"> <DocumentMapLabel>="Low Post: "+Fields!CompanyName.Value</DocumentMapLabel> <GroupExpressions> <GroupExpression>=Fields!CompanyName.Value</GroupExpression> </GroupExpressions> <PageBreak> <BreakLocation>Between</BreakLocation> </PageBreak> </Group> <SortExpressions> <SortExpression> <Value>=Fields!CompanyName.Value</Value> </SortExpression> </SortExpressions> <DataElementOutput>Output</DataElementOutput> <KeepTogether>true</KeepTogether> </TablixMember> </TablixMembers> </TablixRowHierarchy> <RepeatColumnHeaders>true</RepeatColumnHeaders> <RepeatRowHeaders>true</RepeatRowHeaders> <DataSetName>DataSet1</DataSetName> <PageBreak> <BreakLocation>End</BreakLocation> </PageBreak> <Top>0.41556in</Top> <Height>1.34in</Height> <Width>13.6875in</Width> <Style> <FontFamily>Tahoma</FontFamily> <FontSize>14pt</FontSize> <Color>SlateGray</Color> </Style> </Tablix> <Textbox Name="textbox1"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Low Posters </Value> <Style> <FontFamily>Tahoma</FontFamily> <FontSize>20pt</FontSize> <FontWeight>Bold</FontWeight> <Color>SteelBlue</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>textbox1</rd:DefaultName> <Height>0.36in</Height> <Width>5in</Width> <ZIndex>1</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </ReportItems> <Height>1.80417in</Height> <Style /> </Body> <Width>13.82292in</Width> <Page> <LeftMargin>1in</LeftMargin> <RightMargin>1in</RightMargin> <TopMargin>1in</TopMargin> <BottomMargin>1in</BottomMargin> <Style /> </Page> <Language>en-US</Language> <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace> <rd:ReportID>7b2c4616-e64b-4bb4-a44d-6d4fcd5dcf24</rd:ReportID> <rd:ReportUnitType>Inch</rd:ReportUnitType> </Report> February 8, 2010 2:11 PM
	sandy said: Hi, I am new to SSRS matrix report. I am currently facing the following problems: . I have no column grouping . I have two rows grouping Matrix1_level1 and Matrix1_level2 I have the following expression inside a cell in a matrix data region. =iif(inscope(“Matrix1_level2″), “Within Group2 Scope”, iif(inscope(“Matrix1_level1″), “Within Group1 Scope”, iif(inscope(“matrix1″), “Within Matrix Scope”, nothing))) But this is not working. The result I get is this. On both group1’s line and group2’s line as “Within Group1 Scope”. and subtotal “Within Matrix Scope” message is showing up ok. February 10, 2010 9:32 AM
	jorg said: Hi Sandy, A good way to "debug" the InScope function is to change the background color of your cells instead of showing the text. Use the full script to change the background color of each part of your matrix with another color. This way it's easy to see what's happening! Good luck and if you face any other problems, let me know! -Jorg February 23, 2010 5:44 AM
	Pour ceux coinc??s en 2005 « La BI ??a vous gagne! said: PingBack from http://fleid.wordpress.com/2010/09/15/pour-ceux-coinces-en-2005/ September 15, 2010 8:33 AM
	kay said: Hi, I am wondering if you can help with my forecast report. My Source is like this: Quote_Number AAA-001 AAA-002 Customer ABC Ltd XYZ Co. Item1_Price 2500.00 1200.00 Item2_Price 1200.00 1400.00 Order_Date 18/11/2011 15/12/2011 The expected Invoice Date of Item1_Price is 30 days after the Order Date. The expected Invoice Date of Item2_Price is 15 days after the Order Date. We want to report it like this: Nov-2011 Dec-2011 Jan-2012 Quote Customer Order Invoice Order Invoice Order Invoice AAA-001 ABC Ltd 37 12 0 25 0 0 AAA-002 XYZ Co. 0 0 26 14 0 12 Total 37 12 26 37 0 12 Note: Display is in thousands. I know how the orders will work in a matrix. But the Invoice column is tricky. Any suggestion on how to do it? Thank you very much. Kay October 13, 2011 7:46 AM