﻿<?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:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily">
  <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="AOC">
      <DataSourceReference>AOCds</DataSourceReference>
      <rd:SecurityType>DataBase</rd:SecurityType>
      <rd:DataSourceID>c5ba2cd7-0b75-42c4-bb59-9c110d202be0</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>SELECT
  ChurchID
  ,ChurchName + ' - ' +City ChurchName
FROM
  xrpt.Churches_vw 
order by ChurchName</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="FamilyTags">
      <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="@Registered">
            <Value>=Parameters!Registered.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@RD1">
            <Value>=Parameters!RD1.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@RD2">
            <Value>=Parameters!RD2.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT
t.TagID  ,t.TagName
FROM xrpt.FamilyTags_vw t
where ChurchID = @ChurchID
	and exists (select 1 from xrpt.FamilyTagMembers_vw ft
		join xrpt.Families_vw f
		on f.ChurchID=ft.ChurchID
		and f.FamilyID=ft.FamilyID
		and ft.tagid=t.tagid
		and ((@Registered = 0)
			or (@Registered = 1 and f.IsRegistered = 'Y' )
			or (@Registered = 2  and (f.RegistrationDate &gt;= @RD1 and f.RegistrationDate  &lt;=@RD2))) 
		and (' All Statuses' in (@Statuses)
			or 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="Statuses">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT distinct 
StatusCode
FROM xrpt.Families_vw 
where ChurchID = @ChurchID
and statuscode is not null
and statuscode &lt;&gt;'deleted'
union all
select ' All Statuses') TEST
order by StatusCode</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Families">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Registered">
            <Value>=Parameters!Registered.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ForM">
            <Value>=Parameters!ForM.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@RD1">
            <Value>=Parameters!RD1.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@RD2">
            <Value>=Parameters!RD2.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FForm">
            <Value>=Parameters!FForm.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Address">
            <Value>=Parameters!Address.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Committees">
            <Value>=Parameters!Committees.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--Created for the Archdiocese of Cincinnati 
--bmaly@catholicaoc.org
--Create Date 2021.10.14

Declare @ChurchData Table
(ChurchID int
,Logo  nvarchar(200)
,LogoOrientation nvarchar(200)
,LetterText nvarchar(4000)
,LetterSign nvarchar(200)
,LetterSignURL nvarchar(200)
,ChurchName nvarchar(200)
,ChurchCity nvarchar(200)
,CAddr1 nvarchar(200)
,CAddr2 nvarchar(200)
,CCity nvarchar(200)
,CState nvarchar(200)
,CZipCode nvarchar(200)
,CphoneNumber  nvarchar(200))
insert into @ChurchData
SELECT CV.ChurchID
,Logo=isnull((select top 1 replace(note,'LogoURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'Merge, '+@FForm
	and note like 'LogoURL:%'),(select top 1 replace(note,'LogoURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.FamilyLastFirst = 'ADMIN'
	and memberid is null
	and note like 'LogoURL:%'))
,LogoOrientation=isnull((select top 1 replace(note,'LogoOrientation:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'Merge, '+@FForm
	and note like 'Logo:%'),(select top 1 replace(note,'LogoOrientation:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.FamilyLastFirst = 'ADMIN'
	and memberid is null
	and note like 'LogoOrientation:%'))
,LetterText='&lt;p&gt;'+replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace((select top 1 replace(note,'Text:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'Merge, '+@FForm
	and note like 'Text:%'),char(13),'&lt;br&gt;'),'/','&lt;br&gt;'),'~I','&lt;i&gt;'),'!I','&lt;/i&gt;'),'~B','&lt;b&gt;'),'!B','&lt;/b&gt;'),'~U','&lt;u&gt;'),'!U','&lt;/u&gt;'),'~C','&lt;p style="text-align:center"&gt;'),'!C','&lt;/p&gt;'),char(9),'&amp;emsp;')+'&lt;/p&gt;'
,LetterSign=(select top 1 replace(note,'SIGN:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'Merge, '+@FForm
	and note like 'Sign:%')
,LetterSignURL=(select top 1 replace(note,'SIGNURL:','')  from xrpt.FamilyNotes_vw fn
	join xrpt.families_vw f on f.familyid=fn.familyid and f.statuscode&lt;&gt;'DELETED'
	where fn.ChurchID =CV.ChurchID
	and fn.ContactType = 'Other'
	and fn.MemberLastFirst = 'Merge, '+@FForm
	and note like 'SignURL:%')
,replace(CV.ChurchName,' Parish','')  ChurchName
,CV.ChurchName +' , '+ CV.City  ChurchCity
,CV.Addr1 CAddr1
,isnull(CV.Addr2,'') CAddr2
,CV.City CCity
,CV.State CState
,CV.ZipCode CZipCode
,CV.PhoneNumber CPhoneNumber
from xrpt.churches_vw CV where Churchid = @ChurchID


select distinct FData.*,CV.* from (
SELECT  f.familyid
  --,convert(int,case when replace(f.budgetnumber,' ','') like  '%[a-z]%' then 0 else replace(f.budgetnumber,' ','') end) BudgetNumber
  ,f.BudgetNumber
  ,F.HasEnvelopes
,f.BudgetNumberInactive
,convert(varchar(12),f.registrationdate ,101) RegistrationDate
--,RegisteredChurches = stuff((Select '~'+rc.ChurchName+'-'+c.City+'-'+rc.StatusCode+'-'+convert(varchar(10),RegistrationDate,101) 
--		from xrpt.families_vw rc
--		join xrpt.churches_vw c on rc.ChurchID=c.ChurchID 
--		where rc.FamilyID=f.FamilyID
--		and rc.churchid &lt;&gt; @ChurchID
--				 FOR XML PATH ('')), 1, 1, '') 
,f.IsRegistered
  ,case when @ForM=0 then f.Salutation  else isnull(m.Salutation,m.FirstName) end Salutation
,case when @ForM=0 then f.MailName else m.FirstName+' ' +m.LastName end MailName
,case when @ForM=0 then f.FirstName else m.FirstName+' ' +m.LastName end FirstName
  ,f.LastName
  ,case when @Address = 0 then ml.Addr1 else  f.Addr1 end Addr1
  ,isnull(case when @Address = 0 then ml.Addr2 else  f.Addr2 end, '') Addr2
  ,case when @Address = 0 then ml.City else  f.City end City
  ,case when @Address = 0 then ml.[State] else  f.[State] end [State]
  ,case when @Address = 0 then ml.ZipCode else  f.ZipCode end ZipCode
  ,F.PhoneNumber
  ,F.PhoneSmsAlerts
  ,F.PhoneVoiceAlerts
  ,F.PhoneUnlisted
  ,case when @ForM=0 then F.EmailAddress  else isnull(m.EmailAddress,F.EmailAddress) end EmailAddress
  ,F.EmailAlerts 
 --,MemberEmails = isnull(STUFF((SELECT  ';' + isnull(m.EmailAddress,'')
--				FROM xrpt.Members_vw m
--				join xrpt.Families_vw f3 
--				on m.churchid = @ChurchID
--				and m.FamilyID = f3.FamilyID
--				WHERE  m.FamilyID = f.FamilyID
--				and isnull(m.EmailAddress,'') &lt;&gt;''
--				order by birthdate
--				 FOR XML PATH ('')
--				 ), 1, 1, '') ,'')
  ,F.StatusCode
  ,F.StatusDate
-- ,F.Notes
-- ,Tags = isnull(STUFF((SELECT distinct '~' + isnull(t.TagName ,'')
--				FROM xrpt.FamilyTagMembers_vw t
--				join xrpt.Families_vw f2 
--				on t.churchid  = @ChurchID 
--				and t.FamilyID = f2.FamilyID
--				 WHERE  f2.FamilyID = f.FamilyID
--				 FOR XML PATH ('')), 1, 1, '') ,'')
--  ,Members =  isnull(STUFF((SELECT  '~' + m.LastName+isnull('('+m.MaidenName+')','')+','+m.FirstName
--		+isnull(':b-'+convert(varchar(12),m.BirthDate ,101),'')
--		+isnull(':d-'+convert(varchar(12),m.DeceasedDate ,101),'')
--		+isnull(':e-'+m.EmailAddress+')','')
--		+isnull(':p-'+m.PhoneNumber+')','')
--				FROM xrpt.Members_vw m
--				join xrpt.Families_vw f3 
--				on m.churchid = @ChurchID
--				and m.FamilyID = f3.FamilyID
--				 WHERE  m.FamilyID = f.FamilyID order by birthdate
--				 FOR XML PATH ('')
--				 ), 1, 1, '') ,'No Members') 
--  ,PRM =
--STUFF((SELECT distinct '~' + isnull(convert(varchar(10),n.contactdate,101),'')
--		+isnull(':t-'+n.contacttype,'')
--		+isnull(':Member-'+n.MemberLastFirst,'')
--		+isnull(':pvt-'+case when n.IsPrivate = 1 then 'Yes' else 'No' end,'')
--		+isnull(':note-'+n.Note,'')
--		+isnull(':Follow-up-'+convert(varchar(10),n.followupdate,102),'')
--		+isnull(':UID-'+n.ModifiedBy,'')
--				FROM xrpt.FamilyNotes_vw n
--				join xrpt.Families_vw f4 
--				on n.churchid  = @ChurchID 
--				and n.FamilyID = f4.FamilyID
--				 WHERE  f4.FamilyID = f.FamilyID 
--				 FOR XML PATH ('')), 1, 1, '') 
FROM xrpt.Families_vw f
left join xrpt.Members_vw m --&gt; okay
	on m.ChurchID = f.ChurchID 
	and m.FamilyID = f.FamilyID
	and m.StatusCode &lt;&gt; 'DECEASED'
join xrpt.Churches_vw c
on c.ChurchID=f.ChurchID
join xrpt.MailingLabels_vw ml
on ml.FamilyID=f.FamilyID
where f.ChurchID =@ChurchID
  and (' All Statuses' in (@Statuses) 
	or
	f.StatusCode in (@Statuses))
and ((@Registered = 0)
	or (@Registered = 1 and f.IsRegistered = 'Y' )  
	or (@Registered = 2 and (f.RegistrationDate &gt;= @RD1 and f.RegistrationDate &lt;=@RD2))) --and f.IsRegistered = 'Y' ))
and 0 in (@FamilyTags) 
	--and exists (select 1 from xrpt.FamilyTagMembers_vw t
	--	where t.ChurchID = f.ChurchID
	--	and t.FamilyID = f.FamilyID
	--	and (' All Statuses' in (@Statuses) 
	--		or f.StatusCode in (@Statuses)) 
	--		and ((@Registered = 0)
	--		or (@Registered = 1 and f.IsRegistered = 'Y' )  
	--		or (@Registered = 2 and (f.RegistrationDate &gt;= @RD1 and f.RegistrationDate &lt;=@RD2))) --and f.IsRegistered = 'Y' ))
	--)
			
	or exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = f.ChurchID
		and t.FamilyID = f.FamilyID
		and t.TagID in (@FamilyTags)
			)
	or (1 in (@FamilyTags)
	and not exists (
		select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = f.ChurchID
		and t.FamilyID = f.FamilyID
		and t.TagID in (@FamilyTags)
			))
and (
	0 in (@Committees)
	or exists (
		select 1
		from xrpt.CommitteeMembers_vw cm
		where cm.ChurchID = m.ChurchID
		and cm.FamilyID = m.FamilyID
		and cm.MemberID = m.MemberID
		and cm.CommitteeID in (@Committees)
	))
	) FDATA
cross join @ChurchData CV
order by LastName</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchID">
          <DataField>ChurchID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Logo">
          <DataField>Logo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="familyid">
          <DataField>familyid</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="LogoOrientation">
          <DataField>LogoOrientation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterSignURL">
          <DataField>LetterSignURL</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BudgetNumber">
          <DataField>BudgetNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="LetterSign">
          <DataField>LetterSign</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ChurchName">
          <DataField>ChurchName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CAddr1">
          <DataField>CAddr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="HasEnvelopes">
          <DataField>HasEnvelopes</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="CAddr2">
          <DataField>CAddr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="BudgetNumberInactive">
          <DataField>BudgetNumberInactive</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="CCity">
          <DataField>CCity</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="RegistrationDate">
          <DataField>RegistrationDate</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CZipCode">
          <DataField>CZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="IsRegistered">
          <DataField>IsRegistered</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CPhoneNumber">
          <DataField>CphoneNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Salutation">
          <DataField>Salutation</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="MailName">
          <DataField>MailName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FirstName">
          <DataField>FirstName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAlerts">
          <DataField>EmailAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="LastName">
          <DataField>LastName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr1">
          <DataField>Addr1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Addr2">
          <DataField>Addr2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="City">
          <DataField>City</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="State">
          <DataField>State</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ZipCode">
          <DataField>ZipCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PhoneNumber">
          <DataField>PhoneNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PhoneSmsAlerts">
          <DataField>PhoneSmsAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="PhoneVoiceAlerts">
          <DataField>PhoneVoiceAlerts</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="PhoneUnlisted">
          <DataField>PhoneUnlisted</DataField>
          <rd:TypeName>System.Boolean</rd:TypeName>
        </Field>
        <Field Name="LetterText">
          <DataField>LetterText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="EmailAddress">
          <DataField>EmailAddress</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="StatusDate">
          <DataField>StatusDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="ChurchCity">
          <DataField>ChurchCity</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CState">
          <DataField>CState</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Forms">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select distinct isnull(replace(MemberLastFirst,'Merge, ',''),'') LetterForm
from xrpt.FamilyNotes_vw fn
where MemberLastFirst like 'Merge, %'
and exists ( select 1 from xrpt.Families_vw f
where f.familyid=fn.familyid
and f.ChurchID  = @ChurchID
and f.LastName = 'ADMIN'
and f.StatusCode = 'Staff')
and exists (select 1 from xrpt.members_vw m
where m.familyid=fn.familyid and m.statuscode='Active')</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="LetterForm">
          <DataField>LetterForm</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MyCommittees">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT distinct [CommitteeID]
      ,[CommitteeName]
  FROM [xrpt].[CommitteeMembers_vw]
  where ChurchID = @ChurchID
union all 
Select 0, ' All Committees') tst
order by CommitteeName</CommandText>
      </Query>
      <Fields>
        <Field Name="CommitteeID">
          <DataField>CommitteeID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="CommitteeName">
          <DataField>CommitteeName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix3">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>7.5in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>4.52621in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Rectangle Name="RepeatingValue">
                          <ReportItems>
                            <Textbox Name="Letter">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>="Dear " &amp; iif(Parameters!Greeting.Value=1,Fields!FirstName.Value,iif(Fields!Salutation.Value="",Fields!MailName.Value,Fields!Salutation.Value)) &amp; "," 
&amp; "&lt;br&gt;&lt;br&gt;" &amp; replace(Fields!LetterText.Value,"  ",chr(160))</Value>
                                      <MarkupType>HTML</MarkupType>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>2.74021in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.48312in</Height>
                              <Width>6.88545in</Width>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="Letter3">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=Fields!LetterSign.Value</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>=Parameters!FontSize.Value</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <Top>4.12585in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.29562in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>1</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Image Name="Signature">
                              <Source>External</Source>
                              <Value>=Fields!LetterSignURL.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>3.29278in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.76166in</Height>
                              <Width>2.76851in</Width>
                              <ZIndex>2</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LetterSignURL.Value="",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Textbox Name="ChurchRight">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=chr(10) &amp; chr(10) &amp; chr(10) 
&amp; iif(Parameters!FO.Value=1,"",trim(replace(Fields!ChurchName.Value,"Parish","")) &amp; " Parish" 
&amp; chr(10) &amp; Fields!CAddr1.Value 
&amp; chr(10) &amp; Fields!CCity.Value &amp; ", " &amp; Fields!CState.Value &amp; " " &amp; Fields!CZipCode.Value)</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Right</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <Top>1.33283in</Top>
                              <Left>4.14046in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>3</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",False,True)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="FamilyID">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=FormatDateTime(Parameters!Date.Value,DateFormat.ShortDate) 
&amp; chr(10) 
&amp; chr(10) 
&amp; chr(10) 
&amp; iif(Parameters!AddressCase.Value=1 , strconv(IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10))  
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value,1) , 
iif(Parameters!AddressCase.Value=2 , strconv(IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10)) 
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value,3) , 
IIf(Fields!MailName.Value="",Fields!FirstName.Value &amp; " " &amp; Fields!LastName.Value,Fields!MailName.Value) &amp;chr(10) 
&amp; Fields!Addr1.Value &amp; chr(10) &amp; iif(Fields!Addr2.Value="","",Fields!Addr2.Value &amp; chr(10)) 
&amp; Fields!City.Value &amp; ", " &amp; Fields!State.Value &amp; " " &amp; Fields!ZipCode.Value ))</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>FamilyID</rd:DefaultName>
                              <Top>1.33283in</Top>
                              <Left>0.38001in</Left>
                              <Height>1.08368in</Height>
                              <Width>3.43001in</Width>
                              <ZIndex>4</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Image Name="LogoWide">
                              <Source>External</Source>
                              <Value>=Fields!Logo.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>0.10277in</Top>
                              <Left>0.38001in</Left>
                              <Height>1.08228in</Height>
                              <Width>6.88545in</Width>
                              <ZIndex>5</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",False,True)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Image Name="LogoSquare">
                              <Source>External</Source>
                              <Value>=Fields!Logo.Value</Value>
                              <Sizing>FitProportional</Sizing>
                              <Top>0.10277in</Top>
                              <Left>4.85112in</Left>
                              <Height>2.41791in</Height>
                              <Width>2.51851in</Width>
                              <ZIndex>6</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                              </Style>
                            </Image>
                            <Textbox Name="ChurchTop">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=iif(Parameters!FO.Value=1,chr(10)&amp;chr(10)&amp;chr(10), trim(replace(Fields!ChurchName.Value,"Parish","")) &amp; " Parish" 
&amp; chr(10) &amp; Fields!CAddr1.Value 
&amp; chr(10) &amp; Fields!CCity.Value &amp; ", " &amp; Fields!CState.Value &amp; " " &amp; Fields!CZipCode.Value)</Value>
                                      <Style>
                                        <FontFamily>=Parameters!Font.Value</FontFamily>
                                        <FontSize>12pt</FontSize>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Left</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <Top>0.10277in</Top>
                              <Left>0.38001in</Left>
                              <Height>0.97951in</Height>
                              <Width>3.43001in</Width>
                              <ZIndex>7</ZIndex>
                              <Visibility>
                                <Hidden>=iif(Fields!LogoOrientation.Value="WIDE",True,False)</Hidden>
                              </Visibility>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                            <Textbox Name="EmailAddress">
                              <CanGrow>true</CanGrow>
                              <KeepTogether>true</KeepTogether>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>="EMAIL:" &amp; iif(str(Fields!EmailAlerts.Value)=TRUE, Fields!EmailAddress.Value,"")</Value>
                                      <Style>
                                        <FontSize>8pt</FontSize>
                                        <Color>White</Color>
                                      </Style>
                                    </TextRun>
                                  </TextRuns>
                                  <Style />
                                </Paragraph>
                              </Paragraphs>
                              <rd:DefaultName>EmailAddress</rd:DefaultName>
                              <Left>0.38001in</Left>
                              <Height>0.07499in</Height>
                              <Width>3.125in</Width>
                              <ZIndex>8</ZIndex>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <PaddingLeft>2pt</PaddingLeft>
                                <PaddingRight>2pt</PaddingRight>
                                <PaddingTop>2pt</PaddingTop>
                                <PaddingBottom>2pt</PaddingBottom>
                              </Style>
                            </Textbox>
                          </ReportItems>
                          <KeepTogether>true</KeepTogether>
                          <Style>
                            <Border>
                              <Style>None</Style>
                            </Border>
                          </Style>
                        </Rectangle>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <Group Name="Details1">
                    <GroupExpressions>
                      <GroupExpression>=Fields!familyid.Value</GroupExpression>
                    </GroupExpressions>
                    <PageBreak>
                      <BreakLocation>Between</BreakLocation>
                    </PageBreak>
                  </Group>
                  <SortExpressions>
                    <SortExpression>
                      <Value>=iif(Parameters!Sort.Value=0,Fields!LastName.Value,Fields!ZipCode.Value+Fields!LastName.Value)</Value>
                    </SortExpression>
                  </SortExpressions>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>Families</DataSetName>
            <Height>4.52621in</Height>
            <Width>7.5in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>4.52621in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>7.5in</Width>
      <Page>
        <LeftMargin>0.5in</LeftMargin>
        <RightMargin>0.5in</RightMargin>
        <TopMargin>0.125in</TopMargin>
        <BottomMargin>0.125in</BottomMargin>
        <Style />
      </Page>
    </ReportSection>
  </ReportSections>
  <ReportParameters>
    <ReportParameter Name="ChurchID">
      <DataType>Integer</DataType>
      <Prompt>Church</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="FForm">
      <DataType>String</DataType>
      <Prompt>Form</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Forms</DataSetName>
          <ValueField>LetterForm</ValueField>
          <LabelField>LetterForm</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Statuses">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value> All Statuses</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Family Status</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Statuses</DataSetName>
          <ValueField>StatusCode</ValueField>
          <LabelField>StatusCode</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Registered">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Registered Parishioners</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Registered and Unregistered</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Registered Only</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Registered within date range</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="RD1">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=Today()</Value>
        </Values>
      </DefaultValue>
      <Prompt>Begin (if Range selected)</Prompt>
    </ReportParameter>
    <ReportParameter Name="RD2">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=Today()</Value>
        </Values>
      </DefaultValue>
      <Prompt>End (if Range selected)</Prompt>
    </ReportParameter>
    <ReportParameter Name="FamilyTags">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Family Tags</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>FamilyTags</DataSetName>
          <ValueField>TagID</ValueField>
          <LabelField>TagName</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
      <cl:ComponentMetadata>
        <cl:HideUpdateNotifications>true</cl:HideUpdateNotifications>
      </cl:ComponentMetadata>
    </ReportParameter>
    <ReportParameter Name="Committees">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Member Committees</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyCommittees</DataSetName>
          <ValueField>CommitteeID</ValueField>
          <LabelField>CommitteeName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="ForM">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Mail to:</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Family</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Member</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Greeting">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Greeting</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Use Salutation</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Use First Name</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Date">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=today()</Value>
        </Values>
      </DefaultValue>
      <Prompt>Date</Prompt>
    </ReportParameter>
    <ReportParameter Name="Address">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Address to use</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Mailing Address</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Street Address</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="AddressCase">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Address Format</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Current Data Format</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Upper Case (USPS)</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Proper Case (mixed)</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="FO">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Format Option</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Display Return Address</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Suppress Return Address</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Sort">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Selet Sort Order</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>Last Name</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Zip Code / Last Name</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Font">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>Arial</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Font</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>Arial</Value>
            <Label>Arial</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Calibri</Value>
            <Label>Calibri</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Century</Value>
            <Label>Century</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Comic Sans MS</Value>
            <Label>Comic Sans MS</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Lucida Sans</Value>
            <Label>Lucida Sans</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Georgia</Value>
            <Label>Georgia</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Tahoma</Value>
            <Label>Tahoma</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Times New Roman</Value>
            <Label>Times New Roman</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>Verdana</Value>
            <Label>Verdana</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="FontSize">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>12pt</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Font Size</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>12pt</Value>
            <Label>12 point</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>10pt</Value>
            <Label>10 Point</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>3</NumberOfColumns>
      <NumberOfRows>7</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ChurchID</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>FForm</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Statuses</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Registered</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>RD1</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>RD2</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>FamilyTags</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Committees</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>ForM</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Greeting</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>3</RowIndex>
          <ParameterName>Date</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>Address</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>AddressCase</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>4</RowIndex>
          <ParameterName>FO</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Sort</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>5</RowIndex>
          <ParameterName>Font</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>6</RowIndex>
          <ParameterName>FontSize</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>72829793-6244-472b-b4c1-dd9b28fc0ea1</rd:ReportID>
</Report>