﻿<?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>SELECT
  ChurchID
  ,ChurchName + ' - ' +City ChurchName
FROM
  xrpt.Churches_vw 
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,'PLEDGE, ','') LetterForm
from xrpt.FamilyNotes_vw fn
where MemberLastFirst like 'PLEDGE, %'
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="Details">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgeFunds">
            <Value>=Parameters!PledgeFunds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgePeriod">
            <Value>=Parameters!PledgePeriod.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Pledges">
            <Value>=Parameters!Pledges.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FForm">
            <Value>=Parameters!FForm.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CurrentUser">
            <Value>=Parameters!CurrentUser.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ThruDate">
            <Value>=Parameters!ThruDate.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--Created for the Archdiocese of Cincinnati 
--bmaly@catholicaoc.org
--Create Date 2021.10.15

----declare @churchid int = 88
----declare @statuses varchar(30) = ' All Statuses'
----Declare @familytags int = 1
----declare @FForm varchar(10) = 'retuition'
----declare @pledgefunds int = 5802
----declare @pledges varchar(30) = ' all items'
----declare @pledgeperiod varchar(50) = 'P-08/24/2021 to 05/25/2022'

Declare @ChurchData Table
(ChurchID int
,Logo  nvarchar(200)
,LogoOrientation nvarchar(200)
,LetterText nvarchar(2000)
,LetterSign nvarchar(200)
,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 = 'Pledge, '+@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 = 'Pledge, '+@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:%'))
,LetterText=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace((select top 1 replace(note,'Text:','')  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 = 'Pledge, '+@FForm
	and note like 'Text:%'),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=(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 = 'Pledge, '+@FForm
	and note like 'Sign:%')
,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 = 'Pledge, '+@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 @PledgeFundsT table (id int)
insert into @PledgeFundsT
select distinct
 fundid
from xrpt.FundPledges_vw fp
Where fp.ChurchID = @ChurchID
  and exists (select 1 
	from xrpt.FundContributions_vw c
	where c.ChurchID=fp.ChurchID
	and c.FundID=fp.FundID)
and exists (select 1 
	from xrpt.funds_vw fund
	where fund.statuscode='ACTIVE' 
	and fund.FundID=fp.FundID)
  and (' All Statuses' in (@Statuses)
	or exists (select 1 from xrpt.Families_vw f
		where f.ChurchID=fp.ChurchID
		and f.FamilyID=fp.FamilyID
		and f.StatusCode in (@Statuses))
	)
and (0 in (@FamilyTags)
	or exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			)
	or (1 in (@FamilyTags)
	and not exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			))
	)
declare @PledgeFundDatesT table (
period varchar(max))
insert into @PledgeFundDatesT 
select distinct 'P-' +
convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101) Period
from xrpt.FundPledges_vw f
join @PledgeFundsT pft
on pft.id=f.FundID
Where f.ChurchID = @ChurchID
 and (0 in  (@PledgeFunds)
or f.FundID in (@PledgeFunds))

Declare @selected table (ID int identity(1,1)
	,FamilyID int
	,PledgeID int
	,Frequency varchar(10)
	,DateFrom date
	,PledgeAmount money
	,PmtCnt int
	,Label varchar(200))

insert into @selected
select distinct FamilyID
	,PledgeID
	,FrequencyID
	,DateFrom
	,PledgeAmount
	,PmtCnt = case when FrequencyID in ('ONE','NONE') then 1 else 
		  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1) else 
		  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1) else 
		  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1) else 
		  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1) else 
		  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1) else 
		  1 end end end end end end
	,LastFirst +' ('+convert(varchar(10),case when FrequencyID in ('ONE','NONE') then PledgeAmount else 
		  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1)*PledgeAmount else 
		  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1)*PledgeAmount else 
		  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1)*PledgeAmount else 
		  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1)*PledgeAmount else 
		  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1)*PledgeAmount else 
		  PledgeAmount end end end end end end ,1)+')' label
from [xrpt].[FundPledges_vw] f
	join @PledgeFundDatesT PFDT
	on PFDT.period = 'P-' +convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101)
where f.ChurchID = @ChurchID
	and (' All Periods' in (@PledgePeriod)
	or  'P-' +convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101) in (@PledgePeriod))

--prepare table that has every family/pledge/pmtdate/amount
Declare @Schedule table
	(ID int identity(1,1)
	,FamilyID int
	,PledgeID int
	,DueDate date
	,Pmt money
	)
--first loop FamilyID
declare @FIDloop table (ID int identity(1,1),FamilyID int)
	insert into @FIDloop
	select distinct FamilyID from @selected
	declare @maxFID int
	declare @SFID int =1
	Select @SFID = min(ID), @maxFID = max(ID) from @FIDloop
	while @SFID &lt;= @maxFID 
		Begin 
		declare @PIDloop table (ID int identity(1,1),PledgeID int)
		declare @FamilyID int
		select top 1 @FamilyID = FamilyID from @FIDloop where ID = @SFID
		insert into @PIDloop
		select distinct PledgeID from @selected where FamilyID = @FamilyID
		declare @maxPID int
		declare @SPID int
		Select @SPID = min(ID),  @maxPID = max(ID) from @PIDloop 
		while @SPID &lt;= @maxPID 
			Begin 
			Declare @PledgeID int
			select @PledgeID = PledgeID from @PIDloop where ID = @SPID
			declare @PmtCnt int
			declare @DateFrom date
			declare @Frequency nvarchar(10)
			declare @PledgeAmount money
			Select @PmtCnt = PmtCnt
				,@DateFrom = DateFrom
				,@Frequency = Frequency
				,@PledgeAmount = PledgeAmount
			from @selected 
				where FamilyID = @FamilyID
				and PledgeID = @PledgeID
					
			Declare @cnt int = 1
			while @cnt &lt;= @PmtCnt
				begin
					insert into @Schedule
					select @FamilyID
					,@PledgeID
					,case when @Frequency in ('ONE','NONE') then @DateFrom else 
		  case when @Frequency = 'WK' then dateadd(WW,@cnt,@DateFrom) else 
		  case when @Frequency = 'MO' then dateadd(MM,@cnt,@DateFrom) else 
		  case when @Frequency = 'QTR' then dateadd(QQ,@cnt,@DateFrom) else 
		  case when @Frequency = 'SEMI' then (dateadd(YY,@cnt/2,@DateFrom)) else 
		  case when @Frequency = 'YR' then dateadd(YY,@cnt,@DateFrom) else 
					@DateFrom end end end end end end
					,@PledgeAmount

				select @cnt+=1
				end
			
			select @SPID+=1
			end
		delete @PIDloop
		select @SFID+=1
		end


declare @PFunds table (
	ChurchID int,
	FundID int,
	FamilyID int,
	PledgeID int,
	LastFirst varchar(162),
	DateFrom date,
	DateTo Date,
	PledgeAmount int,
	Texts varchar(max))
insert into @PFunds
select distinct ChurchID
,FundID
,f.FamilyID
,f.PledgeID
,LastFirst
,convert(date,f.DateFrom,101) DateFrom
,convert(date,f.DateTo,101) DateTo
,isnull(f.TotalPledgeAmount,f.AnnualAmount) [PledgeAmount]
,LastFirst +' ('+convert(varchar(10),case when FrequencyID in ('ONE','NONE') then f.PledgeAmount else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,f.DateFrom,DateTo)/2)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  f.PledgeAmount end end end end end end ,1)+')' label
from [xrpt].[FundPledges_vw] f
join @selected s
on s.Label=LastFirst +' ('+convert(varchar(10),case when FrequencyID in ('ONE','NONE') then f.PledgeAmount else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,f.DateFrom,DateTo)/2)+1)*f.PledgeAmount else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,f.DateFrom,DateTo)+1)*f.PledgeAmount else 
	  f.PledgeAmount end end end end end end ,1)+')'
where f.ChurchID = @ChurchID
and (0 in (@Pledges) 
or f.PledgeID in (@Pledges))

;with totPledgeContrib as
(select x.FamilyID
		,f.PledgeID
		,x.FundID
		,x.FundDescription
		,year(x.ContributionDate) cYYYY
		,month(x.ContributionDate) cMM
		,x.ContributionDate TransactionDate
		,PledgePeriod = convert(varchar(10),f.DateFrom,101) + ' to ' + convert(varchar(10),f.DateTo,101) 
		,x.GrossAmount
		,x.Reference
		,x.Comment
	from xrpt.FundContributions_vw x 
	join @PFunds f 
		on f.churchid=x.churchid
		and f.fundid=x.fundid
		and f.FamilyID=x.FamilyID
	where x.ChurchID = @ChurchID 
	and exists (select 1 from xrpt.ChurchUsers_vw cu 
		where x.ChurchID = cu.ChurchID 
		and cu.UserName=@CurrentUser 
		and (cu.ChurchAdministrator = 1 or cu.FundManager = 1))
	and exists (select 1 from @PFunds p
		where p.ChurchID = x.ChurchID
		and x.FundID = p.FundID
		and p.FamilyID = x.FamilyID 
		and x.ContributionDate &gt;= dateadd(dd,1,p.DateFrom)
		and x.ContributionDate &lt; dateadd(dd,1,@ThruDate)
		)
	)


select FData.*,CV.*
,s.Frequency TFreq
,s.PmtCnt TPmtCnt
,s.PledgeAmount PA from (
SELECT  f.[FamilyID]
	,f.[LastFirst]
	,f.StatusCode
	,f.[BudgetNumber]
	,f.FirstName + ' ' + f.LastName Name
	,ml.MailName
	,ml.Salutation
	,ml.Addr1
	,ml.Addr2
	,ml.City
	,ml.[State]
	,ml.ZipCode
	,isnull(f.EmailAddress,'') EmailAddress
	,f.EmailAlerts
	,fc.[FundID]
	,fc.FundDescription
	,fc.TransactionDate
	,fc.GrossAmount
	--,fc.MSN
	,fc.cYYYY
	,fc.cMM
	,fc.PledgeID
	,0 PledgeAmount
	,0 AnnualAmount
	,0 TPNumber
	,0 TPAmount
	,0 TotalPledgeAmount
	,fc.Reference
	,fc.Comment
	,'' FrequencyID
	--,convert(date,mCD,101) [DateFrom]
	--,convert(date,mCD,101) [DateTo]
	, PledgePeriod
	,0 PmtDue
FROM totPledgeContrib fc 
 join xrpt.Families_vw f
	on  fc.FamilyID=f.FamilyID
join xrpt.Churches_vw AS CV 
	on f.ChurchID=CV.ChurchID
join xrpt.MailingLabels_vw ml
	on ml.familyID=f.FamilyID
  where f.ChurchID = @ChurchID 	
union all
SELECT f.[FamilyID]
	,f.[LastFirst]
	,f.StatusCode
	,f.[BudgetNumber]
	,f.FirstName + ' ' + f.LastName Name
	,ml.MailName
	,ml.Salutation
	,ml.Addr1
	,ml.Addr2
	,ml.City
	,ml.[State]
	,ml.ZipCode
	,isnull(f.EmailAddress,'') EmailAddress
	,f.EmailAlerts
	,fp.[FundID]
	,fx.FundDescription
	,DueDate
	,0
	--,fc.MSN
	,Year(dueDate) cYYYY
	,month(DueDate) cMM
	,sch.PledgeID
	,0 PledgeAmount
	,0 AnnualAmount
	,0 TPNumber
	,0 TPAmount
	,0 TotalPledgeAmount
	,'' Reference
	,'' Comment
	,'' FrequencyID
	--,convert(date,mCD,101) [DateFrom]
	--,convert(date,mCD,101) [DateTo]
	,convert(varchar(10),fp.DateFrom,101) + ' to ' + convert(varchar(10),fp.DateTo,101) 
	,Pmt
FROM @Schedule sch 
left join xrpt.fundpledges_vw fp
	on fp.pledgeid=sch.pledgeid
left join xrpt.funds_vw fx
	on fx.fundid=fp.fundid
join xrpt.Families_vw f
	on  sch.FamilyID=f.FamilyID
join xrpt.Churches_vw AS CV 
	on f.ChurchID=CV.ChurchID
join xrpt.MailingLabels_vw ml
	on ml.familyID=f.FamilyID
  where f.ChurchID = @ChurchID 	
union all
SELECT  f.[FamilyID]
	,f.[LastFirst]
	,f.StatusCode
	,f.[BudgetNumber]
	,f.FirstName + ' ' + f.LastName Name
	,ml.MailName
	,ml.Salutation
	,ml.Addr1
	,ml.Addr2
	,ml.City
	,ml.[State]
	,ml.ZipCode
	,isnull(f.EmailAddress,'') EmailAddress
	,f.EmailAlerts
	,fp.[FundID]
	,fp.FundDescription
	,fp.ModifiedDate
	,0--fc.GrossAmount
	--,0--fc.MSN
	,year(fp.dateto)
	,month(fp.dateto)
	,fp.PledgeID
	,fp.[PledgeAmount]
	,fp.AnnualAmount
	, TPNumber=case when FrequencyID in ('ONE','NONE') then 1 else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1) else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1) else 
	  PledgeAmount end end end end end end
	,TPAmount=case when FrequencyID in ('ONE','NONE') then PledgeAmount else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1)*PledgeAmount else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1)*PledgeAmount else 
	  PledgeAmount end end end end end end 
	,TotalPledgeAmount
	,'' 
	,fp.[Comment]
	,fp.FrequencyID
	,convert(varchar(10),fp.DateFrom,101) + ' to ' + convert(varchar(10),fp.DateTo,101)	
	,0 Pmt
FROM [xrpt].[FundPledges_vw] fp 
 join xrpt.Families_vw f
	on f.FamilyID=fp.FamilyID 
	and f.ChurchID = fp.ChurchID
join xrpt.Churches_vw AS CV 
	on f.ChurchID=CV.ChurchID
join xrpt.MailingLabels_vw ml
	on ml.familyID=f.FamilyID
  where f.ChurchID = @ChurchID
  	and exists (select 1 from @PFunds p
		where p.ChurchID = fp.ChurchID
		and p.FundID = fp.FundID
		and p.FamilyID = fp.FamilyID) ) FDATA
join @selected s 
on s.PledgeID = FDATA.PledgeID
and s.FamilyID = fdata.FamilyID
and (0 in (@Pledges)
	or s.PledgeID in (@Pledges))
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="LetterSign">
          <DataField>LetterSign</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="LastFirst">
          <DataField>LastFirst</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BudgetNumber">
          <DataField>BudgetNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Name">
          <DataField>Name</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="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="TransactionDate">
          <DataField>TransactionDate</DataField>
          <rd:TypeName>System.DateTime</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="cYYYY">
          <DataField>cYYYY</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FundID">
          <DataField>FundID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="cMM">
          <DataField>cMM</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="PledgeID">
          <DataField>PledgeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FundDescription">
          <DataField>FundDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PledgeAmount">
          <DataField>PledgeAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="AnnualAmount">
          <DataField>AnnualAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="LetterText">
          <DataField>LetterText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TPNumber">
          <DataField>TPNumber</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TPAmount">
          <DataField>TPAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="Reference">
          <DataField>Reference</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TotalPledgeAmount">
          <DataField>TotalPledgeAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="FrequencyID">
          <DataField>FrequencyID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Comment">
          <DataField>Comment</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PledgePeriod">
          <DataField>PledgePeriod</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CState">
          <DataField>CState</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PmtDue">
          <DataField>PmtDue</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="GrossAmount">
          <DataField>GrossAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TFreq">
          <DataField>TFreq</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TPmtCnt">
          <DataField>TPmtCnt</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="PA">
          <DataField>PA</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="PledgeFunds">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>select distinct
 fundid
,FundDescription
--,convert(date,DateFrom,101) DateFrom
--,convert(date,DateTo,101) DateTo
from xrpt.FundPledges_vw fp
Where fp.ChurchID = @ChurchID
and exists (select 1 
	from xrpt.funds_vw fund
	where fund.statuscode='ACTIVE' 
	and fund.FundID=fp.FundID)
  and exists (select 1 
	from xrpt.FundContributions_vw c
	where c.ChurchID=fp.ChurchID
	and c.FundID=fp.FundID)
  and (' All Statuses' in (@Statuses)
	or exists (select 1 from xrpt.Families_vw f
		where f.ChurchID=fp.ChurchID
		and f.FamilyID=fp.FamilyID
		and f.StatusCode in (@Statuses))
	)
and (0 in (@FamilyTags)
	or exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			)
	or (1 in (@FamilyTags)
	and not exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			))
	)</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="PledgePeriod">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgeFunds">
            <Value>=Parameters!PledgeFunds.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>declare @PledgeFundsT table (
id int)

insert into @PledgeFundsT
select distinct
 fundid
from xrpt.FundPledges_vw fp
Where fp.ChurchID = @ChurchID
  and exists (select 1 
	from xrpt.FundContributions_vw c
	where c.ChurchID=fp.ChurchID
	and c.FundID=fp.FundID)
and exists (select 1 
	from xrpt.funds_vw fund
	where fund.statuscode='ACTIVE' 
	and fund.FundID=fp.FundID)
  and (' All Statuses' in (@Statuses)
	or exists (select 1 from xrpt.Families_vw f
		where f.ChurchID=fp.ChurchID
		and f.FamilyID=fp.FamilyID
		and f.StatusCode in (@Statuses))
	)
and (0 in (@FamilyTags)
	or exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			)
	or (1 in (@FamilyTags)
	and not exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			))
	)

select * from (
select distinct 'P-'+
convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101) Period
from xrpt.FundPledges_vw f
join @PledgeFundsT pft
on pft.id=f.FundID
Where f.ChurchID = @ChurchID
and (0 in (@PledgeFunds)
or f.fundid in (@PledgeFunds))
union all
select ' All Periods') TXT
order by Period</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="Period">
          <DataField>Period</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Pledges">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgeFunds">
            <Value>=Parameters!PledgeFunds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgePeriod">
            <Value>=Parameters!PledgePeriod.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>declare @PledgeFundsT table (
id int)

insert into @PledgeFundsT
select distinct
 fundid
from xrpt.FundPledges_vw fp
Where fp.ChurchID = @ChurchID
  and exists (select 1 
	from xrpt.FundContributions_vw c
	where c.ChurchID=fp.ChurchID
	and c.FundID=fp.FundID)
and exists (select 1 
	from xrpt.funds_vw fund
	where fund.statuscode='ACTIVE' 
	and fund.FundID=fp.FundID)
  and (' All Statuses' in (@Statuses)
	or exists (select 1 from xrpt.Families_vw f
		where f.ChurchID=fp.ChurchID
		and f.FamilyID=fp.FamilyID
		and f.StatusCode in (@Statuses))
	)
and (0 in (@FamilyTags)
	or exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			)
	or (1 in (@FamilyTags)
	and not exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = fp.ChurchID
		and t.FamilyID = fp.FamilyID
		and t.TagID in (@FamilyTags)
			))
	)
declare @PledgeFundDatesT table (
period varchar(max))
insert into @PledgeFundDatesT 
select distinct 'P-' +convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101) Period
from xrpt.FundPledges_vw f
join @PledgeFundsT pft
on pft.id=f.FundID
Where f.ChurchID = @ChurchID
 and (0 in  (@PledgeFunds)
or f.FundID in (@PledgeFunds))


select * from (
select distinct ChurchID
,FundID
,FamilyID
,PledgeID
,convert(varchar(10),f.DateTo,101) DateTox
,LastFirst
,convert(date,DateFrom,101) DateFrom
,convert(date,DateTo,101) DateTo
    ,[FrequencyID]
     ,[PledgeAmount] PA
      ,[AnnualAmount]
      ,[TotalPledgeAmount]
	, TPNumber=case when FrequencyID in ('ONE','NONE') then 1 else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1) else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1) else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1) else 
	  PledgeAmount end end end end end end
	,TPAmount=case when FrequencyID in ('ONE','NONE') then PledgeAmount else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1)*PledgeAmount else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1)*PledgeAmount else 
	  PledgeAmount end end end end end end 
,LastFirst +' ('+convert(varchar(10),case when FrequencyID in ('ONE','NONE') then PledgeAmount else 
	  case when FrequencyID = 'WK' then (DATEDIFF(WW,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'MO' then (DATEDIFF(MM,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'QTR' then (DATEDIFF(QQ,DateFrom,DateTo)+1)*PledgeAmount else 
	  case when FrequencyID = 'SEMI' then ((DATEDIFF(YY,DateFrom,DateTo)/2)+1)*PledgeAmount else 
	  case when FrequencyID = 'YR' then (DATEDIFF(YY,DateFrom,DateTo)+1)*PledgeAmount else 
	  PledgeAmount end end end end end end ,1)+')' label
from [xrpt].[FundPledges_vw] f
join @PledgeFundDatesT PFDT
on PFDT.period = 'P-' +convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101)
  where f.ChurchID = @ChurchID
and (' All Periods' in (@PledgePeriod)
or 'P-' +convert(varchar(10),DateFrom,101) + ' to ' + convert(varchar(10),DateTo,101) in  (@PledgePeriod))
union all
select 0
,0
,0
,0
,''
,''
,''
,''
,''
,0
,0
,0
,0
,0
,' All Items' label
) txt
order by familyID</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="label">
          <DataField>label</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FundID">
          <DataField>FundID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FamilyID">
          <DataField>FamilyID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="PledgeID">
          <DataField>PledgeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="DateTox">
          <DataField>DateTox</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LastFirst">
          <DataField>LastFirst</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DateFrom">
          <DataField>DateFrom</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="DateTo">
          <DataField>DateTo</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="FrequencyID">
          <DataField>FrequencyID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PA">
          <DataField>PA</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="AnnualAmount">
          <DataField>AnnualAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TotalPledgeAmount">
          <DataField>TotalPledgeAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TPNumber">
          <DataField>TPNumber</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TPAmount">
          <DataField>TPAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="FamilyTags">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT
t.TagID  ,t.TagName
FROM
 xrpt.FamilyTags_vw t
where t.ChurchID = @ChurchID
	and (' All Statuses' in (@Statuses)
	or exists (select 1 from xrpt.FamilyTagMembers_vw ft
		join xrpt.Families_vw f
		on f.ChurchID=ft.ChurchID
		and f.FamilyID=ft.FamilyID
		where ft.ChurchID=t.ChurchID
		and ft.TagID=t.TagID
		and f.StatusCode in (@Statuses))
	)
union all 
select 0, ' All Tags' 
union all 
select 1, ' No Tags'  ) tst
order by TagName</CommandText>
      </Query>
      <Fields>
        <Field Name="TagID">
          <DataField>TagID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="TagName">
          <DataField>TagName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix3">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>7.30837in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>7.72509in</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(Fields!Salutation.Value="",Fields!MailName.Value,Fields!Salutation.Value) &amp; "," 
&amp; "&lt;br&gt;&lt;br&gt;" &amp; Fields!LetterText.Value</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.42292in</Left>
                              <Height>0.32194in</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>
                            <Textbox Name="Letter3">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=Fields!LetterSign.Value</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>4.0093in</Top>
                              <Left>0.42292in</Left>
                              <Height>0.2852in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>1</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>3.31361in</Top>
                              <Left>0.42292in</Left>
                              <Height>0.62624in</Height>
                              <Width>6.62378in</Width>
                              <ZIndex>2</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LetterSignURL.Value="",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Rectangle Name="Rectangle3">
                              <ReportItems>
                                <Textbox Name="Textbox42">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=Fields!FundDescription.Value &amp; " for the period " &amp; Fields!PledgePeriod.Value</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>1.14587in</Top>
                                  <Left>0.22411in</Left>
                                  <Height>0.24056in</Height>
                                  <Width>6.78915in</Width>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox40">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>= "Pledge: "  
&amp; chr(10) &amp; "Payments:  " 
&amp; chr(10) &amp; "Balance Due:   "</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>1.41421in</Top>
                                  <Left>4.75534in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>1.30023in</Width>
                                  <ZIndex>1</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox41">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=format(Sum(Fields!TPAmount.Value), "#,###.00") 
&amp; chr(10) &amp; format(Sum(Fields!GrossAmount.Value), "#,###.00") 
&amp; chr(10) &amp; format(iif((Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)) &lt; 0, 0, Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)), "#,###.00")</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Right</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>1.41421in</Top>
                                  <Left>6.12502in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>0.88824in</Width>
                                  <ZIndex>2</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox45">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=iif(Parameters!SupressFreq.Value=1,"","Frequency: " &amp; 
chr(10) &amp; "Count: " &amp; 
chr(10) &amp; "Payment: ")</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>1.41421in</Top>
                                  <Left>0.22409in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>1.32865in</Width>
                                  <ZIndex>3</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox43">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=iif(Parameters!SupressFreq.Value=1,"",Fields!TFreq.Value 
&amp; chr(10) &amp; format(Fields!TPmtCnt.Value, "#,###") 
&amp; chr(10) &amp; format(Fields!PA.Value, "#,###.00"))</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Right</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>1.41421in</Top>
                                  <Left>1.55274in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>0.91148in</Width>
                                  <ZIndex>4</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox22">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>="Envelope/Budget Number: " &amp; Fields!BudgetNumber.Value &amp; chr(10) &amp; IIf(Fields!MailName.Value = "", Fields!Name.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>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox22</rd:DefaultName>
                                  <Top>1.74308in</Top>
                                  <Left>0.25121in</Left>
                                  <Height>0.71875in</Height>
                                  <Width>2.79582in</Width>
                                  <ZIndex>5</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox24">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>="Statement Date: " &amp; FormatDateTime(Now(),DateFormat.ShortDate) 
&amp; chr(10) &amp; "Parish: " &amp; replace(Fields!ChurchName.Value,"Parish","") 
&amp; chr(10) 
&amp; chr(10) &amp; "Amount Enclosed: _______________"</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox24</rd:DefaultName>
                                  <Top>1.74308in</Top>
                                  <Left>3.96243in</Left>
                                  <Height>0.71875in</Height>
                                  <Width>3.05083in</Width>
                                  <ZIndex>6</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox26">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>="Detach and return this bottom portion with your remittance"</Value>
                                          <Style>
                                            <FontSize>9pt</FontSize>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Center</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox26</rd:DefaultName>
                                  <Top>0.93455in</Top>
                                  <Left>0.90907in</Left>
                                  <Height>0.14188in</Height>
                                  <Width>5.47344in</Width>
                                  <ZIndex>7</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,True,False)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>None</Style>
                                    </Border>
                                    <PaddingLeft>2pt</PaddingLeft>
                                    <PaddingRight>2pt</PaddingRight>
                                    <PaddingTop>2pt</PaddingTop>
                                    <PaddingBottom>2pt</PaddingBottom>
                                  </Style>
                                </Textbox>
                                <Line Name="Line1">
                                  <Top>0.87899in</Top>
                                  <Left>0.13035in</Left>
                                  <Height>0in</Height>
                                  <Width>7.14458in</Width>
                                  <ZIndex>8</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,True,False)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>Dotted</Style>
                                      <Width>3pt</Width>
                                    </Border>
                                  </Style>
                                </Line>
                                <Textbox Name="Textbox38">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=format(Sum(Fields!TPAmount.Value), "#,###.00") &amp; chr(10) &amp; format(Sum(Fields!GrossAmount.Value), "#,###.00") &amp; chr(10) &amp; format(iif((Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)) &lt; 0, 0, Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)), "#,###.00")</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Right</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.40728in</Top>
                                  <Left>6.12502in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>0.88824in</Width>
                                  <ZIndex>9</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox36">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>= "Pledge: "  
&amp; chr(10) &amp; "Payments:  " 
&amp; chr(10) &amp; "Balance Due:   "</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.40728in</Top>
                                  <Left>4.75534in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>1.30023in</Width>
                                  <ZIndex>10</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox37">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=Fields!FundDescription.Value &amp; " for the period " &amp; Fields!PledgePeriod.Value</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.16671in</Top>
                                  <Left>0.22409in</Left>
                                  <Height>0.1989in</Height>
                                  <Width>6.78917in</Width>
                                  <ZIndex>11</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox39">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=iif(Parameters!SupressFreq.Value=1,"",Fields!TFreq.Value 
&amp; chr(10) &amp; format(Fields!TPmtCnt.Value, "#,###") 
&amp; chr(10) &amp; format(Fields!PA.Value, "#,###.00"))</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Right</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.40728in</Top>
                                  <Left>1.57986in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>0.91148in</Width>
                                  <ZIndex>12</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox44">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=iif(Parameters!SupressFreq.Value=1,"","Frequency: " &amp; 
chr(10) &amp; "Count: " &amp; 
chr(10) &amp; "Payment: ")</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style />
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.40728in</Top>
                                  <Left>0.25121in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>1.32865in</Width>
                                  <ZIndex>13</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,True,False)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>None</Style>
                                    </Border>
                                    <PaddingLeft>2pt</PaddingLeft>
                                    <PaddingRight>2pt</PaddingRight>
                                    <PaddingTop>2pt</PaddingTop>
                                    <PaddingBottom>2pt</PaddingBottom>
                                  </Style>
                                </Textbox>
                                <Tablix Name="Tablix1">
                                  <TablixBody>
                                    <TablixColumns>
                                      <TablixColumn>
                                        <Width>1.1471in</Width>
                                      </TablixColumn>
                                      <TablixColumn>
                                        <Width>0.81249in</Width>
                                      </TablixColumn>
                                      <TablixColumn>
                                        <Width>0.74015in</Width>
                                      </TablixColumn>
                                      <TablixColumn>
                                        <Width>0.75033in</Width>
                                      </TablixColumn>
                                    </TablixColumns>
                                    <TablixRows>
                                      <TablixRow>
                                        <Height>0.33333in</Height>
                                        <TablixCells>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox25">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>Date</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>9pt</FontSize>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox25</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox5">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value EvaluationMode="Constant">Pmt Due</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>9pt</FontSize>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox5</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox10">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value EvaluationMode="Constant">Applied</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>9pt</FontSize>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox10</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox13">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>Balance</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>9pt</FontSize>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox13</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                        </TablixCells>
                                      </TablixRow>
                                      <TablixRow>
                                        <Height>0.15in</Height>
                                        <TablixCells>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="TransactionDate">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Fields!TransactionDate.Value &amp; iif(len(Fields!Comment.Value) &gt; 0, chr(10) &amp; Fields!Comment.Value, "")</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <Format>MM/dd/yyyy</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>TransactionDate</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="GrossAmount">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Fields!PmtDue.Value</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <Format>#,0.00;(#,0.00)</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>GrossAmount</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="PmtDue">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Fields!GrossAmount.Value</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <Format>#,0.00;(#,0.00)</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>PmtDue</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox15">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=RunningValue(Fields!PmtDue.Value - iif(Fields!Reference.Value &lt;&gt; "{exclude}", Fields!GrossAmount.Value, 0), Sum,"Details2" )</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <Format>#,0.00;(#,0.00)</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox15</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                        </TablixCells>
                                      </TablixRow>
                                      <TablixRow>
                                        <Height>0.21875in</Height>
                                        <TablixCells>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox29">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>Total:</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <FontWeight>Bold</FontWeight>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox29</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <TopBorder>
                                                    <Color>LightGrey</Color>
                                                  </TopBorder>
                                                  <BottomBorder>
                                                    <Color>LightGrey</Color>
                                                  </BottomBorder>
                                                  <LeftBorder>
                                                    <Color>LightGrey</Color>
                                                  </LeftBorder>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <VerticalAlign>Bottom</VerticalAlign>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox30">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Sum(Fields!PmtDue.Value)</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <FontWeight>Bold</FontWeight>
                                                          <Format>#,0.00;(#,0.00)</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox30</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <VerticalAlign>Bottom</VerticalAlign>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox12">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Sum(Fields!GrossAmount.Value)</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <FontWeight>Bold</FontWeight>
                                                          <Format>#,0.00;(#,0.00)</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox12</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <VerticalAlign>Bottom</VerticalAlign>
                                                  <PaddingLeft>2pt</PaddingLeft>
                                                  <PaddingRight>2pt</PaddingRight>
                                                  <PaddingTop>2pt</PaddingTop>
                                                  <PaddingBottom>2pt</PaddingBottom>
                                                </Style>
                                              </Textbox>
                                            </CellContents>
                                          </TablixCell>
                                          <TablixCell>
                                            <CellContents>
                                              <Textbox Name="Textbox16">
                                                <CanGrow>true</CanGrow>
                                                <KeepTogether>true</KeepTogether>
                                                <Paragraphs>
                                                  <Paragraph>
                                                    <TextRuns>
                                                      <TextRun>
                                                        <Value>=Sum(Fields!PmtDue.Value)-Sum(Fields!GrossAmount.Value)</Value>
                                                        <Style>
                                                          <FontFamily>Courier New</FontFamily>
                                                          <FontSize>8pt</FontSize>
                                                          <FontWeight>Bold</FontWeight>
                                                          <Format>n2</Format>
                                                        </Style>
                                                      </TextRun>
                                                    </TextRuns>
                                                    <Style>
                                                      <TextAlign>Right</TextAlign>
                                                    </Style>
                                                  </Paragraph>
                                                </Paragraphs>
                                                <rd:DefaultName>Textbox16</rd:DefaultName>
                                                <Style>
                                                  <Border>
                                                    <Color>LightGrey</Color>
                                                    <Style>Solid</Style>
                                                  </Border>
                                                  <BackgroundColor>LightGrey</BackgroundColor>
                                                  <VerticalAlign>Bottom</VerticalAlign>
                                                  <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 />
                                      <TablixMember />
                                    </TablixMembers>
                                  </TablixColumnHierarchy>
                                  <TablixRowHierarchy>
                                    <TablixMembers>
                                      <TablixMember>
                                        <TablixHeader>
                                          <Size>3.82486in</Size>
                                          <CellContents>
                                            <Textbox Name="Textbox14">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value>=Fields!FundDescription.Value &amp; chr(10) &amp; "Pledge Period " &amp; Fields!PledgePeriod.Value</Value>
                                                      <Style>
                                                        <FontFamily>Courier New</FontFamily>
                                                        <FontSize>9pt</FontSize>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style />
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>Textbox14</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Color>LightGrey</Color>
                                                  <Style>Solid</Style>
                                                </Border>
                                                <BackgroundColor>LightGrey</BackgroundColor>
                                                <PaddingLeft>2pt</PaddingLeft>
                                                <PaddingRight>2pt</PaddingRight>
                                                <PaddingTop>2pt</PaddingTop>
                                                <PaddingBottom>2pt</PaddingBottom>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                        <TablixMembers>
                                          <TablixMember />
                                        </TablixMembers>
                                        <KeepWithGroup>After</KeepWithGroup>
                                      </TablixMember>
                                      <TablixMember>
                                        <Group Name="FundDescription">
                                          <GroupExpressions>
                                            <GroupExpression>=Fields!FundDescription.Value</GroupExpression>
                                          </GroupExpressions>
                                        </Group>
                                        <SortExpressions>
                                          <SortExpression>
                                            <Value>=Fields!FundDescription.Value</Value>
                                          </SortExpression>
                                        </SortExpressions>
                                        <TablixHeader>
                                          <Size>1.96533in</Size>
                                          <CellContents>
                                            <Textbox Name="FundDescription">
                                              <CanGrow>true</CanGrow>
                                              <KeepTogether>true</KeepTogether>
                                              <Paragraphs>
                                                <Paragraph>
                                                  <TextRuns>
                                                    <TextRun>
                                                      <Value>="Budget Number: " &amp; Fields!BudgetNumber.Value &amp; chr(10) &amp; chr(10) &amp; IIf(Fields!MailName.Value = "", Fields!Name.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>Courier New</FontFamily>
                                                        <FontSize>8pt</FontSize>
                                                      </Style>
                                                    </TextRun>
                                                  </TextRuns>
                                                  <Style />
                                                </Paragraph>
                                              </Paragraphs>
                                              <rd:DefaultName>FundDescription</rd:DefaultName>
                                              <Style>
                                                <Border>
                                                  <Color>LightGrey</Color>
                                                  <Style>Solid</Style>
                                                </Border>
                                              </Style>
                                            </Textbox>
                                          </CellContents>
                                        </TablixHeader>
                                        <TablixMembers>
                                          <TablixMember>
                                            <Group Name="PledgePeriod2">
                                              <GroupExpressions>
                                                <GroupExpression>=Fields!PledgePeriod.Value</GroupExpression>
                                              </GroupExpressions>
                                            </Group>
                                            <SortExpressions>
                                              <SortExpression>
                                                <Value>=Fields!PledgePeriod.Value</Value>
                                              </SortExpression>
                                            </SortExpressions>
                                            <TablixHeader>
                                              <Size>1.85953in</Size>
                                              <CellContents>
                                                <Textbox Name="PledgePeriod">
                                                  <CanGrow>true</CanGrow>
                                                  <KeepTogether>true</KeepTogether>
                                                  <Paragraphs>
                                                    <Paragraph>
                                                      <TextRuns>
                                                        <TextRun>
                                                          <Value>= "Frequency: " &amp; Fields!TFreq.Value 
&amp; chr(10) &amp; "Payment: " &amp; format(Fields!PA.Value ,"#,###.00") 
&amp; chr(10) &amp; "Total Pledge: " &amp; format(Sum(Fields!TPAmount.Value), "###,###.00") 
&amp; chr(10) &amp; "Applied:   " &amp; format(Sum(Fields!GrossAmount.Value), "###,###.00") 
&amp; chr(10) &amp; "Total Due:    " &amp; format(iif((Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)) &lt; 0, 0, Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)), "###,###.00")</Value>
                                                          <Style>
                                                            <FontFamily>Courier New</FontFamily>
                                                            <FontSize>8pt</FontSize>
                                                          </Style>
                                                        </TextRun>
                                                      </TextRuns>
                                                      <Style>
                                                        <TextAlign>Right</TextAlign>
                                                      </Style>
                                                    </Paragraph>
                                                  </Paragraphs>
                                                  <rd:DefaultName>PledgePeriod</rd:DefaultName>
                                                  <Style>
                                                    <Border>
                                                      <Color>LightGrey</Color>
                                                      <Style>Solid</Style>
                                                    </Border>
                                                  </Style>
                                                </Textbox>
                                              </CellContents>
                                            </TablixHeader>
                                            <TablixMembers>
                                              <TablixMember>
                                                <Group Name="Details2" />
                                                <SortExpressions>
                                                  <SortExpression>
                                                    <Value>=Fields!LastFirst.Value</Value>
                                                  </SortExpression>
                                                  <SortExpression>
                                                    <Value>=Fields!TransactionDate.Value</Value>
                                                  </SortExpression>
                                                </SortExpressions>
                                                <Visibility>
                                                  <Hidden>=iif(Fields!GrossAmount.Value + Fields!PmtDue.Value = 0, True, False)</Hidden>
                                                </Visibility>
                                              </TablixMember>
                                              <TablixMember>
                                                <KeepWithGroup>Before</KeepWithGroup>
                                              </TablixMember>
                                            </TablixMembers>
                                          </TablixMember>
                                        </TablixMembers>
                                      </TablixMember>
                                    </TablixMembers>
                                  </TablixRowHierarchy>
                                  <DataSetName>cDetails</DataSetName>
                                  <PageBreak>
                                    <BreakLocation>Start</BreakLocation>
                                  </PageBreak>
                                  <Top>2.58683in</Top>
                                  <Height>0.70208in</Height>
                                  <Width>7.27493in</Width>
                                  <ZIndex>14</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value=1,False,True)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>None</Style>
                                    </Border>
                                  </Style>
                                </Tablix>
                                <Textbox Name="Textbox51">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>=format(Sum(Fields!TPAmount.Value), "#,###.00") &amp; chr(10) &amp; format(Sum(Fields!GrossAmount.Value), "#,###.00") &amp; chr(10) &amp; format(iif((Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)) &lt; 0, 0, Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)), "#,###.00")</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Right</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.16671in</Top>
                                  <Left>4.53078in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>0.88824in</Width>
                                  <ZIndex>15</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,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="Textbox52">
                                  <CanGrow>true</CanGrow>
                                  <KeepTogether>true</KeepTogether>
                                  <Paragraphs>
                                    <Paragraph>
                                      <TextRuns>
                                        <TextRun>
                                          <Value>= "Total Pledged: "  
&amp; chr(10) &amp; "Total Paid as of " &amp; FormatDateTime(Parameters!ThruDate.Value,DateFormat.ShortDate) &amp; ":  " 
&amp; chr(10) &amp; "Current Balance:   "</Value>
                                          <Style>
                                            <FontFamily>Courier New</FontFamily>
                                          </Style>
                                        </TextRun>
                                      </TextRuns>
                                      <Style>
                                        <TextAlign>Left</TextAlign>
                                      </Style>
                                    </Paragraph>
                                  </Paragraphs>
                                  <rd:DefaultName>Textbox36</rd:DefaultName>
                                  <Top>0.16671in</Top>
                                  <Left>1.85592in</Left>
                                  <Height>0.27332in</Height>
                                  <Width>2.60541in</Width>
                                  <ZIndex>16</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3,false,true)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>None</Style>
                                    </Border>
                                    <PaddingLeft>2pt</PaddingLeft>
                                    <PaddingRight>2pt</PaddingRight>
                                    <PaddingTop>2pt</PaddingTop>
                                    <PaddingBottom>2pt</PaddingBottom>
                                  </Style>
                                </Textbox>
                                <Line Name="Line2">
                                  <Top>0.09727in</Top>
                                  <Left>0.06518in</Left>
                                  <Height>0in</Height>
                                  <Width>7.14458in</Width>
                                  <ZIndex>17</ZIndex>
                                  <Visibility>
                                    <Hidden>=iif(Parameters!Details.Value = 3, False,True)</Hidden>
                                  </Visibility>
                                  <Style>
                                    <Border>
                                      <Style>Dotted</Style>
                                      <Width>3pt</Width>
                                    </Border>
                                  </Style>
                                </Line>
                              </ReportItems>
                              <Top>4.35006in</Top>
                              <Left>0.03344in</Left>
                              <Height>3.37503in</Height>
                              <Width>7.27493in</Width>
                              <ZIndex>3</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Rectangle>
                            <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.32869in</Top>
                              <Left>4.18337in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>4</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!Name.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!Name.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!Name.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.32869in</Top>
                              <Left>0.42292in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.43001in</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="LogoWide">
                              <Source>External</Source>
                              <Value>=Fields!Logo.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>0.09863in</Top>
                              <Left>0.42292in</Left>
                              <Height>1.08228in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>6</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.09863in</Top>
                              <Left>4.89403in</Left>
                              <Height>2.31374in</Height>
                              <Width>2.41434in</Width>
                              <ZIndex>7</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.09863in</Top>
                              <Left>0.42292in</Left>
                              <Height>0.97951in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>8</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">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>="EMAIL:" &amp; iif(str(Fields!EmailAlerts.Value)=TRUE, Fields!EmailAddress.Value,"")</Value>
                                      <Style>
                                        <FontSize>8pt</FontSize>
                                        <Color>White</Color>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>EmailAddress</rd:DefaultName>
                              <Top>0.00975in</Top>
                              <Left>0.42292in</Left>
                              <Height>0.07499in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>9</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!LastFirst.Value,Fields!ZipCode.Value+Fields!LastFirst.Value)</Value>
                    </SortExpression>
                  </SortExpressions>
                  <Visibility>
                    <Hidden>=iif(((Sum(Fields!TPAmount.Value) - Sum(Fields!GrossAmount.Value)) &lt;= 0) and Parameters!ZeroDue.Value = 0,True,False)</Hidden>
                  </Visibility>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>Details</DataSetName>
            <Height>7.72509in</Height>
            <Width>7.30837in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>7.72509in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>7.30837in</Width>
      <Page>
        <LeftMargin>0.5in</LeftMargin>
        <RightMargin>0.5in</RightMargin>
        <TopMargin>0.125in</TopMargin>
        <BottomMargin>0.125in</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="FamilyTags">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Family Tags</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>FamilyTags</DataSetName>
          <ValueField>TagID</ValueField>
          <LabelField>TagName</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="PledgeFunds">
      <DataType>Integer</DataType>
      <Prompt>Select Fund</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>PledgeFunds</DataSetName>
          <ValueField>fundid</ValueField>
          <LabelField>FundDescription</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="PledgePeriod">
      <DataType>String</DataType>
      <Prompt>Select Pledge Periods</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>PledgePeriod</DataSetName>
          <ValueField>Period</ValueField>
          <LabelField>Period</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Pledges">
      <DataType>Integer</DataType>
      <Prompt>Select Donor(s)</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Pledges</DataSetName>
          <ValueField>PledgeID</ValueField>
          <LabelField>label</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="ZeroDue">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Include Fully Paid?</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>No</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Yes</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="ThruDate">
      <DataType>DateTime</DataType>
      <Prompt>Transactions Through</Prompt>
    </ReportParameter>
    <ReportParameter Name="Details">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Letter Format</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Standard with Details Page</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Standard Suppress Details</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>3</Value>
            <Label>Compact Format</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Comments">
      <DataType>Boolean</DataType>
      <DefaultValue>
        <Values>
          <Value>false</Value>
        </Values>
      </DefaultValue>
      <Prompt>Include comments with details?</Prompt>
    </ReportParameter>
    <ReportParameter Name="SupressFreq">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Supress Frequency Info</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>No</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Yes</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </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>String</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>7</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>FamilyTags</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>PledgeFunds</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>PledgePeriod</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Pledges</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>ZeroDue</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>ThruDate</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Details</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Comments</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>SupressFreq</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>Date</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>Address</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>AddressCase</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>FO</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Sort</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>Font</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>FontSize</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>72829793-6244-472b-b4c1-dd9b28fc0ea1</rd:ReportID>
</Report>