﻿<?xml version="1.0" encoding="utf-8"?>
<!-- Copyright Archdiocese of Cincinnati use with permission only c/o bmaly@CatholicAOC.org-->
<Report MustUnderstand="df" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily">
  <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="AOC">
      <DataSourceReference>AOCds</DataSourceReference>
      <rd:SecurityType>DataBase</rd:SecurityType>
      <rd:DataSourceID>ca9db7bd-b480-4ad8-9c6d-7d50827b04a5</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>SELECT
  c.ChurchID
  ,c.ChurchName+ ' - ' + c.City [ChurchName]
FROM
  xrpt.Churches_vw AS c
	--join xrpt.ChurchUsers_vw cu 
	--on c.ChurchID = cu.ChurchID and cu.UserName=@CurrentUser 
	--and (cu.ChurchAdministrator = 1 or cu.FundManager = 1)
order by c.ChurchName+ ' - ' + c.City</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Contributions">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@DateFrom">
            <Value>=Parameters!DateFrom.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@DateTo">
            <Value>=Parameters!DateTo.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Amount">
            <Value>=Parameters!Amount.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CurrentUser">
            <Value>=Parameters!CurrentUser.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--declare @CurrentUser varchar(50) ='bmaly@catholiccincinnati.org'
--declare @churchid int = 2
--declare @datefrom date = '2020/10/01'
--declare @dateto date ='2020/10/30'
--declare @KeyValue varchar(5) = 'ACK'

--select distinct  
--case when c.comment like '%{%}%' then SUBSTRING(c.comment,CHARINDEX('{',c.comment)+1,(CHARINDEX('}',c.comment)-CHARINDEX('{',c.comment))-1)
--	else '' end
--	FROM xrpt.FundContributions_vw c 
--   WHERE c.ContributionDate &gt;= @DateFrom AND c.contributiondate &lt;= @DateTo
--   and c.Comment like '%{%}%' 
--	and c.ChurchID = @ChurchID

select distinct 
	c.ContributionID
	,c.LastName
,c.FirstName
,c.lastName+'('+FORMAT(c.GrossAmount, 'C', 'en-us')+')' Items
	,c.BudgetNumber
	,c.ContributionDate
	,c.GrossAmount
	,c.comment
	,c.Reference
FROM xrpt.FundContributions_vw c 
   WHERE c.ContributionDate &gt;= @DateFrom AND c.contributiondate &lt;= @DateTo
--   and c.Comment like '%{'+@KeyValue+'}%'
   and (c.Comment like '%{ack}%' or c.GrossAmount &gt;= @Amount)
	and c.ChurchID = @ChurchID
	and exists ( select 1 from xrpt.ChurchUsers_vw cu
		where c.ChurchID = cu.ChurchID 
		and cu.UserName=@CurrentUser 
		and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ContributionID">
          <DataField>ContributionID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="LastName">
          <DataField>LastName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FirstName">
          <DataField>FirstName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Items">
          <DataField>Items</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BudgetNumber">
          <DataField>BudgetNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ContributionDate">
          <DataField>ContributionDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="GrossAmount">
          <DataField>GrossAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="comment">
          <DataField>comment</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Reference">
          <DataField>Reference</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="SelectedChurch">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
xrpt.churches_vw where ChurchID = @ChurchID

Select Funds = STUFF((SELECT distinct ', ' + isnull(t.ChurchName ,'')
FROM (Select ChurchName from 
xrpt.churches_vw where ChurchID = @ChurchID) t
FOR XML PATH ('')), 1, 1, '')</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr1">
          <DataField>Addr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr2">
          <DataField>Addr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="City">
          <DataField>City</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="State">
          <DataField>State</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ZipCode">
          <DataField>ZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Country">
          <DataField>Country</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PhoneNumber">
          <DataField>PhoneNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FaxNumber">
          <DataField>FaxNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Website">
          <DataField>Website</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="RETeacherCommitteeID">
          <DataField>RETeacherCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="RETeacherCommitteeName">
          <DataField>RETeacherCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REAideCommitteeID">
          <DataField>REAideCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="REAideCommitteeName">
          <DataField>REAideCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REStudentCommitteeID">
          <DataField>REStudentCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="REStudentCommitteeName">
          <DataField>REStudentCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REEmailAddress">
          <DataField>REEmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DeaneryID">
          <DataField>DeaneryID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="DeaneryName">
          <DataField>DeaneryName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AllServicePref">
          <DataField>AllServicePref</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="ParishCode">
          <DataField>ParishCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="OrganizationID">
          <DataField>OrganizationID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="YearFounded">
          <DataField>YearFounded</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="EmployerID">
          <DataField>EmployerID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EthnicAffiliation">
          <DataField>EthnicAffiliation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="County">
          <DataField>County</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Cemetery">
          <DataField>Cemetery</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DioceseInitials">
          <DataField>DioceseInitials</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Attn">
          <DataField>Attn</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AttnTitle">
          <DataField>AttnTitle</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ServiceReminder">
          <DataField>ServiceReminder</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="MinimumControlTypeID">
          <DataField>MinimumControlTypeID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ModifiedDate">
          <DataField>ModifiedDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="ModifiedBy">
          <DataField>ModifiedBy</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ContributionDetail">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ContributionID">
            <Value>=Parameters!ContributionID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--declare @CurrentUser varchar(50) ='bmaly@catholiccincinnati.org'
--declare @churchid int = 2
--declare @datefrom date = '2020/10/01'
--declare @dateto date ='2020/10/30'
--declare @KeyValue varchar(5) = 'ACK'

----select distinct  
----case when c.comment like '%{%}%' then SUBSTRING(c.comment,CHARINDEX('{',c.comment)+1,(CHARINDEX('}',c.comment)-CHARINDEX('{',c.comment))-1)
----	else '' end
----	FROM xrpt.FundContributions_vw c 
----   WHERE c.ContributionDate &gt;= @DateFrom AND c.contributiondate &lt;= @DateTo
----   and c.Comment like '%{%}%' 
----	and c.ChurchID = @ChurchID
--declare @ContributionID table (id int)
--insert into @ContributionID
--select distinct 
--	c.ContributionID
----	,c.LastName
----,c.lastName+'('+FORMAT(c.GrossAmount, 'C', 'en-us')+')' Items
----	,c.BudgetNumber
----	,c.ContributionDate
----	,c.GrossAmount
----	,c.comment
----	,c.Reference
--FROM xrpt.FundContributions_vw c 
--   WHERE c.ContributionDate &gt;= @DateFrom AND c.contributiondate &lt;= @DateTo
--   and c.Comment like '%{'+@KeyValue+'}%'
--	and c.ChurchID = @ChurchID


select distinct
	replace(cv.ChurchName ,'Parish','') +case when c.FundDescription like '%school%' or c.FundDescription like '%scholarship%' then ' School' else ' Parish' end ChurchName
	,f.FamilyID
	,f.LastFirst +' ('+f.BudgetNumber+')-'  [Name]
,f.FirstName
	,ml.MailName
	,ml.Salutation
	,ml.Addr1
	,ml.Addr2
	,ml.City
	,ml.State
	,ml.ZipCode
	,FundDescription = case when c.FundDescription like '%{%}%' 
		then replace(c.FundDescription,'{'+isnull(SUBSTRING(c.FundDescription,CHARINDEX('{',c.FundDescription)+1,(CHARINDEX('}',c.FundDescription)-CHARINDEX('{',c.FundDescription))-1),c.FundDescription)+'}','') 
		else c.FundDescription end
,c.nondeductible
,c.Reference
	,c.GrossAmount
	,c.ContributionDate
	,Comment = case when c.nondeductible = 1 then 'Non-Deductible - ' else '' end
+case when c.Comment like '%{%}%' then
isnull(replace(c.Comment,'{'+isnull(SUBSTRING(c.Comment,CHARINDEX('{',c.Comment)+1,(CHARINDEX('}',c.Comment)-CHARINDEX('{',c.Comment))-1),c.Comment)+'}','') ,'')
else c.comment end

--	,Contributionts= stuff((select '~Fund ' + 
--convert(char(24),case when c.FundDescription like '%{%}%' 
--then replace(c.FundDescription,'{'+isnull(SUBSTRING(c.FundDescription,CHARINDEX('{',c.FundDescription)+1,(CHARINDEX('}',c.FundDescription)-CHARINDEX('{',c.FundDescription))-1),c.FundDescription)+'}','') 
--else c.FundDescription end) + 
--right('          '+convert(varchar(12),FORMAT(c.GrossAmount, 'C', 'en-us')),12) + '  ' + convert(char(11),c.contributiondate,101) 
--+replace(c.Comment,'{'+isnull(SUBSTRING(c.Comment,CHARINDEX('{',c.Comment)+1,(CHARINDEX('}',c.Comment)-CHARINDEX('{',c.Comment))-1),c.Comment)+'}','') 
--from xrpt.FundContributions_vw c 
--where c.FamilyID=f.FamilyID
--	and c.ChurchID = f.ChurchID
--	and c.ChurchID = @ChurchID
--	and c.ContributionID in (@ContributionID)--(select id from @ContributionID)
--for xml path ('')), 1, 1, '')
FROM xrpt.families_vw f
	left join xrpt.Churches_vw cv
		on cv.ChurchID = f.churchid 
	left join xrpt.FundContributions_vw c 
		on f.familyID = c.familyID 
		and f.churchID = c.ChurchID
	left join xrpt.MailingLabels_vw ml
		on ml.FamilyID=f.FamilyID
   WHERE ContributionID in (@ContributionID)--(select id from @ContributionID)
   and f.ChurchID = @ChurchID</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FamilyID">
          <DataField>FamilyID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Name">
          <DataField>Name</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FirstName">
          <DataField>FirstName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="MailName">
          <DataField>MailName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Salutation">
          <DataField>Salutation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr1">
          <DataField>Addr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr2">
          <DataField>Addr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="City">
          <DataField>City</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="State">
          <DataField>State</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ZipCode">
          <DataField>ZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FundDescription">
          <DataField>FundDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="nondeductible">
          <DataField>nondeductible</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="Reference">
          <DataField>Reference</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="GrossAmount">
          <DataField>GrossAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="contributiondate">
          <DataField>ContributionDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="Comment">
          <DataField>Comment</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix2">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>2.8125in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>1.0312in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Rectangle Name="Rectangle1">
                          <ReportItems>
                            <Textbox Name="Textbox4">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=chr(10) &amp; Fields!MailName.Value 
&amp; chr(10) &amp; strconv(Fields!Addr1.Value,3) 
&amp; chr(32) &amp; IIF(IsNothing(Fields!Addr2.Value),chr(10),chr(32) &amp; chr(32) &amp; strconv(Fields!Addr2.Value,3) &amp; chr(10)) 
&amp; strconv(Fields!City.Value,3) &amp; chr(44) &amp; chr(32) &amp; Fields!State.Value &amp; chr(32) &amp; Fields!ZipCode.Value</Value>
                                      <Style />
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Left</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>Textbox4</rd:DefaultName>
                              <Height>1.0312in</Height>
                              <Width>2.8125in</Width>
                              <DataElementName>ContributionDetail</DataElementName>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <VerticalAlign>Middle</VerticalAlign>
                                <PaddingLeft>15pt</PaddingLeft>
                                <PaddingRight>15pt</PaddingRight>
                              </Style>
                            </Textbox>
                          </ReportItems>
                          <KeepTogether>true</KeepTogether>
                          <Style>
                            <Border>
                              <Style>None</Style>
                            </Border>
                          </Style>
                        </Rectangle>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <Group Name="Details" />
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>ContributionDetail</DataSetName>
            <Height>1.0312in</Height>
            <Width>2.8125in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>1.0312in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>2.8125in</Width>
      <Page>
        <TopMargin>0.1875in</TopMargin>
        <Columns>3</Columns>
        <ColumnSpacing>0.02135in</ColumnSpacing>
        <Style />
      </Page>
    </ReportSection>
  </ReportSections>
  <ReportParameters>
    <ReportParameter Name="CurrentUser">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>=User!UserID</Value>
        </Values>
      </DefaultValue>
      <Prompt>Current User</Prompt>
      <Hidden>true</Hidden>
    </ReportParameter>
    <ReportParameter Name="ChurchID">
      <DataType>Integer</DataType>
      <Prompt>Select Church</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="DateFrom">
      <DataType>DateTime</DataType>
      <Prompt>Begin Date</Prompt>
    </ReportParameter>
    <ReportParameter Name="DateTo">
      <DataType>DateTime</DataType>
      <Prompt>End Date</Prompt>
    </ReportParameter>
    <ReportParameter Name="Amount">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>250</Value>
        </Values>
      </DefaultValue>
      <Prompt>Amount</Prompt>
    </ReportParameter>
    <ReportParameter Name="ContributionID">
      <DataType>String</DataType>
      <Prompt>Select contribution to Acknowledge</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Contributions</DataSetName>
          <ValueField>ContributionID</ValueField>
          <LabelField>Items</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>3</NumberOfColumns>
      <NumberOfRows>5</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>CurrentUser</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ChurchID</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>DateFrom</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>DateTo</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Amount</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>ContributionID</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>8f51e90d-03ad-4d71-a959-99ce486f8559</rd:ReportID>
</Report>