﻿<?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>c5ba2cd7-0b75-42c4-bb59-9c110d202be0</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>declare @X int =0
declare @cnt int 
Select @cnt=count(ChurchID) from xrpt.Churches_vw
declare @c table (ChurchID int, ChurchName varchar(200))
while @cnt = 1 and @x=0
begin 
insert into @c
SELECT ChurchID ,ChurchName + ' - ' +City ChurchName
FROM xrpt.Churches_vw 
set @x =1
end
while @cnt &gt;1 and @x=0
begin 
insert into @c
select * from 
(SELECT ChurchID,ChurchName + ' - ' +City ChurchName
FROM xrpt.Churches_vw 
union all
select 0,' Select Church') x
set @x =1
end
Select * from @c
order by ChurchName</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="Statuses">
      <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
and statuscode is not null
and statuscode &lt;&gt;'deleted'
union all
select ' All Statuses') TEST
order by StatusCode</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Forms">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select distinct replace(MemberLastFirst,'AnnualTax, ','') LetterForm
from xrpt.FamilyNotes_vw fn
where MemberLastFirst like 'AnnualTax, %'
and exists ( select 1 from xrpt.Families_vw f
where f.familyid=fn.familyid
and ChurchID  = @ChurchID
and FamilyLastFirst = 'ADMIN')
and exists (select 1 from xrpt.members_vw m
where m.familyid=fn.familyid and m.statuscode='Active')</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="LetterForm">
          <DataField>LetterForm</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
union all
Select Year=year(getdate())-4</CommandText>
      </Query>
      <Fields>
        <Field Name="Year">
          <DataField>Year</DataField>
          <rd:TypeName>System.Int32</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 @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 distinct c.[FundID]
     ,c.[FundDescription]
into #TMP
  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

select FundID=0
,[FundDescription] = ' All Funds' 
into #TMP1

Select * from (
Select * from #TMP
union all
Select * from #TMP1) x
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="@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="@CurrentUser">
            <Value>=Parameters!CurrentUser.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitHi">
            <Value>=Parameters!LimitHi.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.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)))

declare @Fam table (FamilyID int,LastFirst varchar(100)) 
declare @exit int =1

While @LimitLow &gt;= 0 and @LimitHi &gt; 0 and @exit = 1 begin
insert into @Fam
select distinct fc.FamilyID
, f.LastName+', '+isnull(f.FirstName,'')+' ('+convert(varchar(8),isnull(f.BudgetNumber,0))+')'
from xrpt.FundContributions_vw fc 
	join xrpt.Families_vw f on f.FamilyID= fc.FamilyID
	where fc.ChurchID =@ChurchID
	and fc.ChurchID=f.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 StatusCode in (@Statuses))
	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,1) in (@Buckets))
		) 
		)
	or fc.fundid in (@Funds))
	Group by fc.FamilyID, f.LastName+', '+isnull(f.FirstName,'')+' ('+convert(varchar(8),isnull(f.BudgetNumber,0))+')'
	having Sum(fc.GrossAmount) &gt;= @LimitLow and sum(fc.grossamount) &lt; @LimitHi 
Set @exit =0
end

While @LimitLow = 0 and @LimitHi = 0 and @exit = 1 begin
insert into @Fam
select distinct f.FamilyID
, f.LastName+', '+isnull(f.FirstName,'')+' ('+convert(varchar(8),isnull(f.BudgetNumber,0))+')'
	from xrpt.families_vw f
	where f.ChurchID= @ChurchID
	and (' All Statuses' in (@Statuses) 
		or f.StatusCode in (@Statuses))
	and not exists (select fc.FamilyID from xrpt.FundContributions_vw fc 
	where fc.ChurchID =@ChurchID
	and fc.FamilyID = f.FamilyID
	and fc.ChurchID=f.ChurchID
	--and exists (select fc.FamlyID from 
	--	xrpt.ChurchUsers_vw cu 
	--	where f.ChurchID = cu.ChurchID 
	--	and cu.UserName=@CurrentUser 
	--	and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))
	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,1) in (@Buckets))
		) 
		)
	or fc.fundid in (@Funds))
	Group by fc.FamilyID
	having Sum(fc.GrossAmount) &gt; 0)
Set @exit =0
end

insert into @Fam
	select 0, ' All Families' 

Select * from @Fam 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="Details">
      <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="@Funds">
            <Value>=Parameters!Funds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Address">
            <Value>=Parameters!Address.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Buckets">
            <Value>=Parameters!Buckets.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitLow">
            <Value>=Parameters!LimitLow.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@LimitHi">
            <Value>=Parameters!LimitHi.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FForm">
            <Value>=Parameters!FForm.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.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 @ATTR int = 0 --1 selects the AOC attributes and 0 selects parish
declare @Patts table (FundID int, AttributeSelected varchar(200),AttributeSORT  varchar(200))
insert into @Patts
Select FundID
,AttributeSelected = case when @ATTR=1 then ( isnull(STUFF((SELECT top 1 ', ' + isnull(fa.AttributeValue ,'')
	FROM xrpt.FundAttributes_vw fa
	WHERE  f.FundID=fa.FundID
	and f.churchid= fa.churchid 
	and fa.systemID='Gabriel' and fa.AttributeName = 'AOC'
	FOR XML PATH ('')), 1, 1, '') ,''))
	else ( isnull(STUFF((SELECT top 1 ', ' + isnull(fa.AttributeValue ,'')
	FROM xrpt.FundAttributes_vw fa
	WHERE  f.FundID=fa.FundID
	and f.churchid= fa.churchid 
	and fa.systemID='Gabriel' and fa.AttributeName = 'Parish'
	FOR XML PATH ('')), 1, 1, '') ,
	( isnull(STUFF((SELECT top 1 ', ' + isnull(fa.AttributeValue ,'')
	FROM xrpt.FundAttributes_vw fa
	WHERE  f.FundID=fa.FundID
	and f.churchid= fa.churchid 
	and fa.systemID='Gabriel' and fa.AttributeName = 'AOC'
	FOR XML PATH ('')), 1, 1, '') ,''))
	)) end,
AttributeSORT = ( isnull(STUFF((SELECT top 1 ', ' + isnull(fa.AttributeValue ,'')
	FROM xrpt.FundAttributes_vw fa
	WHERE  f.FundID=fa.FundID
	and f.churchid= fa.churchid 
	and fa.systemID='Gabriel' and fa.AttributeName = 'SORT'
	FOR XML PATH ('')), 1, 1, '') ,''))
from xrpt.Funds_vw f
	where ChurchID=@ChurchID



Declare @ChurchData Table
(ChurchID int
,Logo  nvarchar(200)
,LogoOrientation nvarchar(200)
,LetterTextP1 nvarchar(2000)
,LetterTextP2 nvarchar(2000)
,LetterSign nvarchar(2000)
,LetterSignURL nvarchar(200)
,ChurchName nvarchar(200)
,ChurchCity nvarchar(200)
,CAddr1 nvarchar(200)
,CAddr2 nvarchar(200)
,CCity nvarchar(200)
,CState nvarchar(200)
,CZipCode nvarchar(200)
,CphoneNumber  nvarchar(200))
insert into @ChurchData
SELECT CV.ChurchID
,Logo=isnull((select top 1 replace(note,'LogoURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'LogoURL:%'),(select top 1 replace(note,'LogoURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.FamilyLastFirst = 'ADMIN'
	and memberid is null
	and note like 'LogoURL:%'))
,LogoOrientation=isnull((select top 1 replace(note,'LogoOrientation:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'Logo:%'),(select top 1 replace(note,'LogoOrientation:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.FamilyLastFirst = 'ADMIN'
	and memberid is null
	and note like 'LogoOrientation:%'))
,LetterTextP1=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace((select top 1 replace(note,'TextP1:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'TextP1:%'),char(13),'&lt;br&gt;'),'/','&lt;br&gt;'),'~I','&lt;i&gt;'),'!I','&lt;/i&gt;'),'~B','&lt;b&gt;'),'!B','&lt;/b&gt;'),'~U','&lt;u&gt;'),'!U','&lt;/u&gt;'),'~C','&lt;p style="text-align:center"&gt;'),'!C','&lt;/p&gt;')
,LetterTextP2=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace((select top 1 replace(note,'TextP2:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'TextP2:%'),char(13),'&lt;br&gt;'),'/','&lt;br&gt;'),'~I','&lt;i&gt;'),'!I','&lt;/i&gt;'),'~B','&lt;b&gt;'),'!B','&lt;/b&gt;'),'~U','&lt;u&gt;'),'!U','&lt;/u&gt;'),'~C','&lt;p style="text-align:center"&gt;'),'!C','&lt;/p&gt;')
,LetterSign=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace((select top 1 replace(note,'SIGN:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'Sign:%'),char(13),'&lt;br&gt;'),'/','&lt;br&gt;'),'~I','&lt;i&gt;'),'!I','&lt;/i&gt;'),'~B','&lt;b&gt;'),'!B','&lt;/b&gt;'),'~U','&lt;u&gt;'),'!U','&lt;/u&gt;'),'~C','&lt;p style="text-align:center"&gt;'),'!C','&lt;/p&gt;')
,LetterSignURL=(select top 1 replace(note,'SIGNURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'SignURL:%')
,replace(CV.ChurchName,' Parish','')  ChurchName
,CV.ChurchName +' , '+ CV.City  ChurchCity
,CV.Addr1 CAddr1
,isnull(CV.Addr2,'') CAddr2
,CV.City CCity
,CV.State CState
,CV.ZipCode CZipCode
,CV.PhoneNumber CPhoneNumber
from xrpt.churches_vw CV where Churchid = @ChurchID

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 (FamilyID int) 
declare @exit int =1

While @LimitLow &gt;= 0 and @LimitHi &gt; 0 and @exit = 1 begin
insert into @Fam
select distinct fc.FamilyID
from xrpt.FundContributions_vw fc 
	join xrpt.Families_vw f on f.FamilyID= fc.FamilyID
	where fc.ChurchID =@ChurchID
	and fc.ChurchID=f.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 StatusCode in (@Statuses))
	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,1) in (@Buckets))
		) 
		)
	or fc.fundid in (@Funds))
	Group by fc.FamilyID, f.LastName+', '+isnull(f.FirstName,'')+' ('+convert(varchar(8),isnull(f.BudgetNumber,0))+')'
	having Sum(fc.GrossAmount) &gt;= @LimitLow and sum(fc.grossamount) &lt; @LimitHi 
Set @exit =0
end

While @LimitLow = 0 and @LimitHi = 0 and @exit = 1 begin
insert into @Fam
select distinct f.FamilyID
	from xrpt.families_vw f
	where f.ChurchID= @ChurchID
	and (' All Statuses' in (@Statuses) 
		or f.StatusCode in (@Statuses))
	and not exists (select fc.FamilyID from xrpt.FundContributions_vw fc 
	where fc.ChurchID =@ChurchID
	and fc.FamilyID = f.FamilyID
	and fc.ChurchID=f.ChurchID
	--and exists (select fc.FamlyID from 
	--	xrpt.ChurchUsers_vw cu 
	--	where f.ChurchID = cu.ChurchID 
	--	and cu.UserName=@CurrentUser 
	--	and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))
	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,1) in (@Buckets))
		) 
		)
	or fc.fundid in (@Funds))
	Group by fc.FamilyID
	having Sum(fc.GrossAmount) &gt; 0)
Set @exit =0
end

select FData.*,CV.* from (
select  f.familyid
,convert(varchar(8),isnull(f.BudgetNumber,0)) BudgetNumber
-- ,convert(int,case when replace(f.budgetnumber,' ','') like  '%[a-z]%' then 0 else replace(f.budgetnumber,' ','') end) BudgetNumber
 ,F.HasEnvelopes
,f.BudgetNumberInactive
,convert(varchar(12),f.registrationdate ,101) RegistrationDate

,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
,GiveTuesday=(select max(1) from xrpt.fundcontributions_vw fct
		where fct.FamilyID= fc.FamilyID
		and fct.FundDescription like '%Tuesday%'
		and fct.ContributionDate &gt;= @DateFrom and fct.ContributionDate &lt; @DateTo)
	,fc.FundID
	,FundDescription = case when fc.FundDescription like '%{%}%' 
	then replace(fc.FundDescription,'{'+isnull(SUBSTRING(fc.FundDescription,CHARINDEX('{',fc.FundDescription)+1,(CHARINDEX('}',fc.FundDescription)-CHARINDEX('{',fc.FundDescription))-1),fc.FundDescription)+'}','') 
	else fc.FundDescription end
	,fa.AttributeSelected
	,fa.AttributeSORT
	,fc.BatchDescription
	,fc.ContributionDate
	,fc.EnteredBy
	,fc.EnteredDate
	,fc.Reference
	,fc.BatchID
	,isnull(fd.[AnnualContributionBucket],0) [AnnualContributionBucket]
	,Comment = case when fc.comment like '%{%}%' then 
		replace(fc.Comment,'{'+isnull(SUBSTRING(fc.Comment,CHARINDEX('{',fc.Comment)+1,(CHARINDEX('}',fc.Comment)-CHARINDEX('{',fc.Comment))-1),fc.Comment)+'}','') 
		else fc.Comment end
	,fc.NonDeductible
	,Deductible = Case when isnull(fc.NonDeductible,0) = 1 
		or isnull(fd.[AnnualContributionBucket],'1') = 2 then 0 else 1 end
	,fc.GrossAmount
	,GrossAmountDed =Case when isnull(fc.NonDeductible,0) = 1 
		or isnull(fd.[AnnualContributionBucket],'1') = 2 then 0 else fc.GrossAmount end
	,fc.NetAmount
	,NetAmountDed =Case when isnull(fc.NonDeductible,0) = 1 
		or isnull(fd.[AnnualContributionBucket],'1') = 2 then 0 else fc.NetAmount end
	,GrossAmountNonDed =Case when isnull(fc.NonDeductible,0) = 1 
		or isnull(fd.[AnnualContributionBucket],'1') = 2 then fc.GrossAmount else 0 end
	,NetAmountNonDed =Case when isnull(fc.NonDeductible,0) = 1 
		or isnull(fd.[AnnualContributionBucket],'1') = 2 then fc.NetAmount else 0 end
FROM xrpt.families_vw f
join @Fam fx 
	on fx.FamilyID=f.FamilyID
join xrpt.MailingLabels_vw ml 
	on f.familyID=ml.familyID
left join xrpt.FundContributions_vw fc 
	on fc.ChurchID=f.ChurchID
	and fc.FamilyID=f.FamilyID 
	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,1) in (@Buckets)
		) )
	or fc.fundid in (@Funds))

left join @Patts fa on fa.FundID=fc.FundID
left join xrpt.funds_vw fd 
	on fd.churchid=fc.churchid
	and fd.fundid=fc.fundid
where f.ChurchID = @ChurchID 
and (0 in (@Families) or f.FamilyID in (@Families))
) FDATA
cross join @ChurchData CV</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Logo">
          <DataField>Logo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LogoOrientation">
          <DataField>LogoOrientation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterTextP1">
          <DataField>LetterTextP1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterSign">
          <DataField>LetterSign</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterTextP2">
          <DataField>LetterTextP2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterSignURL">
          <DataField>LetterSignURL</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ChurchCity">
          <DataField>ChurchCity</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CAddr1">
          <DataField>CAddr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CAddr2">
          <DataField>CAddr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CCity">
          <DataField>CCity</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CZipCode">
          <DataField>CZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CPhoneNumber">
          <DataField>CphoneNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="familyid">
          <DataField>familyid</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="BudgetNumber">
          <DataField>BudgetNumber</DataField>
          <rd:TypeName>System.String</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="RegistrationDate">
          <DataField>RegistrationDate</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="IsRegistered">
          <DataField>IsRegistered</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="AttributeSelected">
          <DataField>AttributeSelected</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AttributeSORT">
          <DataField>AttributeSORT</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FirstName">
          <DataField>FirstName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LastName">
          <DataField>LastName</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="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAlerts">
          <DataField>EmailAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="GiveTuesday">
          <DataField>GiveTuesday</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <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>
        <Field Name="BatchDescription">
          <DataField>BatchDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ContributionDate">
          <DataField>ContributionDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="EnteredBy">
          <DataField>EnteredBy</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EnteredDate">
          <DataField>EnteredDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="Reference">
          <DataField>Reference</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BatchID">
          <DataField>BatchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="AnnualContributionBucket">
          <DataField>AnnualContributionBucket</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Comment">
          <DataField>Comment</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="NonDeductible">
          <DataField>NonDeductible</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="Deductible">
          <DataField>Deductible</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="GrossAmount">
          <DataField>GrossAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="GrossAmountDed">
          <DataField>GrossAmountDed</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="NetAmount">
          <DataField>NetAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="NetAmountDed">
          <DataField>NetAmountDed</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="CState">
          <DataField>CState</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="GrossAmountNonDed">
          <DataField>GrossAmountNonDed</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="NetAmountNonDed">
          <DataField>NetAmountNonDed</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="HIGH">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@FForm">
            <Value>=Parameters!FForm.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>select distinct * from (
SELECT top 1 [order]=1
,[AMT]=isnull((select top 1 replace(note,'HIGH:','')  from xrpt.FamilyNotes_vw fn
	where fn.ChurchID =f.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'HIGH:%'),500)
from xrpt.Families_vw f where Churchid = @ChurchID 
and f.LastName = 'ADMIN'
and f.statuscode&lt;&gt;'DELETED'
and f.StatusCode ='STAFF'
union all
Select 2,0
union all
Select 3,1
union all
Select 4,75
union all
Select 5,250
union all
Select 6,500
union all
Select 7,1000
union all
Select 8,10000
union all
Select 9,100000
union all
Select 10,1000000 ) x
order by [order] ASC
</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="order">
          <DataField>order</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="AMT">
          <DataField>AMT</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="LOW">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@FForm">
            <Value>=Parameters!FForm.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--Declare @ChurchID int = 166
--Declare @FForm varchar(10) ='Letter'
select distinct * from (
SELECT top 1 [order]=1
,[AMT]=isnull((select top 1 replace(note,'LOW:','')  from xrpt.FamilyNotes_vw fn
	where fn.ChurchID =f.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'AnnualTax, '+@FForm
	and note like 'LOW:%'),250)
from xrpt.Families_vw f where Churchid = @ChurchID 
and f.LastName = 'ADMIN'
and f.statuscode&lt;&gt;'DELETED'
and f.StatusCode ='STAFF'
union all
Select 2,0
union all
Select 3,1
union all
Select 4,75
union all
Select 5,250
union all
Select 6,500
union all
Select 7,1000
union all
Select 8,10000
union all
Select 9,100000
union all
Select 10,1000000 ) x
order by [order] ASC
</CommandText>
      </Query>
      <Fields>
        <Field Name="order">
          <DataField>order</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="AMT">
          <DataField>AMT</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix3">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>7.5in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>8.08977in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Rectangle Name="RepeatingValue">
                          <ReportItems>
                            <Textbox Name="Letter">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>="Dear " &amp; iif(Parameters!Greeting.Value=1,Fields!FirstName.Value,iif(Fields!Salutation.Value="",Fields!MailName.Value,Fields!Salutation.Value)) &amp; "," 
&amp; "&lt;br&gt;&lt;br&gt;" &amp; Fields!LetterTextP1.Value 
&amp; iif(Parameters!LimitLow.Value=0 and Parameters!LimitHi.Value=0,"",iif(Parameters!NoSum.Value=true,"&lt;br&gt;&lt;br&gt;Our records show you contributed the following over the giving period: &lt;B&gt;January 1, " &amp; str(Parameters!YYYY.Value) +" to December 31, " &amp; str(Parameters!YYYY.Value) &amp;"&lt;/B&gt;.",""))</Value>
                                      <MarkupType>HTML</MarkupType>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>2.95in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.63444in</Height>
                              <Width>6.88545in</Width>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Tablix Name="Tablix5">
                              <TablixBody>
                                <TablixColumns>
                                  <TablixColumn>
                                    <Width>1.39167in</Width>
                                  </TablixColumn>
                                  <TablixColumn>
                                    <Width>1.43789in</Width>
                                  </TablixColumn>
                                </TablixColumns>
                                <TablixRows>
                                  <TablixRow>
                                    <Height>0.37152in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox34">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=iif(sum(Fields!GrossAmountNonDed.Value) =0,"Amount","Deductible Amount ")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","11pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox34</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox8">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>Non Ded</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","11pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>Amount</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","11pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox8</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.17361in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="GrossAmount">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>GrossAmount</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="GrossAmountNonDed1">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountNonDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>GrossAmountNonDed1</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.18403in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox38">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>'$'#,0.00;('$'#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox38</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                              <rd:FormatSymbolCulture>en-US</rd:FormatSymbolCulture>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox10">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountNonDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>'$'#,0.00;('$'#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox10</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                              <rd:FormatSymbolCulture>en-US</rd:FormatSymbolCulture>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.25694in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox88">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value />
                                                    <Style>
                                                      <FontFamily>Arial</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox88</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox4">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>="Total Contributions:" &amp; chr(10) &amp; Format(iif(sum(Fields!GrossAmountNonDed.Value) =0,0,sum(Fields!GrossAmount.Value)),"$###,##0.00")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox4</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                </TablixRows>
                              </TablixBody>
                              <TablixColumnHierarchy>
                                <TablixMembers>
                                  <TablixMember />
                                  <TablixMember>
                                    <Visibility>
                                      <Hidden>=sum(Fields!GrossAmountNonDed.Value) =0</Hidden>
                                    </Visibility>
                                  </TablixMember>
                                </TablixMembers>
                              </TablixColumnHierarchy>
                              <TablixRowHierarchy>
                                <TablixMembers>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>2.975in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox35">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(Parameters!ATTR.Value=2,"Fund","Fund Group")</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>=iif(Parameters!FontSize.Value="12pt","11pt","9pt")</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#666666</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style>
                                                <TextAlign>Left</TextAlign>
                                              </Style>
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox35</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BottomBorder>
                                              <Color>LightGrey</Color>
                                              <Style>Solid</Style>
                                              <Width>1pt</Width>
                                            </BottomBorder>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <TablixMembers>
                                      <TablixMember />
                                    </TablixMembers>
                                  </TablixMember>
                                  <TablixMember>
                                    <Group Name="FundDescription">
                                      <GroupExpressions>
                                        <GroupExpression>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSelected.Value)</GroupExpression>
                                      </GroupExpressions>
                                    </Group>
                                    <SortExpressions>
                                      <SortExpression>
                                        <Value>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSORT.Value)</Value>
                                      </SortExpression>
                                    </SortExpressions>
                                    <TablixHeader>
                                      <Size>2.975in</Size>
                                      <CellContents>
                                        <Textbox Name="FundDescription">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSelected.Value)</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                    <FontWeight>Normal</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>FundDescription</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <TablixMembers>
                                      <TablixMember />
                                    </TablixMembers>
                                  </TablixMember>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>2.975in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox37">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(str(Fields!BudgetNumber.Value) = "","Total", "Total Envelope Number " &amp; str(Fields!BudgetNumber.Value))</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>=iif(Parameters!FontSize.Value="12pt","10pt","9pt")</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox37</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <KeepWithGroup>Before</KeepWithGroup>
                                  </TablixMember>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>2.975in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox2">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value />
                                                  <Style>
                                                    <FontFamily>Arial</FontFamily>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox2</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <Visibility>
                                      <Hidden>=iif(sum(Fields!GrossAmountNonDed.Value) =0,True,False)</Hidden>
                                    </Visibility>
                                    <KeepWithGroup>Before</KeepWithGroup>
                                  </TablixMember>
                                </TablixMembers>
                              </TablixRowHierarchy>
                              <DataSetName>cDetails</DataSetName>
                              <Top>3.58444in</Top>
                              <Left>0.83502in</Left>
                              <Height>0.9861in</Height>
                              <Width>5.80456in</Width>
                              <ZIndex>1</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Parameters!LimitLow.Value = 0 and Parameters!LimitHi.Value = 0,True,iif(Parameters!NoSum.Value=true,False,True))</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Tablix>
                            <Textbox Name="Letter2">
                              <CanGrow>true</CanGrow>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=Fields!LetterTextP2.Value</Value>
                                      <MarkupType>HTML</MarkupType>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>4.57056in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.34508in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>2</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="Letter3">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=Fields!LetterSign.Value</Value>
                                      <MarkupType>HTML</MarkupType>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>5.73286in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.22965in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>3</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Tablix Name="Tablix9">
                              <TablixBody>
                                <TablixColumns>
                                  <TablixColumn>
                                    <Width>2.00332in</Width>
                                  </TablixColumn>
                                  <TablixColumn>
                                    <Width>1.20625in</Width>
                                  </TablixColumn>
                                  <TablixColumn>
                                    <Width>1.16338in</Width>
                                  </TablixColumn>
                                </TablixColumns>
                                <TablixRows>
                                  <TablixRow>
                                    <Height>0.63542in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox15">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Fields!LastName.Value &amp; ", " &amp; Fields!FirstName.Value</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox15</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>Solid</Style>
                                              </Border>
                                              <TopBorder>
                                                <Style>None</Style>
                                              </TopBorder>
                                              <LeftBorder>
                                                <Style>None</Style>
                                              </LeftBorder>
                                              <RightBorder>
                                                <Style>None</Style>
                                              </RightBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <VerticalAlign>Bottom</VerticalAlign>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                          <ColSpan>3</ColSpan>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell />
                                      <TablixCell />
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.1875in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox90">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=iif(Parameters!ATTR.Value=2,"Reference","Fund" &amp;"-" &amp; "Reference")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Left</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox90</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>Solid</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox91">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=iif(sum(Fields!GrossAmountNonDed.Value) =0,"Amount","Deductible Amount")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox91</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox1">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value> Non Ded Amount</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#666666</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox1</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.1875in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Reference">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=iif(Parameters!ATTR.Value=2,"",iif(Fields!FundDescription.Value&lt;&gt;Fields!AttributeSelected.Value,Fields!FundDescription.Value,"")) 
&amp; iif(len(Fields!Reference.Value)&gt;0,  Fields!Reference.Value ,"") 
&amp; iif((Parameters!Comments.Value = True) And (len(Fields!Comment.Value) &gt; 0),  Fields!Comment.Value, "")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Left</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Reference</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="GrossAmount1">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>GrossAmount1</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="GrossAmountNonDed">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Fields!GrossAmountNonDed.Value</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>GrossAmountNonDed</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.1875in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox103">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value />
                                                    <Style>
                                                      <FontFamily>Arial</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Left</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox103</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                                <Width>1pt</Width>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox104">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox104</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox105">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountNonDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Normal</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox104</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BottomBorder>
                                                <Color>LightGrey</Color>
                                                <Style>Solid</Style>
                                              </BottomBorder>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.1875in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox99">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value />
                                                    <Style>
                                                      <FontFamily>Arial</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Left</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox99</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox100">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox100</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox101">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>=Sum(Fields!GrossAmountNonDed.Value)</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style />
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox100</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                  <TablixRow>
                                    <Height>0.25in</Height>
                                    <TablixCells>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox20">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value />
                                                    <Style>
                                                      <FontFamily>Arial</FontFamily>
                                                      <FontSize>9pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Left</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox20</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox3">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value />
                                                    <Style>
                                                      <FontFamily>Arial</FontFamily>
                                                      <FontSize>8pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox3</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                      <TablixCell>
                                        <CellContents>
                                          <Textbox Name="Textbox22">
                                            <CanGrow>true</CanGrow>
                                            <KeepTogether>true</KeepTogether>
                                            <Paragraphs>
                                              <Paragraph>
                                                <TextRuns>
                                                  <TextRun>
                                                    <Value>="Total Contributions:" &amp; chr(10) &amp; Format(iif(sum(Fields!GrossAmountNonDed.Value) =0,0,sum(Fields!GrossAmount.Value)),"$###,##0.00")</Value>
                                                    <Style>
                                                      <FontFamily>=Parameters!Font.Value</FontFamily>
                                                      <FontSize>8pt</FontSize>
                                                      <FontWeight>Bold</FontWeight>
                                                      <Format>#,0.00;(#,0.00)</Format>
                                                      <Color>#333333</Color>
                                                    </Style>
                                                  </TextRun>
                                                </TextRuns>
                                                <Style>
                                                  <TextAlign>Right</TextAlign>
                                                </Style>
                                              </Paragraph>
                                            </Paragraphs>
                                            <rd:DefaultName>Textbox22</rd:DefaultName>
                                            <Style>
                                              <Border>
                                                <Style>None</Style>
                                              </Border>
                                              <BackgroundColor>White</BackgroundColor>
                                              <PaddingLeft>2pt</PaddingLeft>
                                              <PaddingRight>2pt</PaddingRight>
                                              <PaddingTop>2pt</PaddingTop>
                                              <PaddingBottom>2pt</PaddingBottom>
                                            </Style>
                                          </Textbox>
                                        </CellContents>
                                      </TablixCell>
                                    </TablixCells>
                                  </TablixRow>
                                </TablixRows>
                              </TablixBody>
                              <TablixColumnHierarchy>
                                <TablixMembers>
                                  <TablixMember />
                                  <TablixMember />
                                  <TablixMember>
                                    <Visibility>
                                      <Hidden>=Sum(Fields!GrossAmountNonDed.Value) = 0</Hidden>
                                    </Visibility>
                                  </TablixMember>
                                </TablixMembers>
                              </TablixColumnHierarchy>
                              <TablixRowHierarchy>
                                <TablixMembers>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>2.61667in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox13">
                                          <CanGrow>true</CanGrow>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=Fields!ChurchName.Value</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>9pt</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#666666</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style>
                                                <TextAlign>Left</TextAlign>
                                              </Style>
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox13</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>Solid</Style>
                                            </Border>
                                            <TopBorder>
                                              <Style>None</Style>
                                            </TopBorder>
                                            <LeftBorder>
                                              <Style>None</Style>
                                            </LeftBorder>
                                            <RightBorder>
                                              <Style>None</Style>
                                            </RightBorder>
                                            <BackgroundColor>White</BackgroundColor>
                                            <VerticalAlign>Bottom</VerticalAlign>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                  </TablixMember>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>1.78834in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox95">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(Parameters!ATTR.Value=2,"Fund","Fund Group")</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>9pt</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#666666</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style>
                                                <TextAlign>Left</TextAlign>
                                              </Style>
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox95</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>Solid</Style>
                                            </Border>
                                            <BottomBorder>
                                              <Color>LightGrey</Color>
                                              <Width>1pt</Width>
                                            </BottomBorder>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <TablixMembers>
                                      <TablixMember>
                                        <TablixHeader>
                                          <Size>0.82833in</Size>
                                          <CellContents>
                                            <Textbox Name="Textbox93">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value>Date</Value>
                                                      <Style>
                                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                                        <FontSize>9pt</FontSize>
                                                        <FontWeight>Bold</FontWeight>
                                                        <Color>#666666</Color>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style>
                                                    <TextAlign>Left</TextAlign>
                                                  </Style>
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>Textbox93</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Style>None</Style>
                                                </Border>
                                                <BottomBorder>
                                                  <Color>LightGrey</Color>
                                                  <Style>Solid</Style>
                                                  <Width>1pt</Width>
                                                </BottomBorder>
                                                <BackgroundColor>White</BackgroundColor>
                                                <PaddingLeft>2pt</PaddingLeft>
                                                <PaddingRight>2pt</PaddingRight>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                        <TablixMembers>
                                          <TablixMember />
                                        </TablixMembers>
                                      </TablixMember>
                                    </TablixMembers>
                                  </TablixMember>
                                  <TablixMember>
                                    <Group Name="FundDescription1">
                                      <GroupExpressions>
                                        <GroupExpression>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSelected.Value)</GroupExpression>
                                      </GroupExpressions>
                                    </Group>
                                    <SortExpressions>
                                      <SortExpression>
                                        <Value>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSORT.Value)</Value>
                                      </SortExpression>
                                    </SortExpressions>
                                    <TablixHeader>
                                      <Size>1.78834in</Size>
                                      <CellContents>
                                        <Textbox Name="FundDescription1">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(Parameters!ATTR.Value=2,Fields!FundDescription.Value,Fields!AttributeSelected.Value)</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>9pt</FontSize>
                                                    <FontWeight>Normal</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>FundDescription1</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BottomBorder>
                                              <Color>LightGrey</Color>
                                              <Style>Solid</Style>
                                              <Width>1pt</Width>
                                            </BottomBorder>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <TablixMembers>
                                      <TablixMember>
                                        <Group Name="ContributionDate">
                                          <GroupExpressions>
                                            <GroupExpression>=Fields!ContributionDate.Value</GroupExpression>
                                          </GroupExpressions>
                                        </Group>
                                        <SortExpressions>
                                          <SortExpression>
                                            <Value>=Fields!ContributionDate.Value</Value>
                                          </SortExpression>
                                        </SortExpressions>
                                        <TablixHeader>
                                          <Size>0.82833in</Size>
                                          <CellContents>
                                            <Textbox Name="ContributionDate">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value>=Fields!ContributionDate.Value</Value>
                                                      <Style>
                                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                                        <FontSize>9pt</FontSize>
                                                        <FontWeight>Normal</FontWeight>
                                                        <Format>M/d/yyyy</Format>
                                                        <Color>#333333</Color>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style>
                                                    <TextAlign>Left</TextAlign>
                                                  </Style>
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>ContributionDate</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Style>None</Style>
                                                </Border>
                                                <BackgroundColor>White</BackgroundColor>
                                                <PaddingLeft>2pt</PaddingLeft>
                                                <PaddingRight>2pt</PaddingRight>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                        <TablixMembers>
                                          <TablixMember>
                                            <Group Name="Details2" />
                                          </TablixMember>
                                        </TablixMembers>
                                      </TablixMember>
                                      <TablixMember>
                                        <TablixHeader>
                                          <Size>0.82833in</Size>
                                          <CellContents>
                                            <Textbox Name="Textbox102">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value>Total</Value>
                                                      <Style>
                                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                                        <FontSize>9pt</FontSize>
                                                        <FontWeight>Normal</FontWeight>
                                                        <Color>#333333</Color>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style />
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>Textbox102</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Style>None</Style>
                                                </Border>
                                                <BottomBorder>
                                                  <Color>LightGrey</Color>
                                                  <Style>Solid</Style>
                                                  <Width>1pt</Width>
                                                </BottomBorder>
                                                <BackgroundColor>White</BackgroundColor>
                                                <PaddingLeft>2pt</PaddingLeft>
                                                <PaddingRight>2pt</PaddingRight>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                        <KeepWithGroup>Before</KeepWithGroup>
                                      </TablixMember>
                                    </TablixMembers>
                                  </TablixMember>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>2.61667in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox97">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value>=iif(str(Fields!BudgetNumber.Value) = "", "Total", "Total Envelope Number " &amp; str(Fields!BudgetNumber.Value))</Value>
                                                  <Style>
                                                    <FontFamily>=Parameters!Font.Value</FontFamily>
                                                    <FontSize>9pt</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox97</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                  </TablixMember>
                                  <TablixMember>
                                    <TablixHeader>
                                      <Size>1.78834in</Size>
                                      <CellContents>
                                        <Textbox Name="Textbox18">
                                          <CanGrow>true</CanGrow>
                                          <KeepTogether>true</KeepTogether>
                                          <Paragraphs>
                                            <Paragraph>
                                              <TextRuns>
                                                <TextRun>
                                                  <Value />
                                                  <Style>
                                                    <FontFamily>Arial</FontFamily>
                                                    <FontSize>9pt</FontSize>
                                                    <FontWeight>Bold</FontWeight>
                                                    <Color>#333333</Color>
                                                  </Style>
                                                </TextRun>
                                              </TextRuns>
                                              <Style />
                                            </Paragraph>
                                          </Paragraphs>
                                          <rd:DefaultName>Textbox18</rd:DefaultName>
                                          <Style>
                                            <Border>
                                              <Style>None</Style>
                                            </Border>
                                            <BackgroundColor>White</BackgroundColor>
                                            <PaddingLeft>2pt</PaddingLeft>
                                            <PaddingRight>2pt</PaddingRight>
                                            <PaddingTop>2pt</PaddingTop>
                                            <PaddingBottom>2pt</PaddingBottom>
                                          </Style>
                                        </Textbox>
                                      </CellContents>
                                    </TablixHeader>
                                    <TablixMembers>
                                      <TablixMember>
                                        <TablixHeader>
                                          <Size>0.82833in</Size>
                                          <CellContents>
                                            <Textbox Name="Textbox19">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value />
                                                      <Style>
                                                        <FontFamily>Arial</FontFamily>
                                                        <FontSize>9pt</FontSize>
                                                        <FontWeight>Bold</FontWeight>
                                                        <Color>#333333</Color>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style />
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>Textbox19</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Style>None</Style>
                                                </Border>
                                                <BackgroundColor>White</BackgroundColor>
                                                <PaddingLeft>2pt</PaddingLeft>
                                                <PaddingRight>2pt</PaddingRight>
                                                <PaddingTop>2pt</PaddingTop>
                                                <PaddingBottom>2pt</PaddingBottom>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                      </TablixMember>
                                    </TablixMembers>
                                  </TablixMember>
                                </TablixMembers>
                              </TablixRowHierarchy>
                              <RepeatColumnHeaders>true</RepeatColumnHeaders>
                              <RepeatRowHeaders>true</RepeatRowHeaders>
                              <DataSetName>cDetails</DataSetName>
                              <PageBreak>
                                <BreakLocation>Start</BreakLocation>
                              </PageBreak>
                              <PageName>Details</PageName>
                              <Top>6.45435in</Top>
                              <Left>0.38001in</Left>
                              <Height>1.63542in</Height>
                              <Width>6.98962in</Width>
                              <ZIndex>4</ZIndex>
                              <Visibility>
                                <Hidden>=Parameters!Details.Value</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Tablix>
                            <Textbox Name="Textbox6">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=replace(Fields!ChurchName.Value," Parish","") &amp; " Parish has not provided, in whole or in part, any goods or services to the above-named donor in exchange for this gift.  " &amp;
replace(Fields!ChurchName.Value," Parish","") &amp; " Parish is recognized as a tax-exempt organization under section 501(c)(3) of the Internal Revenue Code. Contributions to organizations with 501(c)(3) status may be tax deductible. Please consult your tax advisor to determine deductibility of this contribution. This letter is your receipt for income tax purposes. "</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>9pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Center</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>Textbox6</rd:DefaultName>
                              <Top>6.00417in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.26389in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>5</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Image Name="Signature">
                              <Source>External</Source>
                              <Value>=Fields!LetterSignURL.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>4.98508in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.70611in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>6</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LetterSignURL.Value="",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Textbox Name="ChurchRight">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=chr(10) &amp; chr(10) &amp; chr(10) 
&amp; iif(Parameters!FO.Value=1,"",trim(replace(Fields!ChurchName.Value,"Parish","")) &amp; " Parish" 
&amp; chr(10) &amp; Fields!CAddr1.Value 
&amp; chr(10) &amp; Fields!CCity.Value &amp; ", " &amp; Fields!CState.Value &amp; " " &amp; Fields!CZipCode.Value)</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Right</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <Top>1.34227in</Top>
                              <Left>4.14046in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>7</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",False,True)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="FamilyID">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=FormatDateTime(Parameters!Date.Value,DateFormat.ShortDate) 
&amp; chr(10) 
&amp; chr(10) 
&amp; 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>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>FamilyID</rd:DefaultName>
                              <Top>1.34227in</Top>
                              <Left>0.38001in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.43001in</Width>
                              <ZIndex>8</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Image Name="LogoWide">
                              <Source>External</Source>
                              <Value>=Fields!Logo.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>0.11221in</Top>
                              <Left>0.38001in</Left>
                              <Height>1.08228in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>9</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",False,True)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Image Name="LogoSquare">
                              <Source>External</Source>
                              <Value>=Fields!Logo.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>0.11221in</Top>
                              <Left>4.85112in</Left>
                              <Height>2.31374in</Height>
                              <Width>2.41434in</Width>
                              <ZIndex>10</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Textbox Name="ChurchTop">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=iif(Parameters!FO.Value=1,chr(10)&amp;chr(10)&amp;chr(10), trim(replace(Fields!ChurchName.Value,"Parish","")) &amp; " Parish" 
&amp; chr(10) &amp; Fields!CAddr1.Value 
&amp; chr(10) &amp; Fields!CCity.Value &amp; ", " &amp; Fields!CState.Value &amp; " " &amp; Fields!CZipCode.Value)</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Left</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <Top>0.11221in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.97951in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>11</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="EmailAddress">
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>="EMAIL:" &amp; Fields!EmailAddress.Value</Value>
                                      <Style>
                                        <FontSize>8pt</FontSize>
                                        <Color>White</Color>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>EmailAddress</rd:DefaultName>
                              <Top>0.00944in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.07499in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>12</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </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="Details1">
                    <GroupExpressions>
                      <GroupExpression>=Fields!familyid.Value</GroupExpression>
                    </GroupExpressions>
                    <PageBreak>
                      <BreakLocation>Between</BreakLocation>
                    </PageBreak>
                  </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>Details</DataSetName>
            <Height>8.08977in</Height>
            <Width>7.5in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>8.08977in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>7.5in</Width>
      <Page>
        <LeftMargin>0.5in</LeftMargin>
        <RightMargin>0.5in</RightMargin>
        <TopMargin>0.125in</TopMargin>
        <BottomMargin>0.25in</BottomMargin>
        <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>Church</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="FForm">
      <DataType>String</DataType>
      <Prompt>Form</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Forms</DataSetName>
          <ValueField>LetterForm</ValueField>
          <LabelField>LetterForm</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Statuses">
      <DataType>String</DataType>
      <Prompt>Select Family Status</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Statuses</DataSetName>
          <ValueField>StatusCode</ValueField>
          <LabelField>StatusCode</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="YYYY">
      <DataType>Integer</DataType>
      <Prompt>YYYY</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>CurrYear</DataSetName>
          <ValueField>Year</ValueField>
          <LabelField>Year</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="LimitLow">
      <DataType>Integer</DataType>
      <Prompt>Limit Low</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>LOW</DataSetName>
          <ValueField>AMT</ValueField>
          <LabelField>AMT</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="LimitHi">
      <DataType>Integer</DataType>
      <Prompt>Limit Hi</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>HIGH</DataSetName>
          <ValueField>AMT</ValueField>
          <LabelField>AMT</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Buckets">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <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="Families">
      <DataType>Integer</DataType>
      <Prompt>Families</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyFamilies</DataSetName>
          <ValueField>FamilyID</ValueField>
          <LabelField>LastFirst</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="ATTR">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>2</Value>
        </Values>
      </DefaultValue>
      <Prompt>Summarization</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>2</Value>
            <Label>Standard (by fund)</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>0</Value>
            <Label>Parish Attributes</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>AOC Attributes</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Greeting">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Greeting</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Use Family Salutation</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Use Family First Name</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="NoSum">
      <DataType>Boolean</DataType>
      <DefaultValue>
        <Values>
          <Value>true</Value>
        </Values>
      </DefaultValue>
      <Prompt>Summary on Cover Page?</Prompt>
    </ReportParameter>
    <ReportParameter Name="Details">
      <DataType>Boolean</DataType>
      <DefaultValue>
        <Values>
          <Value>false</Value>
        </Values>
      </DefaultValue>
      <Prompt>Suppress Details Page?</Prompt>
    </ReportParameter>
    <ReportParameter Name="Comments">
      <DataType>Boolean</DataType>
      <DefaultValue>
        <Values>
          <Value>false</Value>
        </Values>
      </DefaultValue>
      <Prompt>Include comments with details?</Prompt>
    </ReportParameter>
    <ReportParameter Name="Date">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=today()</Value>
        </Values>
      </DefaultValue>
      <Prompt>Date</Prompt>
    </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="FO">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Format Options</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Display Return Address</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Suppress Return Address</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>
    <ReportParameter Name="Font">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>Arial</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Font</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>Arial</Value>
            <Label>Arial</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Calibri</Value>
            <Label>Calibri</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Century</Value>
            <Label>Century</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Comic Sans MS</Value>
            <Label>Comic Sans MS</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Lucida Sans</Value>
            <Label>Lucida Sans</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Georgia</Value>
            <Label>Georgia</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Tahoma</Value>
            <Label>Tahoma</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Times New Roman</Value>
            <Label>Times New Roman</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Verdana</Value>
            <Label>Verdana</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="FontSize">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>12pt</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Font Size</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>12pt</Value>
            <Label>12 point</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>10pt</Value>
            <Label>10 Point</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>3</NumberOfColumns>
      <NumberOfRows>8</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>FForm</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Statuses</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>YYYY</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>LimitLow</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>LimitHi</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Buckets</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Funds</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Families</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>ATTR</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>Greeting</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>NoSum</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Details</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Comments</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Date</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>Address</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>AddressCase</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>FO</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>7</RowIndex>
          <ParameterName>Sort</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>7</RowIndex>
          <ParameterName>Font</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>7</RowIndex>
          <ParameterName>FontSize</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>72829793-6244-472b-b4c1-dd9b28fc0ea1</rd:ReportID>
</Report>