﻿<?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
  convert(varchar(10),ChurchID) ChurchID
  ,ChurchName + ' - ' +City ChurchName
FROM
  xrpt.Churches_vw 
order by ChurchName+ ' - ' +City</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="cDetails">
      <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>
          <QueryParameter Name="@Pledges">
            <Value>=Parameters!Pledges.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CurrentUser">
            <Value>=Parameters!CurrentUser.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
,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
,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) else 
		  case when FrequencyID = 'MO' then DATEDIFF(MM,DateFrom,DateTo) else 
		  case when FrequencyID = 'QTR' then DATEDIFF(QQ,DateFrom,DateTo) else 
		  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,DateFrom,DateTo)/2) else 
		  case when FrequencyID = 'YR' then DATEDIFF(YY,DateFrom,DateTo) 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)*PledgeAmount else 
		  case when FrequencyID = 'MO' then DATEDIFF(MM,DateFrom,DateTo)*PledgeAmount else 
		  case when FrequencyID = 'QTR' then DATEDIFF(QQ,DateFrom,DateTo)*PledgeAmount else 
		  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,DateFrom,DateTo)/2)*PledgeAmount else 
		  case when FrequencyID = 'YR' then DATEDIFF(YY,DateFrom,DateTo)*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)*f.PledgeAmount else 
	  case when FrequencyID = 'MO' then DATEDIFF(MM,f.DateFrom,DateTo)*f.PledgeAmount else 
	  case when FrequencyID = 'QTR' then DATEDIFF(QQ,f.DateFrom,DateTo)*f.PledgeAmount else 
	  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,f.DateFrom,DateTo)/2)*f.PledgeAmount else 
	  case when FrequencyID = 'YR' then DATEDIFF(YY,f.DateFrom,DateTo)*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)*f.PledgeAmount else 
	  case when FrequencyID = 'MO' then DATEDIFF(MM,f.DateFrom,DateTo)*f.PledgeAmount else 
	  case when FrequencyID = 'QTR' then DATEDIFF(QQ,f.DateFrom,DateTo)*f.PledgeAmount else 
	  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,f.DateFrom,DateTo)/2)*f.PledgeAmount else 
	  case when FrequencyID = 'YR' then DATEDIFF(YY,f.DateFrom,DateTo)*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 &lt; dateadd(dd,1,p.DateTo)
		)
	)


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) else 
	  case when FrequencyID = 'MO' then DATEDIFF(MM,DateFrom,DateTo) else 
	  case when FrequencyID = 'QTR' then DATEDIFF(QQ,DateFrom,DateTo) else 
	  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,DateFrom,DateTo)/2) else 
	  case when FrequencyID = 'YR' then DATEDIFF(YY,DateFrom,DateTo) 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)*PledgeAmount else 
	  case when FrequencyID = 'MO' then DATEDIFF(MM,DateFrom,DateTo)*PledgeAmount else 
	  case when FrequencyID = 'QTR' then DATEDIFF(QQ,DateFrom,DateTo)*PledgeAmount else 
	  case when FrequencyID = 'SEMI' then (DATEDIFF(YY,DateFrom,DateTo)/2)*PledgeAmount else 
	  case when FrequencyID = 'YR' then DATEDIFF(YY,DateFrom,DateTo)*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="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="StatusCode">
          <DataField>StatusCode</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="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="Salutation">
          <DataField>Salutation</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="Addr2">
          <DataField>Addr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ZipCode">
          <DataField>ZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAlerts">
          <DataField>EmailAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="FundID">
          <DataField>FundID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FundDescription">
          <DataField>FundDescription</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TransactionDate">
          <DataField>TransactionDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="GrossAmount">
          <DataField>GrossAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="cYYYY">
          <DataField>cYYYY</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="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="TPNumber">
          <DataField>TPNumber</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="Comment">
          <DataField>Comment</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Reference">
          <DataField>Reference</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="TPAmount">
          <DataField>TPAmount</DataField>
          <rd:TypeName>System.Decimal</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="PledgePeriod">
          <DataField>PledgePeriod</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PmtDue">
          <DataField>PmtDue</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</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="CState">
          <DataField>CState</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="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="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="@PledgeFunds">
            <Value>=Parameters!PledgeFunds.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@PledgePeriod">
            <Value>=Parameters!PledgePeriod.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.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="FamilyID">
          <DataField>FamilyID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="FundID">
          <DataField>FundID</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="label">
          <DataField>label</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AnnualAmount">
          <DataField>AnnualAmount</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TPNumber">
          <DataField>TPNumber</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="TotalPledgeAmount">
          <DataField>TotalPledgeAmount</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="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="PledgeFundDates">
      <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="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>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </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>
    <DataSet Name="SelectedChurch">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
xrpt.churches_vw where ChurchID = @ChurchID

Select Funds = STUFF((SELECT distinct ', ' + isnull(t.ChurchName ,'')
FROM (Select ChurchName from 
xrpt.churches_vw where ChurchID = @ChurchID) t
FOR XML PATH ('')), 1, 1, '')</CommandText>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr1">
          <DataField>Addr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr2">
          <DataField>Addr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="City">
          <DataField>City</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="State">
          <DataField>State</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ZipCode">
          <DataField>ZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Country">
          <DataField>Country</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PhoneNumber">
          <DataField>PhoneNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FaxNumber">
          <DataField>FaxNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Website">
          <DataField>Website</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="RETeacherCommitteeID">
          <DataField>RETeacherCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="RETeacherCommitteeName">
          <DataField>RETeacherCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REAideCommitteeID">
          <DataField>REAideCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="REAideCommitteeName">
          <DataField>REAideCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REStudentCommitteeID">
          <DataField>REStudentCommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="REStudentCommitteeName">
          <DataField>REStudentCommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="REEmailAddress">
          <DataField>REEmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DeaneryID">
          <DataField>DeaneryID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="DeaneryName">
          <DataField>DeaneryName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AllServicePref">
          <DataField>AllServicePref</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="ParishCode">
          <DataField>ParishCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="OrganizationID">
          <DataField>OrganizationID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="YearFounded">
          <DataField>YearFounded</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="EmployerID">
          <DataField>EmployerID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EthnicAffiliation">
          <DataField>EthnicAffiliation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="County">
          <DataField>County</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Cemetery">
          <DataField>Cemetery</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="DioceseInitials">
          <DataField>DioceseInitials</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Attn">
          <DataField>Attn</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="AttnTitle">
          <DataField>AttnTitle</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ServiceReminder">
          <DataField>ServiceReminder</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="MinimumControlTypeID">
          <DataField>MinimumControlTypeID</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ModifiedDate">
          <DataField>ModifiedDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="ModifiedBy">
          <DataField>ModifiedBy</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="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
union all
select ' All Statuses')tst
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>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix1">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>0.55833in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.6in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>2.275in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.81667in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.45833in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>1.75in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>1in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.91667in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.425in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.275in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.54167in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.725in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.71667in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.78333in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.89167in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.75in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.86667in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>1in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.75in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>3.16667in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.25in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox4">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Family ID</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox4</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <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>Budget Number</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox10</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox6">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Last First</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox6</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox8">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Status Code</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox8</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <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>Fund ID</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox16</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox14">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Fund Description</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox14</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox24">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Pledge Period</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox24</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox22">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Transaction Date</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox22</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox18">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>YYYY</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox18</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox20">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>MM</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox20</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox26">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Pledge ID</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox26</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox32">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Frequency</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox32</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox28">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Pledge</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox28</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <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>Annual</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox30</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox34">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Total Pledge</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox34</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox98">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>TPNumber</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox98</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox100">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>TPAmount</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox100</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox1">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Pmt Due</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox1</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox38">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Gross Amount</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox38</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox36">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Comment</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox36</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>0.25in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FamilyID">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FamilyID.Value</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FamilyID</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="BudgetNumber">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!BudgetNumber.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>BudgetNumber</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="LastFirst">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!LastFirst.Value</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>LastFirst</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="StatusCode">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!StatusCode.Value</Value>
                                  <Style />
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>StatusCode</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FundID">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FundID.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FundID</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FundDescription">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FundDescription.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FundDescription</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="PledgePeriod">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!PledgePeriod.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>PledgePeriod</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="TransactionDate">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!TransactionDate.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>MM/dd/yyyy</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>TransactionDate</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="cYYYY">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!cYYYY.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>cYYYY</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="cMM">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!cMM.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>cMM</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="PledgeID">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!PledgeID.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>PledgeID</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FrequencyID">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FrequencyID.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FrequencyID</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="PledgeAmount">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!PledgeAmount.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0.00;(#,0.00)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>PledgeAmount</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="AnnualAmount">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!AnnualAmount.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0.00;(#,0.00)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>AnnualAmount</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="TotalPledgeAmount">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!TotalPledgeAmount.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0.00;(#,0.00)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>TotalPledgeAmount</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="TPNumber">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!TPNumber.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0;(#,0)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>TPNumber</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="TPAmount">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!TPAmount.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0.00;(#,0.00)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>TPAmount</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="PmtDue">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!PmtDue.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>PmtDue</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="GrossAmount">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!GrossAmount.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                    <Format>#,0.00;(#,0.00)</Format>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>GrossAmount</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Comment">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!Comment.Value</Value>
                                  <Style>
                                    <FontFamily>Arial</FontFamily>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style />
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Comment</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                              <Style>Solid</Style>
                            </Border>
                            <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 />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember />
                <TablixMember>
                  <Group Name="Details" />
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>cDetails</DataSetName>
            <Height>0.5in</Height>
            <Width>19.26668in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>0.5in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>19.26668in</Width>
      <Page>
        <LeftMargin>0.5in</LeftMargin>
        <RightMargin>0.5in</RightMargin>
        <TopMargin>0.5in</TopMargin>
        <BottomMargin>0.5in</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>String</DataType>
      <Prompt>Church</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</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>String</DataType>
      <Prompt>Family Tags</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>FamilyTags</DataSetName>
          <ValueField>TagID</ValueField>
          <LabelField>TagName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="PledgeFunds">
      <DataType>Integer</DataType>
      <Prompt>Select Fund</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>PledgeFunds</DataSetName>
          <ValueField>fundid</ValueField>
          <LabelField>FundDescription</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="PledgePeriod">
      <DataType>String</DataType>
      <Prompt>Pledge Period</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>PledgeFundDates</DataSetName>
          <ValueField>Period</ValueField>
          <LabelField>Period</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Pledges">
      <DataType>Integer</DataType>
      <Prompt>Select Donor</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Pledges</DataSetName>
          <ValueField>PledgeID</ValueField>
          <LabelField>label</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>3</NumberOfColumns>
      <NumberOfRows>5</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>CurrentUser</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ChurchID</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>Statuses</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>FamilyTags</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>PledgeFunds</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>PledgePeriod</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Pledges</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>72829793-6244-472b-b4c1-dd9b28fc0ea1</rd:ReportID>
</Report>