﻿<?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>19cfdc99-0b7e-4147-9ab0-8effd5682b7b</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>SELECT
  Churches_vw.ChurchID
  ,Churches_vw.ChurchName +' , '+ Churches_vw.City  ChurchName
FROM
  xrpt.Churches_vw AS Churches_vw
order by Churches_vw.ChurchName +' , '+ Churches_vw.City</CommandText>
      </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="MyStatuses">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT distinct 
 StatusCode
FROM xrpt.Families_vw 
where Churchid = @ChurchID
union all
select ' All Statuses')tst
order by StatusCode</CommandText>
      </Query>
      <Fields>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MyFunds">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@YYYY">
            <Value>=Parameters!YYYY.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Buckets">
            <Value>=Parameters!Buckets.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>
--declare @churchid int = 2
--declare @datefrom date = '2020/01/01'
--declare @dateto date ='2020/12/31'
--declare @bucket int = 0
--declare @YYYY int = 2020

declare @DateFrom date = convert(date,'01/01/'+convert(char(4),@YYYY))
declare @DateTo date = convert(date,'12/31/'+convert(char(4),@YYYY))

Select * from 
(SELECT distinct c.[FundID]
     ,c.[FundDescription]
  FROM [xrpt].[FundContributions_vw] c
where c.ChurchID =@ChurchID
		and (0 in (@Buckets)
			or exists (
			select 1
			from xrpt.funds_vw fd 
			where fd.ChurchID = c.ChurchID
			and fd.FundID = c.FundID
			and isnull(fd.AnnualContributionBucket,1) in (@Buckets)
			)
		)
	and ContributionDate &gt;= @DateFrom and ContributionDate &lt;= @DateTo
union all 
select 0, ' All Funds' ) tst
order by FundDescription</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="FundID">
          <DataField>FundID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FundDescription">
          <DataField>FundDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MyFamilies">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@YYYY">
            <Value>=Parameters!YYYY.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CurrentUser">
            <Value>=Parameters!CurrentUser.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitLow">
            <Value>=Parameters!LimitLow.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Funds">
            <Value>=Parameters!Funds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitHi">
            <Value>=Parameters!LimitHi.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Buckets">
            <Value>=Parameters!Buckets.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>declare @DateFrom date = convert(date,'01/01/'+convert(char(4),@YYYY))
declare @DateTo date = dateadd(dd,1,convert(date,'12/31/'+convert(char(4),@YYYY)))

select * from 
(select f.FamilyID, f.LastName+', '+isnull(f.FirstName,'')+' ('+convert(varchar(8),isnull(f.BudgetNumber,0))+')' LastFirst
from xrpt.families_vw f
where f.ChurchID= @ChurchID
and exists (select 1 from 
	xrpt.ChurchUsers_vw cu 
	where f.ChurchID = cu.ChurchID 
	and cu.UserName=@CurrentUser 
	and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))
and (' All Statuses' in (@Statuses) 
	or f.StatusCode in (@Statuses))
and (
((@LimitLow &gt;=0  and @LimitHi &gt;0) and 
exists (select 1 from xrpt.FundContributions_vw fc 
	where f.familyid=fc.familyid 
	and f.ChurchID=fc.ChurchID
	and fc.ContributionDate &gt;= @DateFrom and fc.ContributionDate &lt; @DateTo
	and (( 0 in (@Funds) and 0 in (@Buckets))
	or (0 in (@Funds) 
		and exists (select 1 from xrpt.funds_vw fd 
		where fd.FundID = fc.FundID
		and isnull(fd.AnnualContributionBucket,4) in (@Buckets)) )
	or fc.fundid in (@Funds))
	Group by fc.FamilyID
	having Sum(fc.GrossAmount) &gt;= @LimitLow and sum(fc.grossamount) &lt; @LimitHi ))

or ((@LimitLow =0 and @LimitHi =0) and 
not exists (select 1 from xrpt.FundContributions_vw fc 
	where f.familyid=fc.familyid 
	and f.ChurchID=fc.ChurchID
	and fc.ContributionDate &gt;= @DateFrom and fc.ContributionDate &lt; @DateTo
	and (( 0 in (@Funds) and 0 in (@Buckets))
	or (0 in (@Funds) 
		and exists (select 1 from xrpt.funds_vw fd 
		where fd.FundID = fc.FundID
		and isnull(fd.AnnualContributionBucket,4) in (@Buckets)) )
	or fc.fundid in (@Funds))
	Group by fc.FamilyID)))
union all
select 0, ' All Families' ) txt
order by LastFirst</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="FamilyID">
          <DataField>FamilyID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="LastFirst">
          <DataField>LastFirst</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="cDetails">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@YYYY">
            <Value>=Parameters!YYYY.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CurrentUser">
            <Value>=Parameters!CurrentUser.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Funds">
            <Value>=Parameters!Funds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Buckets">
            <Value>=Parameters!Buckets.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitLow">
            <Value>=Parameters!LimitLow.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Address">
            <Value>=Parameters!Address.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitHi">
            <Value>=Parameters!LimitHi.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Families">
            <Value>=Parameters!Families.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--Created for the Archdiocese of Cincinnati 
--bmaly@catholicaoc.org
--Create Date 2021.10.14


declare @DateFrom date = convert(date,'01/01/'+convert(char(4),@YYYY))
declare @DateTo date = dateadd(dd,1,convert(date,'12/31/'+convert(char(4),@YYYY)))

declare @fam table (FamID int)
insert into @fam

select f.FamilyID
from xrpt.families_vw f
where f.ChurchID= @ChurchID
and exists (select 1 from 
	xrpt.ChurchUsers_vw cu 
	where f.ChurchID = cu.ChurchID 
	and cu.UserName=@CurrentUser 
	and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))
and (' All Statuses' in (@Statuses) 
	or f.StatusCode in (@Statuses))
and (
((@LimitLow &gt;=0  and @LimitHi &gt;0) and 
exists (select 1 from xrpt.FundContributions_vw fc 
	where f.familyid=fc.familyid 
	and f.ChurchID=fc.ChurchID
	and fc.ContributionDate &gt;= @DateFrom and fc.ContributionDate &lt; @DateTo
	and (( 0 in (@Funds) and 0 in (@Buckets))
	or (0 in (@Funds) 
		and exists (select 1 from xrpt.funds_vw fd 
		where fd.FundID = fc.FundID
		and isnull(fd.AnnualContributionBucket,4) in (@Buckets)) )
	or fc.fundid in (@Funds))
	Group by fc.FamilyID
	having Sum(fc.GrossAmount) &gt;= @LimitLow and sum(fc.grossamount) &lt; @LimitHi ))

or ((@LimitLow =0 and @LimitHi =0) and 
not exists (select 1 from xrpt.FundContributions_vw fc 
	where f.familyid=fc.familyid 
	and f.ChurchID=fc.ChurchID
	and fc.ContributionDate &gt;= @DateFrom and fc.ContributionDate &lt; @DateTo
	and (( 0 in (@Funds) and 0 in (@Buckets))
	or (0 in (@Funds) 
		and exists (select 1 from xrpt.funds_vw fd 
		where fd.FundID = fc.FundID
		and isnull(fd.AnnualContributionBucket,4) in (@Buckets)) )
	or fc.fundid in (@Funds))
	Group by fc.FamilyID)))

select  f.familyid
,convert(varchar(8),isnull(f.BudgetNumber,0)) BudgetNumber
 ,F.HasEnvelopes
,f.BudgetNumberInactive
,f.IsRegistered
  , isnull(f.Salutation,'')  Salutation
,isnull(f.MailName,'') MailName
,isnull(f.FirstName,'') FirstName
  ,f.LastName
  ,case when @Address = 0 then ml.Addr1 else  f.Addr1 end Addr1
  ,isnull(case when @Address = 0 then ml.Addr2 else  f.Addr2 end, '') Addr2
  ,case when @Address = 0 then ml.City else  f.City end City
  ,case when @Address = 0 then ml.[State] else  f.[State] end [State]
  ,case when @Address = 0 then ml.ZipCode else  f.ZipCode end ZipCode
  ,isnull(F.EmailAddress,'') EmailAddress
  ,isnull(F.EmailAlerts ,0) EmailAlerts

  ,F.StatusCode

FROM xrpt.families_vw f
join @fam fx 
	on fx.famid=f.FamilyID
join xrpt.MailingLabels_vw ml 
	on f.familyID=ml.familyID
where f.ChurchID = @ChurchID 
and (0 in (@Families) or f.FamilyID in (@Families))</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="FamilyID">
          <DataField>familyid</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="HasEnvelopes">
          <DataField>HasEnvelopes</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="BudgetNumberInactive">
          <DataField>BudgetNumberInactive</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="IsRegistered">
          <DataField>IsRegistered</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BudgetNumber">
          <DataField>BudgetNumber</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="StatusCode">
          <DataField>StatusCode</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="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</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="salutation">
          <DataField>Salutation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="MailName">
          <DataField>MailName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="emailAlerts">
          <DataField>EmailAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MyBuckets">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>select 0 bid, 'All Buckets' Bucket
union all
select 1, 'Bucket 1'
union all
select 2, 'Bucket 2'
union all
select 0, 'Bucket 3'</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="bid">
          <DataField>bid</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Bucket">
          <DataField>Bucket</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="CurrYear">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>Select Year=year(getdate())
union all
Select Year=year(getdate())-1
union all
Select Year=year(getdate())-2
union all
Select Year=year(getdate())-3</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="Year">
          <DataField>Year</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix2">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>2.5935in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>1in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Rectangle Name="Rectangle2">
                          <ReportItems>
                            <Textbox Name="Textbox1">
                              <CanGrow>true</CanGrow>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=chr(10) &amp; 
iif(Parameters!AddressCase.Value=1 , strconv(IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10))  
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value,1) , 

iif(Parameters!AddressCase.Value=2 , strconv(IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10)) 
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value,3) , 

IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10)) 
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value ))</Value>
                                      <Style />
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Height>1in</Height>
                              <Width>2.5935in</Width>
                              <DataElementName>cDetails</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">
                    <GroupExpressions>
                      <GroupExpression>=Fields!FamilyID.Value</GroupExpression>
                    </GroupExpressions>
                  </Group>
                  <SortExpressions>
                    <SortExpression>
                      <Value>=iif(Parameters!Sort.Value=0,Fields!LastName.Value,Fields!ZipCode.Value+Fields!LastName.Value)</Value>
                    </SortExpression>
                  </SortExpressions>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>cDetails</DataSetName>
            <Height>1in</Height>
            <Width>2.5935in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>1in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>2.5935in</Width>
      <Page>
        <LeftMargin>0.21975in</LeftMargin>
        <RightMargin>0.21975in</RightMargin>
        <TopMargin>0.5in</TopMargin>
        <BottomMargin>0.5in</BottomMargin>
        <Columns>3</Columns>
        <ColumnSpacing>0.14in</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>Parish</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Statuses">
      <DataType>String</DataType>
      <Prompt>Select Family Statuses</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyStatuses</DataSetName>
          <ValueField>StatusCode</ValueField>
          <LabelField>StatusCode</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="YYYY">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>=Year(Now())-1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Calendar Year</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>CurrYear</DataSetName>
          <ValueField>Year</ValueField>
          <LabelField>Year</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="DateFrom">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=DateValue("1/1/" &amp; Parameters!YYYY.Value)</Value>
        </Values>
      </DefaultValue>
      <Prompt>Start Date</Prompt>
      <Hidden>true</Hidden>
    </ReportParameter>
    <ReportParameter Name="DateTo">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=DateValue("12/31/" &amp; Parameters!YYYY.Value)</Value>
        </Values>
      </DefaultValue>
      <Prompt>Through</Prompt>
      <Hidden>true</Hidden>
    </ReportParameter>
    <ReportParameter Name="Buckets">
      <DataType>Integer</DataType>
      <Prompt>Select Buckets</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>All Buckets</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Bucket 1</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Bucket 2</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>3</Value>
            <Label>Bucket 3</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Funds">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Funds</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyFunds</DataSetName>
          <ValueField>FundID</ValueField>
          <LabelField>FundDescription</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="LimitLow">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>250</Value>
        </Values>
      </DefaultValue>
      <Prompt>Limit Low</Prompt>
    </ReportParameter>
    <ReportParameter Name="LimitHi">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>300</Value>
        </Values>
      </DefaultValue>
      <Prompt>Limit Hi</Prompt>
    </ReportParameter>
    <ReportParameter Name="Families">
      <DataType>Integer</DataType>
      <Prompt>Select Families</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyFamilies</DataSetName>
          <ValueField>FamilyID</ValueField>
          <LabelField>LastFirst</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Address">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Address to use</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Mailing Address</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Street Address</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="AddressCase">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Address Format</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Current Data Format</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Upper Case (USPS)</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Proper Case (mixed)</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Sort">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>select Sort Order</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Last Name</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Zip Code / Last Name</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>4</NumberOfColumns>
      <NumberOfRows>6</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>Statuses</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>YYYY</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>DateFrom</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>DateTo</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Buckets</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Funds</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>LimitLow</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>LimitHi</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Families</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Address</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>AddressCase</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>Sort</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>2e539e49-5773-48c0-a413-040c8d4c8d1b</rd:ReportID>
</Report>