<?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>None</rd:SecurityType>
      <rd:DataSourceID>41075bbf-f6d4-46c3-b207-93e5ea9dd34e</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="MyChurches">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <CommandText>SELECT
  ChurchID
  ,Churches_vw.ChurchName+ ' - ' + Churches_vw.City [ChurchName]
FROM
  xrpt.Churches_vw AS Churches_vw
order by Churches_vw.ChurchName+ ' - ' + Churches_vw.City</CommandText>
      </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="MyStatuses">
      <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>
      </Query>
      <Fields>
        <Field Name="StatusCode">
          <DataField>StatusCode</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>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT
FamilyTags_vw.TagID
  ,FamilyTags_vw.TagName
FROM
  xrpt.FamilyTags_vw 
where FamilyTags_vw.ChurchID = @ChurchID
union all 
select 0, ' All Tags' 
union all
select 1, ' No Tag' ) 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="Families">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@Column">
            <Value>=Parameters!Column.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@CMorF">
            <Value>=Parameters!CMorF.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Row">
            <Value>=Parameters!Row.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@eAlerts">
            <Value>=Parameters!eAlerts.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ExcludedTags">
            <Value>=Parameters!ExcludedTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Committees">
            <Value>=Parameters!Committees.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Statuses">
            <Value>=Parameters!Statuses.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Position">
            <Value>=Parameters!Position.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Declare @blanks table (id int identity(1,1),x char(2))

declare @cnt int = 1
while @cnt &lt;= (@Column-1)*10+(@Row-1)
begin 
insert into @blanks
select convert(char(2),@cnt)
set @cnt=@cnt+1
end

select * from (

--Declare @ChurchID  int = 72
--declare @Committees int = 0
--declare @Position varchar(12) = ' All'
-- Declare @FamilyTags int = 167
--declare @Statuses varchar(20)= 'Active'--' All Statuses' 
--declare @cmorf int = 0
--declare @ealerts int = 1

select DISTINCT f.FamilyID
--,fm.LastName --= case when @CMorF = 1 then fm.LastName else f.LastName end
--,fm.firstName --= case when @CMorF = 1 then fm.FirstName else f.FirstName end
    ,f.Salutation
,case when @CMorF = 0 then isnull(fm.FirstName +' ' + fm.LastName,ml.MailName)  else  ml.MailName end MailName
,ml.lastName
    ,ml.Addr1
    ,isnull(ml.Addr2,'') Addr2
    ,ml.City
    ,ml.State
    ,ml.ZipCode
    ,f.PhoneNumber
    ,f.BudgetNumber
FROM xrpt.families_vw f
left join xrpt.Members_vw fm
on fm.ChurchID=f.ChurchID
and fm.FamilyID =f.FamilyID
join xrpt.MailingLabels_vw ml
on ml.FamilyID=f.FamilyID
where (0 in (@FamilyTags)
	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 (not exists (select 1
		from xrpt.FamilyTagMembers_vw t
		where t.ChurchID = f.ChurchID
		and t.FamilyID = f.FamilyID
		and t.TagID in (@ExcludedTags)
			)
	)
and case when ' All Statuses' in (@Statuses) then 1 else 
	case when f.StatusCode in (@Statuses) then 1 else 0 end end =1
and case when @eAlerts = 1 then 1 else 
	case when isnull(f.emailAlerts,0) = 0 then 0 else 1 end end =1
  and f.ChurchID = @ChurchID
and (
	0 in (@Committees)
	or exists (
		select 1
		from xrpt.CommitteeMembers_vw cm
		where cm.ChurchID = fm.ChurchID
		and cm.FamilyID = fm.FamilyID
		and cm.MemberID = fm.MemberID
		and CommitteeID in (@Committees)
		and case when ' All' in (@Position) then 1 else 
	case when 'x'+isnull(CommitteePosition,'') in (@Position) then 1 else 0 end end =1
	)
)

union all
Select 0
,''
,''
,''
,''
,''
,''
,''
,''
,''
,''
From @blanks ) xx
order by LastName</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="FamilyID">
          <DataField>FamilyID</DataField>
          <rd:TypeName>System.Int32</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="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="BudgetNumber">
          <DataField>BudgetNumber</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="SelectedTags">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@FamilyTags">
            <Value>=Parameters!FamilyTags.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select Tags = STUFF((SELECT distinct ', ' + isnull(t.TagName ,'')
FROM ((select 0 TagID
, ' All Tags' TagName
Union all
SELECT
FamilyTags_vw.TagID
  ,FamilyTags_vw.TagName
FROM
  xrpt.FamilyTags_vw 
where FamilyTags_vw.ChurchID = @ChurchID)) t
where t.TagID in (@FamilyTags)
FOR XML PATH ('')), 1, 1, '')</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="Tags">
          <DataField>Tags</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 ChurchName 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>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="ChurchName">
          <DataField>ChurchName</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>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </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>
    <DataSet Name="CommitteePosi">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
          <QueryParameter Name="@Committees">
            <Value>=Parameters!Committees.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT distinct [CommitteeName]
     +' - '+[CommitteePosition] CommitteePosi
,'x'+[CommitteePosition] [CommitteePosition]
  FROM [xrpt].[CommitteeMembers_vw]
where Churchid = @ChurchID 
and case when 0 in (@Committees) then 1 else 
	case when CommitteeID in (@Committees) then 1 else 0 end end =1
and committeeposition &lt;&gt; ''
union all 
select ' All Positions',' All') xx
order by CommitteePosi</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <Fields>
        <Field Name="CommitteePosi">
          <DataField>CommitteePosi</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="CommitteePosition">
          <DataField>CommitteePosition</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Exclude">
      <Query>
        <DataSourceName>AOC</DataSourceName>
        <QueryParameters>
          <QueryParameter Name="@ChurchID">
            <Value>=Parameters!ChurchID.Value</Value>
          </QueryParameter>
        </QueryParameters>
        <CommandText>Select * from 
(SELECT
FamilyTags_vw.TagID
  ,FamilyTags_vw.TagName
FROM
  xrpt.FamilyTags_vw 
where FamilyTags_vw.ChurchID = @ChurchID
union all
select 0, ' No Exclusions'  ) tst
order by TagName</CommandText>
      </Query>
      <Fields>
        <Field Name="TagID">
          <DataField>TagID</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="TagName">
          <DataField>TagName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Tablix Name="Tablix2">
            <TablixBody>
              <TablixColumns>
                <TablixColumn>
                  <Width>3.8125in</Width>
                </TablixColumn>
              </TablixColumns>
              <TablixRows>
                <TablixRow>
                  <Height>1.0312in</Height>
                  <TablixCells>
                    <TablixCell>
                      <CellContents>
                        <Rectangle Name="Rectangle1">
                          <ReportItems>
                            <Textbox Name="Textbox1">
                              <CanGrow>true</CanGrow>
                              <Paragraphs>
                                <Paragraph>
                                  <TextRuns>
                                    <TextRun>
                                      <Value>=chr(10) &amp; iif(Parameters!InclBN.Value=1,iif(isnothing(Fields!BudgetNumber.Value),"",Fields!BudgetNumber.Value) &amp; chr(10),"") 
&amp; Fields!MailName.Value 
&amp; chr(10) &amp; Fields!Addr1.Value 
&amp; chr(32) &amp; IIF(IsNothing(Fields!Addr2.Value),chr(10),chr(32) &amp; chr(32) &amp; Fields!Addr2.Value &amp; chr(10)) 
&amp; Fields!City.Value &amp; chr(44) &amp; chr(32) &amp; Fields!State.Value &amp; chr(32) &amp; Fields!ZipCode.Value</Value>
                                      <Style />
                                    </TextRun>
                                  </TextRuns>
                                  <Style>
                                    <TextAlign>Left</TextAlign>
                                  </Style>
                                </Paragraph>
                              </Paragraphs>
                              <Height>1.0312in</Height>
                              <Width>3.8125in</Width>
                              <DataElementName>Families</DataElementName>
                              <Style>
                                <Border>
                                  <Style>None</Style>
                                </Border>
                                <VerticalAlign>Middle</VerticalAlign>
                                <PaddingLeft>15pt</PaddingLeft>
                                <PaddingRight>15pt</PaddingRight>
                              </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="Details">
                    <GroupExpressions>
                      <GroupExpression>=Fields!FamilyID.Value</GroupExpression>
                    </GroupExpressions>
                  </Group>
                  <SortExpressions>
                    <SortExpression>
                      <Value>=iif(Parameters!Sort.Value=0,Fields!ZipCode.Value,iif(Parameters!Sort.Value=1,Fields!lastName.Value,Fields!BudgetNumber.Value))</Value>
                    </SortExpression>
                  </SortExpressions>
                </TablixMember>
              </TablixMembers>
            </TablixRowHierarchy>
            <DataSetName>Families</DataSetName>
            <SortExpressions>
              <SortExpression>
                <Value>=iif(Parameters!InclBN.Value,int(iif(isnothing(Fields!BudgetNumber.Value) or not(IsNumeric(Fields!BudgetNumber.Value)),0,Fields!BudgetNumber.Value)),
right(Fields!MailName.Value,InStrRev(" ",Fields!MailName.Value)))</Value>
              </SortExpression>
            </SortExpressions>
            <Height>1.0312in</Height>
            <Width>3.8125in</Width>
            <Style>
              <Border>
                <Style>None</Style>
              </Border>
            </Style>
          </Tablix>
        </ReportItems>
        <Height>1.0312in</Height>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Body>
      <Width>3.8125in</Width>
      <Page>
        <TopMargin>0.1875in</TopMargin>
        <Columns>2</Columns>
        <ColumnSpacing>0.02135in</ColumnSpacing>
        <Style />
      </Page>
    </ReportSection>
  </ReportSections>
  <ReportParameters>
    <ReportParameter Name="ChurchID">
      <DataType>Integer</DataType>
      <Prompt>Select Church</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyChurches</DataSetName>
          <ValueField>ChurchID</ValueField>
          <LabelField>ChurchName</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Statuses">
      <DataType>String</DataType>
      <Prompt>Select Statuses</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyStatuses</DataSetName>
          <ValueField>StatusCode</ValueField>
          <LabelField>StatusCode</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="FamilyTags">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Family Tags</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>FamilyTags</DataSetName>
          <ValueField>TagID</ValueField>
          <LabelField>TagName</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="ExcludedTags">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Exclude these tags</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>Exclude</DataSetName>
          <ValueField>TagID</ValueField>
          <LabelField>TagName</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Committees">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value> All</Value>
        </Values>
      </DefaultValue>
      <Prompt>Select Committees</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>MyCommittees</DataSetName>
          <ValueField>CommitteeID</ValueField>
          <LabelField>CommitteeName</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="Position">
      <DataType>String</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Comittee Position</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>CommitteePosi</DataSetName>
          <ValueField>CommitteePosition</ValueField>
          <LabelField>CommitteePosi</LabelField>
        </DataSetReference>
      </ValidValues>
      <MultiValue>true</MultiValue>
    </ReportParameter>
    <ReportParameter Name="CMorF">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Committee Member or Family</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Family Name</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>0</Value>
            <Label>Committee Member Name</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="eAlerts">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Include Families accpting eMail Alerts?</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Yes</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>0</Value>
            <Label>No</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="InclBN">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <Prompt>Include Budget Number Above Name?</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>0</Value>
            <Label>No</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>1</Value>
            <Label>Yes</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Sort">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Sort</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Last Name Sort</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>0</Value>
            <Label>Zip Code Sort</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Budget Number sort</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Column">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Start Column</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Column 1</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Column 2</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
    <ReportParameter Name="Row">
      <DataType>Integer</DataType>
      <DefaultValue>
        <Values>
          <Value>1</Value>
        </Values>
      </DefaultValue>
      <Prompt>Start Row</Prompt>
      <ValidValues>
        <ParameterValues>
          <ParameterValue>
            <Value>1</Value>
            <Label>Row 1</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>2</Value>
            <Label>Row 2</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>3</Value>
            <Label>Row 3</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>4</Value>
            <Label>Row 4</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>5</Value>
            <Label>Row 5</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>6</Value>
            <Label>Row 6</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>7</Value>
            <Label>Row 7</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>8</Value>
            <Label>Row 8</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>9</Value>
            <Label>Row 9</Label>
          </ParameterValue>
          <ParameterValue>
            <Value>10</Value>
            <Label>Row 10</Label>
          </ParameterValue>
        </ParameterValues>
      </ValidValues>
    </ReportParameter>
  </ReportParameters>
  <ReportParametersLayout>
    <GridLayoutDefinition>
      <NumberOfColumns>4</NumberOfColumns>
      <NumberOfRows>3</NumberOfRows>
      <CellDefinitions>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ChurchID</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>Statuses</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>FamilyTags</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>0</RowIndex>
          <ParameterName>ExcludedTags</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Committees</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>Position</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>CMorF</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>1</RowIndex>
          <ParameterName>eAlerts</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>0</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>InclBN</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>1</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Sort</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>2</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Column</ParameterName>
        </CellDefinition>
        <CellDefinition>
          <ColumnIndex>3</ColumnIndex>
          <RowIndex>2</RowIndex>
          <ParameterName>Row</ParameterName>
        </CellDefinition>
      </CellDefinitions>
    </GridLayoutDefinition>
  </ReportParametersLayout>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>8f51e90d-03ad-4d71-a959-99ce486f8559</rd:ReportID>
</Report>