CEL_Payroll/Payroll.Report/RDLC/rptEmployeesTaxDeduction.rdlc

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="DummyDataSource">
      <rd:DataSourceID>68a406bb-596c-43d9-9686-5396c964f0fc</rd:DataSourceID>
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString />
      </ConnectionProperties>
    </DataSource>
  </DataSources>
  <InteractiveHeight>11in</InteractiveHeight>
  <ReportParameters>
    <ReportParameter Name="SearchCriteria">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_0</Prompt>
    </ReportParameter>
    <ReportParameter Name="CompanyInfo">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_1</Prompt>
    </ReportParameter>
    <ReportParameter Name="Logo">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_2</Prompt>
    </ReportParameter>
    <ReportParameter Name="Address">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_3</Prompt>
    </ReportParameter>
    <ReportParameter Name="Phone">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_4</Prompt>
    </ReportParameter>
    <ReportParameter Name="FiscalYear">
      <DataType>String</DataType>
      <AllowBlank>true</AllowBlank>
      <Prompt>Report_Parameter_5</Prompt>
    </ReportParameter>
  </ReportParameters>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:GridSpacing>0.05in</rd:GridSpacing>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <RightMargin>0.01in</RightMargin>
  <LeftMargin>0.2in</LeftMargin>
  <PageHeader>
    <PrintOnFirstPage>true</PrintOnFirstPage>
    <ReportItems>
      <Line Name="line1">
        <Top>1.5in</Top>
        <Style>
          <BorderStyle>
            <Default>Solid</Default>
          </BorderStyle>
          <BorderWidth>
            <Default>1.75pt</Default>
          </BorderWidth>
        </Style>
        <ZIndex>5</ZIndex>
        <Left>0.15in</Left>
        <Height>0in</Height>
      </Line>
      <Textbox Name="textbox29">
        <rd:DefaultName>textbox29</rd:DefaultName>
        <Top>0.4in</Top>
        <Width>11.45in</Width>
        <Style>
          <FontWeight>700</FontWeight>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <ZIndex>4</ZIndex>
        <CanGrow>true</CanGrow>
        <Left>2.2375in</Left>
        <Height>0.2in</Height>
        <Value>=Parameters!Address.Value</Value>
      </Textbox>
      <Textbox Name="textbox21">
        <rd:DefaultName>textbox21</rd:DefaultName>
        <Top>0.575in</Top>
        <Width>11.45in</Width>
        <Style>
          <FontWeight>700</FontWeight>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <ZIndex>3</ZIndex>
        <CanGrow>true</CanGrow>
        <Left>2.2375in</Left>
        <Height>0.2in</Height>
        <Value>="Tel: " &amp; Parameters!Phone.Value</Value>
      </Textbox>
      <Image Name="image1">
        <Sizing>Fit</Sizing>
        <Top>0.1in</Top>
        <Width>2.1in</Width>
        <MIMEType>image/bmp</MIMEType>
        <Source>External</Source>
        <Style />
        <ZIndex>2</ZIndex>
        <Left>0.1375in</Left>
        <Height>0.9in</Height>
        <Value>="file:///" &amp; Parameters!Logo.Value</Value>
      </Image>
      <Textbox Name="textbox2">
        <Top>0.15in</Top>
        <Width>11.45in</Width>
        <Style>
          <FontSize>11pt</FontSize>
          <FontWeight>700</FontWeight>
          <TextAlign>Left</TextAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <ZIndex>1</ZIndex>
        <CanGrow>true</CanGrow>
        <Left>2.2375in</Left>
        <Height>0.25in</Height>
        <Value>=Parameters!CompanyInfo.Value</Value>
      </Textbox>
      <Textbox Name="textbox6">
        <rd:DefaultName>textbox6</rd:DefaultName>
        <Top>1.2in</Top>
        <Width>4.85in</Width>
        <Style>
          <BackgroundColor>Silver</BackgroundColor>
          <FontSize>9pt</FontSize>
          <FontWeight>700</FontWeight>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <CanGrow>true</CanGrow>
        <Left>0.15in</Left>
        <Height>0.25in</Height>
        <Value>="Employees Tax Deduction Report for FiscalYear : "+Parameters!FiscalYear.Value</Value>
      </Textbox>
    </ReportItems>
    <Height>1.7in</Height>
    <PrintOnLastPage>true</PrintOnLastPage>
  </PageHeader>
  <BottomMargin>0.04in</BottomMargin>
  <rd:ReportID>3db5b061-e235-4da8-a2ae-d4ad3210024d</rd:ReportID>
  <PageWidth>14in</PageWidth>
  <DataSets>
    <DataSet Name="dsEmpLeaveLedger_EmployeesTaxDeduction">
      <Fields>
        <Field Name="EmployeeNo">
          <DataField>EmployeeNo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Name">
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Designation">
          <DataField>Designation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DOJ">
          <DataField>DOJ</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Description">
          <DataField>Description</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Value">
          <DataField>Value</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Group">
          <DataField>Group</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>DummyDataSource</DataSourceName>
        <CommandText />
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <rd:DataSetInfo>
        <rd:DataSetName>dsEmpLeaveLedger</rd:DataSetName>
        <rd:TableName>EmployeesTaxDeduction</rd:TableName>
      </rd:DataSetInfo>
    </DataSet>
  </DataSets>
  <Code />
  <Width>13.75in</Width>
  <Body>
    <ReportItems>
      <Matrix Name="matrix1">
        <MatrixColumns>
          <MatrixColumn>
            <Width>0.55in</Width>
          </MatrixColumn>
        </MatrixColumns>
        <DataSetName>dsEmpLeaveLedger_EmployeesTaxDeduction</DataSetName>
        <RowGroupings>
          <RowGrouping>
            <Width>0.45in</Width>
            <DynamicRows>
              <Grouping Name="matrix1_EmployeeNo">
                <GroupExpressions>
                  <GroupExpression>=Fields!EmployeeNo.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="EmployeeNo">
                  <rd:DefaultName>EmployeeNo</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!EmployeeNo.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>1.05in</Width>
            <DynamicRows>
              <Grouping Name="matrix1_Name">
                <GroupExpressions>
                  <GroupExpression>=Fields!Name.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="Name">
                  <rd:DefaultName>Name</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Name.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>0.8in</Width>
            <DynamicRows>
              <Grouping Name="matrix1_Designation">
                <GroupExpressions>
                  <GroupExpression>=Fields!Designation.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="Designation">
                  <rd:DefaultName>Designation</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Designation.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>0.65in</Width>
            <DynamicRows>
              <Grouping Name="matrix1_DOJ">
                <GroupExpressions>
                  <GroupExpression>=Fields!DOJ.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="DOJ">
                  <rd:DefaultName>DOJ</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!DOJ.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
        </RowGroupings>
        <Top>0.15in</Top>
        <ColumnGroupings>
          <ColumnGrouping>
            <Height>0.25in</Height>
            <DynamicColumns>
              <Grouping Name="matrix1_Group">
                <GroupExpressions>
                  <GroupExpression>=Fields!Group.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="textbox7">
                  <rd:DefaultName>textbox7</rd:DefaultName>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Group.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
            <FixedHeader>true</FixedHeader>
          </ColumnGrouping>
          <ColumnGrouping>
            <Height>0.25in</Height>
            <DynamicColumns>
              <Grouping Name="matrix1_Description">
                <GroupExpressions>
                  <GroupExpression>=Fields!Description.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="Description">
                  <rd:DefaultName>Description</rd:DefaultName>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!Description.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
          </ColumnGrouping>
        </ColumnGroupings>
        <Width>3.5in</Width>
        <Corner>
          <ReportItems>
            <Rectangle Name="rectangle1">
              <ReportItems>
                <Textbox Name="textbox3">
                  <rd:DefaultName>textbox3</rd:DefaultName>
                  <Width>0.45in</Width>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Left>Solid</Left>
                      <Right>Solid</Right>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <ZIndex>3</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Value>Emp No</Value>
                </Textbox>
                <Textbox Name="textbox1">
                  <rd:DefaultName>textbox1</rd:DefaultName>
                  <Width>1.05in</Width>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Right>Solid</Right>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <ZIndex>2</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Left>0.45in</Left>
                  <Value>Name</Value>
                </Textbox>
                <Textbox Name="textbox4">
                  <rd:DefaultName>textbox4</rd:DefaultName>
                  <Width>0.8in</Width>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Right>Solid</Right>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <ZIndex>1</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Left>1.5in</Left>
                  <Value>Designation</Value>
                </Textbox>
                <Textbox Name="textbox5">
                  <rd:DefaultName>textbox5</rd:DefaultName>
                  <Style>
                    <BackgroundColor>Silver</BackgroundColor>
                    <BorderStyle>
                      <Right>Solid</Right>
                    </BorderStyle>
                    <FontSize>7pt</FontSize>
                    <FontWeight>700</FontWeight>
                    <TextAlign>Center</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Left>2.3in</Left>
                  <Value>DOJ</Value>
                </Textbox>
              </ReportItems>
              <Style>
                <BackgroundColor>Silver</BackgroundColor>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
              </Style>
            </Rectangle>
          </ReportItems>
        </Corner>
        <Style>
          <BorderStyle>
            <Default>Solid</Default>
          </BorderStyle>
        </Style>
        <MatrixRows>
          <MatrixRow>
            <Height>0.25in</Height>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="Value">
                    <rd:DefaultName>Value</rd:DefaultName>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <FontSize>7pt</FontSize>
                      <TextAlign>Right</TextAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <CanGrow>true</CanGrow>
                    <Value>=First(Fields!Value.Value)</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
          </MatrixRow>
        </MatrixRows>
        <Height>0.75in</Height>
        <Left>0.15in</Left>
      </Matrix>
    </ReportItems>
    <Height>1.05in</Height>
  </Body>
  <Language>en-US</Language>
  <PageFooter>
    <PrintOnFirstPage>true</PrintOnFirstPage>
    <ReportItems>
      <Textbox Name="textbox30">
        <Top>0.1in</Top>
        <Style>
          <FontSize>8pt</FontSize>
          <TextAlign>Right</TextAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <CanGrow>true</CanGrow>
        <Left>12.25in</Left>
        <Height>0.2in</Height>
        <Value>="Page " &amp; Globals!PageNumber &amp; " of " &amp; Globals!TotalPages</Value>
      </Textbox>
    </ReportItems>
    <Height>0.35in</Height>
    <PrintOnLastPage>true</PrintOnLastPage>
  </PageFooter>
  <TopMargin>0.29in</TopMargin>
  <PageHeight>8.27in</PageHeight>
</Report>