﻿<?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="AOCds">
      <DataSourceReference>AOCds</DataSourceReference>
      <rd:SecurityType>None</rd:SecurityType>
      <rd:DataSourceID>f371c945-ad1b-49e2-8db4-5bc949baa860</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="DataSet1">
      <Query>
        <DataSourceName>AOCds</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>--declare @Churchid int = 2
declare @MID table ( MemberID int)
;with CTE as (
Select FamilyID, MemberID, lastName, soundex(firstName) fn,row_number() over
(partition by FamilyID, lastName, soundex(firstName) order by lastName) as NameNumber 
from xrpt.Members_vw where ChurchID = @ChurchID)
insert into @MID
select distinct MemberID from CTE where NameNumber &gt;1

SELECT distinct
	Test=case when m.FirstName = m2.FirstName 
	and m.lastName = m2.lastName 
	and isnull(m.BirthDate,'')=isnull(m2.BirthDate,'') 
	and isnull(m.birthdate,'') &lt;&gt;'' then 'Exact Match DOB and Name'
	else
	case when m.FirstName = m2.FirstName
	and m.lastName = m2.lastName  then 'Exact Match Name'
	else case when soundex(m.FirstName) = soundex(m2.FirstName) 
	and m.lastName = m2.lastName then 'Fuzzy Match' end end end
	,m.FamilyID FID1
	,m.MemberID MID1
	,'/FamilyID: ' + convert(char(8),m.FamilyID)
	+'/MemberID: ' + convert(char(8),m.MemberID)
	+'/Status: ' + isnull(m.StatusCode,'')
	+'/' +isnull(m.LastName,'')+', '+isnull(m.FirstName,'')
	+'/Maiden Name: '+ isnull(m.MaidenName,'')
	+'/BirthDate:' + isnull(convert(varchar(10),m.BirthDate,102),'')
	+'/DeceasedDate:' + isnull(convert(varchar(10),m.DeceasedDate,102),'')
	+'/Gender: ' + isnull(m.Gender,'')
	+'/Address:/' + isnull(m.Addr1,'')
	+'/' + isnull(m.Addr2,'')
	+'/' + isnull(m.City,'') +', ' + isnull(m.State,'') + ' ' + isnull(m.ZipCode,'')
	+'/Phone: '+ isnull(m.PhoneNumber,'')
	+'/Work: '+isnull(m.WorkCompanyName,'')
	+'/WorkTitle: '+isnull(m.WorkTitle,'')
	+'/WorkAddress:/' + isnull(m.WorkAddr1,'')
	+'/' + isnull(m.WorkAddr2,'')
	+'/' + isnull(m.WorkCity,'') +', ' + isnull(m.WorkState,'') + ' ' + isnull(m.WorkZipCode,'')
	+'/WorkPhone: '+ isnull(m.WorkPhoneNumber,'')
	+'/WorkEmail: '+ isnull(m.WorkEmailAddress,'')
	+ '/Sacraments:'+isnull(STUFF((SELECT distinct '/' + isnull(ms.SacramentName,'')
			+case when isnull(ms.SacramentName,'')='Matrimony' then isnull(' :spouse-'+ms.SpouseName,'') else '' end
			+isnull(' :date-'+convert(varchar(10),ms.DateReceived,102) ,'')
			+isnull(' :loc-'+ms.LocationOfSacrament ,'')
			+isnull(' :cel-'+ms.Celebrant ,'')
			+case when isnull(ms.SacramentName,'')='Confirmation' then isnull(' :Saint-'+ms.SaintName,'') else '' end
		FROM xrpt.MemberSacraments_vw ms
		WHERE ms.ChurchID = m.ChurchID
		and ms.MemberID = m.MemberID 
		FOR XML PATH ('')), 1, 1, '') ,'')
	+'/PRM:'+isnull(STUFF((Select '/'+ContactType+': '+convert(varchar(10),n.ContactDate,102)+'-'+replace(replace(replace(note,char(13),''),'/','.'),char(10),'|')
		from xrpt.FamilyNotes_vw n 
		where m.ChurchID = n.ChurchID
		and m.FamilyID = n.FamilyID
		and m.MemberID = n.MemberID
		FOR XML PATH ('')), 1, 1, '') ,'')
		[Record One]
,m2.FamilyID FID2
	,m2.MemberID MID2
	,'/FamilyID: ' + convert(char(8),m2.FamilyID)
	+'/MemberID: ' + convert(char(8),m2.MemberID)
	+'/Status: ' + isnull(m2.StatusCode,'')
	+'/' +isnull(m2.LastName,'')+', '+isnull(m2.FirstName,'')
	+'/Maiden Name: '+ isnull(m2.MaidenName,'')
	+'/BirthDate:' + isnull(convert(varchar(10),m2.BirthDate,102),'')
	+'/DeceasedDate:' + isnull(convert(varchar(10),m2.DeceasedDate,102),'')
	+'/Gender: ' + isnull(m2.Gender,'')
	+'/Address:/' + isnull(m2.Addr1,'')
	+'/' + isnull(m2.Addr2,'')
	+'/' + isnull(m2.City,'') +', ' + isnull(m2.State,'') + ' ' + isnull(m2.ZipCode,'')
	+'/Phone: '+ isnull(m2.PhoneNumber,'')
	+'/Work: '+isnull(m2.WorkCompanyName,'')
	+'/WorkTitle: '+isnull(m2.WorkTitle,'')
	+'/WorkAddress:/' + isnull(m2.WorkAddr1,'')
	+'/' + isnull(m2.WorkAddr2,'')
	+'/' + isnull(m2.WorkCity,'') +', ' + isnull(m2.WorkState,'') + ' ' + isnull(m2.WorkZipCode,'')
	+'/WorkPhone: '+ isnull(m2.WorkPhoneNumber,'')
	+'/WorkEmail: '+ isnull(m2.WorkEmailAddress,'')
	+ '/Sacraments:'+isnull(STUFF((SELECT distinct '/' + isnull(ms.SacramentName,'')
			+case when isnull(ms.SacramentName,'')='Matrimony' then isnull(' :spouse-'+ms.SpouseName,'') else '' end
			+isnull(' :date-'+convert(varchar(10),ms.DateReceived,102) ,'')
			+isnull(' :loc-'+ms.LocationOfSacrament ,'')
			+isnull(' :cel-'+ms.Celebrant ,'')
			+case when isnull(ms.SacramentName,'')='Confirmation' then isnull(' :Saint-'+ms.SaintName,'') else '' end
		FROM xrpt.MemberSacraments_vw ms
		WHERE ms.ChurchID = m2.ChurchID
		and ms.MemberID = m2.MemberID 
		FOR XML PATH ('')), 1, 1, '') ,'')
	+'/PRM:'+isnull(STUFF((Select '/'+ContactType+': '+convert(varchar(10),n.ContactDate,102)+'-'+replace(replace(replace(note,char(13),''),'/','.'),char(10),'|')
		from xrpt.FamilyNotes_vw n 
		where m2.ChurchID = n.ChurchID
		and m2.FamilyID = n.FamilyID
		and m2.MemberID = n.MemberID
		FOR XML PATH ('')), 1, 1, '') ,'')
		  [Record Two]
FROM xrpt.Members_vw m
join xrpt.Members_vw m2 
	on m.LastName = m2.LastName 
	and soundex(m.FirstName) = soundex(m2.FirstName) 
	and m.ChurchID = m2.ChurchID
	and m.FamilyID = m2.FamilyID
	and m.MemberID&lt;&gt; m2.MemberID
join @MID Mid on  Mid.MemberID = m.MemberID
Where m.ChurchID = @ChurchID
and m.StatusCode &lt;&gt; 'Deleted'
and m2.StatusCode &lt;&gt; 'Deleted'
order by m.FamilyID</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="Test">
          <DataField>Test</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FID1">
          <DataField>FID1</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="MID1">
          <DataField>MID1</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Record_One">
          <DataField>Record One</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="Record_Two">
          <DataField>Record Two</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FID2">
          <DataField>FID2</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="MID2">
          <DataField>MID2</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOCds</DataSourceName>
        <CommandText>SELECT
  convert(varchar(10),ChurchID) ChurchID
  ,ChurchName + ' - ' +City ChurchName
FROM
  xrpt.Churches_vw 
order by ChurchName+ ' - ' +City</CommandText>
      </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="MyStatuses">
      <Query>
        <DataSourceName>AOCds</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT distinct 
 StatusCode
FROM xrpt.Families_vw 
where Churchid = @ChurchID
union all
select ' All Statuses'
)tst
order by StatusCode</CommandText>
      </Query>
      <Fields>
        <Field Name="StatusCode">
          <DataField>StatusCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Textbox Name="textbox1">
            <CanGrow>true</CanGrow>
            <KeepTogether>true</KeepTogether>
            <Paragraphs>
              <Paragraph>
                <TextRuns>
                  <TextRun>
                    <Value>Suspect Duplicate Families </Value>
                    <Style>
                      <FontFamily>Segoe UI Light</FontFamily>
                      <FontSize>24pt</FontSize>
                      <FontWeight>Bold</FontWeight>
                    </Style>
                  </TextRun>
                </TextRuns>
                <Style />
              </Paragraph>
            </Paragraphs>
            <rd:DefaultName>textbox1</rd:DefaultName>
            <Height>0.545in</Height>
            <Width>9.43333in</Width>
            <Style>
              <PaddingLeft>2pt</PaddingLeft>
              <PaddingRight>2pt</PaddingRight>
              <PaddingTop>2pt</PaddingTop>
              <PaddingBottom>2pt</PaddingBottom>
            </Style>
          </Textbox>
          <Tablix Name="table1">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>0.73333in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>4in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>0.7in</Width>
                </TablixColumn>
                <TablixColumn>
                  <Width>4in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>0.43in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox5">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>FID1</Value>
                                  <Style>
                                    <FontFamily />
                                    <FontSize>11pt</FontSize>
                                    <FontWeight>Bold</FontWeight>
                                    <Color>#666666</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox5</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="textbox4">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Record One</Value>
                                  <Style>
                                    <FontFamily />
                                    <FontSize>11pt</FontSize>
                                    <FontWeight>Bold</FontWeight>
                                    <Color>#666666</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <FontFamily />
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>textbox4</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <FontFamily />
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox7">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>FID2</Value>
                                  <Style>
                                    <FontFamily />
                                    <FontSize>11pt</FontSize>
                                    <FontWeight>Bold</FontWeight>
                                    <Color>#666666</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox7</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Textbox2">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>Record Two</Value>
                                  <Style>
                                    <FontFamily />
                                    <FontSize>11pt</FontSize>
                                    <FontWeight>Bold</FontWeight>
                                    <Color>#666666</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Textbox2</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
                <TablixRow>
                  <Height>0.21in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FID1">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FID1.Value</Value>
                                  <MarkupType>HTML</MarkupType>
                                  <Style>
                                    <FontFamily />
                                    <FontWeight>Bold</FontWeight>
                                    <TextDecoration>Underline</TextDecoration>
                                    <Color>Blue</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FID1</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Hyperlink>="https://app.gabrielsoft.com/auth/ohcndiocese/" &amp; Parameters!ChurchID.Value &amp; "/Family/Edit/" &amp; Fields!FID1.Value</Hyperlink>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Record_One">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Replace(Fields!Record_One.Value,"/",chr(10))</Value>
                                  <Style>
                                    <FontFamily />
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Record_One</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <FontFamily />
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="FID2">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Fields!FID2.Value</Value>
                                  <MarkupType>HTML</MarkupType>
                                  <Style>
                                    <FontFamily />
                                    <FontWeight>Bold</FontWeight>
                                    <TextDecoration>Underline</TextDecoration>
                                    <Color>Blue</Color>
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>FID2</rd:DefaultName>
                          <ActionInfo>
                            <Actions>
                              <Action>
                                <Hyperlink>="https://app.gabrielsoft.com/auth/ohcndiocese/" &amp; Parameters!ChurchID.Value &amp; "/Family/Edit/" &amp; Fields!FID2.Value</Hyperlink>
                              </Action>
                            </Actions>
                          </ActionInfo>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                    <TablixCell>
                      <CellContents>
                        <Textbox Name="Record_Two">
                          <CanGrow>true</CanGrow>
                          <KeepTogether>true</KeepTogether>
                          <Paragraphs>
                            <Paragraph>
                              <TextRuns>
                                <TextRun>
                                  <Value>=Replace(Fields!Record_Two.Value,"/",chr(10))</Value>
                                  <Style>
                                    <FontFamily />
                                  </Style>
                                </TextRun>
                              </TextRuns>
                              <Style>
                                <TextAlign>Left</TextAlign>
                              </Style>
                            </Paragraph>
                          </Paragraphs>
                          <rd:DefaultName>Record_Two</rd:DefaultName>
                          <Style>
                            <Border>
                              <Color>LightGrey</Color>
                            </Border>
                            <BottomBorder>
                              <Style>Solid</Style>
                            </BottomBorder>
                            <PaddingLeft>2pt</PaddingLeft>
                            <PaddingRight>2pt</PaddingRight>
                            <PaddingTop>2pt</PaddingTop>
                            <PaddingBottom>2pt</PaddingBottom>
                          </Style>
                        </Textbox>
                      </CellContents>
                    </TablixCell>
                  </TablixCells>
                </TablixRow>
              </TablixRows>
            </TablixBody>
            <TablixColumnHierarchy>
              <TablixMembers>
                <TablixMember />
                <TablixMember />
                <TablixMember />
                <TablixMember />
              </TablixMembers>
            </TablixColumnHierarchy>
            <TablixRowHierarchy>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                  <RepeatOnNewPage>true</RepeatOnNewPage>
                  <KeepTogether>true</KeepTogether>
                </TablixMember>
                <TablixMember>
                  <Group Name="table1_Details_Group">
                    <DataElementName>Detail</DataElementName>
                  </Group>
                  <TablixMembers>
                    <TablixMember />
                  </TablixMembers>
                  <DataElementName>Detail_Collection</DataElementName>
                  <DataElementOutput>Output</DataElementOutput>
                  <KeepTogether>true</KeepTogether>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>DataSet1</DataSetName>
            <Top>0.545in</Top>
            <Height>0.64in</Height>
            <Width>9.43333in</Width>
            <ZIndex>1</ZIndex>
            <Style />
          </Tablix>
        </ReportItems>
        <Height>1.185in</Height>
        <Style />
      </Body>
      <Width>12.725in</Width>
      <Page>
        <LeftMargin>1in</LeftMargin>
        <RightMargin>1in</RightMargin>
        <TopMargin>1in</TopMargin>
        <BottomMargin>1in</BottomMargin>
        <Style />
      </Page>
    </ReportSection>
  </ReportSections>
  <ReportParameters>
    <ReportParameter Name="ChurchID">
      <DataType>String</DataType>
      <Prompt>Church ID</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>1</NumberOfColumns>
      <NumberOfRows>2</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ChurchID</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <Language>en-US</Language>
  <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>51e2695a-c65e-4931-ba27-d7e818c7a13c</rd:ReportID>
</Report>