Green-Bar Matrix

Question:How can I get a green-bar effect (alternating colors) in a matrix? Answer:For a green-bar table, you can simply use a background color expression like this: =iif(RowNumber(Nothing) Mod 2,”Green”,”White”)However, there is currently no GroupNumber() function on which to base a green-bar calculation in a matrix.GroupNumber can be (mostly) simulated by using the RunningValue function to…

0

MatrixGreenBar.rdl

<?xml version=”1.0″ encoding=”utf-8″?><Report xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition” xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner”>  <RightMargin>1in</RightMargin>  <Body>    <ReportItems>      <Matrix Name=”matrix1″>        <Corner>          <ReportItems>            <Textbox Name=”textbox1″>              <Style>                <PaddingLeft>2pt</PaddingLeft>                <BorderStyle>                  <Default>Solid</Default>                </BorderStyle>                <PaddingBottom>2pt</PaddingBottom>                <PaddingTop>2pt</PaddingTop>                <PaddingRight>2pt</PaddingRight>              </Style>              <ZIndex>4</ZIndex>              <rd:DefaultName>textbox1</rd:DefaultName>              <CanGrow>true</CanGrow>              <Value />            </Textbox>          </ReportItems>        </Corner>        <Height>0.5in</Height>        <Style />        <MatrixRows>          <MatrixRow>            <MatrixCells>              <MatrixCell>                <ReportItems>                  <Textbox Name=”Qty”>                    <Style>                      <PaddingLeft>2pt</PaddingLeft>                      <BackgroundColor>=ReportItems!Color.Value</BackgroundColor>                      <BorderStyle>                        <Default>Solid</Default>                      </BorderStyle>                      <TextAlign>Right</TextAlign>                      <PaddingBottom>2pt</PaddingBottom>                      <PaddingTop>2pt</PaddingTop>                      <PaddingRight>2pt</PaddingRight>                    </Style>                    <rd:DefaultName>Qty</rd:DefaultName>                    <CanGrow>true</CanGrow>                    <Value>=Sum(Fields!Qty.Value)</Value>                 …

0