Problem extracting data from multiple list boxes

I have a report that has a header section with three detail sections. The header section contains information pertinent to a person and a situation. The detail sections each contain information pertinent to the situation and person in the header section. I have been able to format the data correctly but I am unable to have the unique information per person extracted for the three detail section. I am using data from four stored procedures, one for the header information and three for each detail section.

sample detail data:

sit1desc date note

sit1desc date note

sit2desc date note

sit2desc date note

sit3desc date note

sit3desc date note

sample report output:

Header data:

personname

personaddress

personphone

situationdate

situationnumber

situationlocation

sample detail output:(per person)

sit1desc date note

sit1desc date note

sit1desc date note

desired output:(per person unique to that person)

sit1desc date note

sit2desc date note

sit3desc date note

Are you currently grouping on person in your table? You can add detail grouping on situation, which'd group the rows with the same situation together per person. Just right click on the detail row, choose "Edit Group" to to bring up the detail grouping dialog, and type in the group expression (=Fields!situation.Value).

|||

I'm not currently using tables due to the fact that the data is staggered on the report. However, with your suggestion of grouping on the person and situation I believe that I could put the person and situation data into tables and leave the other information in a list box. I am including a sample of the report output for your reference.

Thanks

Discipline Report

Report Filters -

Number

Name

GR

Home

G

Birthdate

Ethnic

Phone

S1003

Hamilton, Alexander

10

138

M

01/11/1990

White, Non-Hispanic

Date:

01/03/2006

Teacher:

Address:

Period:

Location:

Bus Stop

Number:

Admin:

Jefferson, Thomas

Name:

Date:

01/03/2006

Infraction:

Disobedience

Demerits Earned:

0

Note:

Disposition:

Time Out

Start Date:

01/05/2006

End Date:

01/06/2006

Note:

Action:

Letter Sent Home

Date:

01/05/2006

Time:

00:00:00

Note:

|||

Hi,

I have converted my data from being in list boxes to tables and added the detail grouping but I am still having the same problem. Do you have any more suggestions.

Thanks

|||If you have added detail grouping on situation, you shouldn't be getting different detail rows on the same situation. What do you have in the outer groups? It'd help if you can attach a copy of your rdl.|||

I tried sending the code before but the browser kept locking up and not responding. I had to copy the code in blocks to get it all here, is there a way to attach a file?

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<DataSources>

<DataSource Name="FozzieDataSource">

<DataSourceReference>FozzieDataSource</DataSourceReference>

<rd:DataSourceID>642994d6-8188-4ffa-8dd1-fe95e69ada9a</rd:DataSourceID>

</DataSource>

</DataSources>

<BottomMargin>0.5in</BottomMargin>

<RightMargin>0.5in</RightMargin>

<ReportParameters>

<ReportParameter Name="AcadSessionID">

<DataType>Integer</DataType>

<DefaultValue>

<Values>

<Value>19</Value>

</Values>

</DefaultValue>

<Prompt>AcadSessionID</Prompt>

<Hidden>true</Hidden>

</ReportParameter>

<ReportParameter Name="StudentFilterID">

<DataType>Integer</DataType>

<Nullable>true</Nullable>

<Prompt>StudentFilterID</Prompt>

</ReportParameter>

<ReportParameter Name="StartOccurrenceDate">

<DataType>DateTime</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>1/1/06</Value>

</Values>

</DefaultValue>

<Prompt>Start Occurrence Date</Prompt>

</ReportParameter>

<ReportParameter Name="EndOccurrenceDate">

<DataType>DateTime</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>6/19/06</Value>

</Values>

</DefaultValue>

<Prompt>End Occurrence Date</Prompt>

</ReportParameter>

<ReportParameter Name="IncludeWithdrawn">

<DataType>Boolean</DataType>

<DefaultValue>

<Values>

<Value>False</Value>

</Values>

</DefaultValue>

<Prompt>Include Withdrawn</Prompt>

</ReportParameter>

<ReportParameter Name="IncludeUnlisted">

<DataType>Boolean</DataType>

<DefaultValue>

<Values>

<Value>False</Value>

</Values>

</DefaultValue>

<Prompt>Include Unlisted</Prompt>

</ReportParameter>

<ReportParameter Name="CustomReportTitle">

<DataType>String</DataType>

<Nullable>true</Nullable>

<Prompt>Custom Report Title</Prompt>

</ReportParameter>

<ReportParameter Name="OrderBy">

<DataType>String</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>StudentNumber</Value>

</Values>

</DefaultValue>

<Prompt>Order By</Prompt>

<ValidValues>

<ParameterValues>

<ParameterValue>

<Value>OccurrenceDate</Value>

<Label>Occurrence Date</Label>

</ParameterValue>

<ParameterValue>

<Value>DisplayName</Value>

<Label>Student Display Name</Label>

</ParameterValue>

<ParameterValue>

<Value>StudentNumber</Value>

<Label>Student Number</Label>

</ParameterValue>

</ParameterValues>

</ValidValues>

</ReportParameter>

<ReportParameter Name="DistrictName">

<DataType>String</DataType>

<DefaultValue>

<DataSetReference>

<DataSetName>dsDistrict</DataSetName>

<ValueField>districtname</ValueField>

</DataSetReference>

</DefaultValue>

<AllowBlank>true</AllowBlank>

<Prompt>Report_Parameter_8</Prompt>

<ValidValues>

<DataSetReference>

<DataSetName>dsDistrict</DataSetName>

<ValueField>districtname</ValueField>

<LabelField>districtname</LabelField>

</DataSetReference>

</ValidValues>

<Hidden>true</Hidden>

</ReportParameter>

<ReportParameter Name="XmlInfractions">

<DataType>String</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>&lt;root&gt;&lt;item id="1" /&gt;&lt;item id="3" /&gt;&lt;/root&gt;</Value>

</Values>

</DefaultValue>

<Prompt>Xml Infractions</Prompt>

</ReportParameter>

<ReportParameter Name="StartDispositionDate">

<DataType>DateTime</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>1/1/06</Value>

</Values>

</DefaultValue>

<AllowBlank>true</AllowBlank>

<Prompt>Start Disposition Date</Prompt>

</ReportParameter>

<ReportParameter Name="EndDispositionDate">

<DataType>DateTime</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>6/19/06</Value>

</Values>

</DefaultValue>

<AllowBlank>true</AllowBlank>

<Prompt>End Disposition Date</Prompt>

</ReportParameter>

<ReportParameter Name="XmlDispositions">

<DataType>String</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>&lt;root&gt;&lt;item id="1" /&gt;&lt;item id="3" /&gt;&lt;item id="2" /&gt;&lt;/root&gt;</Value>

</Values>

</DefaultValue>

<Prompt>Xml Dispositions</Prompt>

</ReportParameter>

<ReportParameter Name="DisplayDispositions">

<DataType>Boolean</DataType>

<DefaultValue>

<Values>

<Value>False</Value>

</Values>

</DefaultValue>

<AllowBlank>true</AllowBlank>

<Prompt>Display Dispositions</Prompt>

</ReportParameter>

<ReportParameter Name="StudentID">

<DataType>Integer</DataType>

<Nullable>true</Nullable>

<AllowBlank>true</AllowBlank>

<Prompt>StudentID</Prompt>

</ReportParameter>

<ReportParameter Name="OccurrenceID">

<DataType>Integer</DataType>

<Nullable>true</Nullable>

<AllowBlank>true</AllowBlank>

<Prompt>OccurrenceID</Prompt>

</ReportParameter>

<ReportParameter Name="XmlActions">

<DataType>String</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>&lt;root&gt;&lt;item id="1" /&gt;&lt;item id="3" /&gt;&lt;item id="2" /&gt;&lt;/root&gt;</Value>

</Values>

</DefaultValue>

<Prompt>Xml Actions</Prompt>

</ReportParameter>

<ReportParameter Name="GroupBy">

<DataType>String</DataType>

<Nullable>true</Nullable>

<DefaultValue>

<Values>

<Value>HomeroomName</Value>

</Values>

</DefaultValue>

<Prompt>Group By</Prompt>

<ValidValues>

<ParameterValues>

<ParameterValue>

<Value>FullSectionNumber</Value>

<Label>Full Section Number</Label>

</ParameterValue>

<ParameterValue>

<Value>DispositionName</Value>

<Label>Occurrence Primary Disposition</Label>

</ParameterValue>

<ParameterValue>

<Value>InfractionName</Value>

<Label>Occurrence Primary Infraction</Label>

</ParameterValue>

<ParameterValue>

<Value>GradeLevelName</Value>

<Label>Student Grade Level</Label>

</ParameterValue>

<ParameterValue>

<Value>HomeroomName</Value>

<Label>Student Homeroom</Label>

</ParameterValue>

</ParameterValues>

</ValidValues>

</ReportParameter>

</ReportParameters>

<rd:DrawGrid>true</rd:DrawGrid>

<InteractiveWidth>8.5in</InteractiveWidth>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<ReportItems>

<Textbox Name="textbox35">

<Top>3.875in</Top>

<ZIndex>2</ZIndex>

<Width>2.75in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>="Total Students: " &amp; Count(Fields!StudentNumber.Value, "dsHeaderData")</Value>

</Textbox>

<List Name="list1">

<ReportItems>

<Table Name="table4">

<DataSetName>dsActions</DataSetName>

<Top>3.125in</Top>

<ZIndex>23</ZIndex>

<Width>7.25in</Width>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="StudentID_1">

<rd:DefaultName>StudentID_1</rd:DefaultName>

<ZIndex>5</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Sum(Fields!StudentID.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceID_1">

<rd:DefaultName>OccurrenceID_1</rd:DefaultName>

<ZIndex>4</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Sum(Fields!OccurrenceID.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="ActionName">

<rd:DefaultName>ActionName</rd:DefaultName>

<ZIndex>3</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!ActionName.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceActionDate">

<rd:DefaultName>OccurrenceActionDate</rd:DefaultName>

<ZIndex>2</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!OccurrenceActionDate.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceActionTime">

<rd:DefaultName>OccurrenceActionTime</rd:DefaultName>

<ZIndex>1</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!OccurrenceActionTime.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Note_1">

<rd:DefaultName>Note_1</rd:DefaultName>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!Note.Value, "dsActions")</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<Grouping Name="table4_Details_Group">

<GroupExpressions>

<GroupExpression>=Fields!OccurrenceID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</Details>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox22">

<rd:DefaultName>textbox22</rd:DefaultName>

<ZIndex>11</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox30">

<rd:DefaultName>textbox30</rd:DefaultName>

<ZIndex>10</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>O ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox23">

<rd:DefaultName>textbox23</rd:DefaultName>

<ZIndex>9</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Action</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox24">

<rd:DefaultName>textbox24</rd:DefaultName>

<ZIndex>8</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Date</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox29">

<rd:DefaultName>textbox29</rd:DefaultName>

<ZIndex>7</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Time</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox40">

<rd:DefaultName>textbox40</rd:DefaultName>

<ZIndex>6</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Note</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

</Header>

<TableColumns>

<TableColumn>

<Width>0.25in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>0.375in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>1.75in</Width>

</TableColumn>

<TableColumn>

<Width>1in</Width>

</TableColumn>

<TableColumn>

<Width>0.875in</Width>

</TableColumn>

<TableColumn>

<Width>3in</Width>

</TableColumn>

</TableColumns>

</Table>

<Table Name="table3">

<DataSetName>dsDispositions</DataSetName>

<Top>2.625in</Top>

<ZIndex>22</ZIndex>

<Width>7.25in</Width>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="StudentID_2">

<rd:DefaultName>StudentID_2</rd:DefaultName>

<ZIndex>5</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!StudentID.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceID_2">

<rd:DefaultName>OccurrenceID_2</rd:DefaultName>

<ZIndex>4</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!OccurrenceID.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="DispositionName_1">

<rd:DefaultName>DispositionName_1</rd:DefaultName>

<ZIndex>3</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!DispositionName.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="DispositionStartDate_1">

<rd:DefaultName>DispositionStartDate_1</rd:DefaultName>

<ZIndex>2</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!DispositionStartDate.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="DispositionEndDate_1">

<rd:DefaultName>DispositionEndDate_1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!DispositionEndDate.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Note">

<rd:DefaultName>Note</rd:DefaultName>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!Note.Value, "dsDispositions")</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<Grouping Name="table3_Details_Group">

<GroupExpressions>

<GroupExpression>=Fields!OccurrenceID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</Details>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox7">

<rd:DefaultName>textbox7</rd:DefaultName>

<ZIndex>11</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox26">

<rd:DefaultName>textbox26</rd:DefaultName>

<ZIndex>10</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>O ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox9">

<rd:DefaultName>textbox9</rd:DefaultName>

<ZIndex>9</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Disposition</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox10">

<rd:DefaultName>textbox10</rd:DefaultName>

<ZIndex>8</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Start Date</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox43">

<rd:DefaultName>textbox43</rd:DefaultName>

<ZIndex>7</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>End Date</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox47">

<rd:DefaultName>textbox47</rd:DefaultName>

<ZIndex>6</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Note</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

</Header>

<TableColumns>

<TableColumn>

<Width>0.25in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>0.375in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>1.75in</Width>

</TableColumn>

<TableColumn>

<Width>1in</Width>

</TableColumn>

<TableColumn>

<Width>0.875in</Width>

</TableColumn>

<TableColumn>

<Width>3in</Width>

</TableColumn>

</TableColumns>

<Height>0.5in</Height>

</Table>

<Table Name="table2">

<DataSetName>dsInfractions</DataSetName>

<Top>2.125in</Top>

<TableGroups>

<TableGroup>

<Grouping Name="table2_Group1">

<GroupExpressions>

<GroupExpression>=Fields!StudentID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</TableGroup>

</TableGroups>

<ZIndex>21</ZIndex>

<Width>7.25in</Width>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="StudentID_4">

<rd:DefaultName>StudentID_4</rd:DefaultName>

<ZIndex>4</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!StudentID.Value, "dsInfractions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceID_3">

<rd:DefaultName>OccurrenceID_3</rd:DefaultName>

<ZIndex>3</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!OccurrenceID.Value, "dsInfractions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="InfractionName_1">

<rd:DefaultName>InfractionName_1</rd:DefaultName>

<ZIndex>2</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!InfractionName.Value, "dsInfractions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="NumberOfDemeritsEarned_1">

<rd:DefaultName>NumberOfDemeritsEarned_1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Sum(Fields!NumberOfDemeritsEarned.Value, "dsInfractions")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Note_3">

<rd:DefaultName>Note_3</rd:DefaultName>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=First(Fields!Note.Value, "dsInfractions")</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<Grouping Name="table2_Details_Group">

<GroupExpressions>

<GroupExpression>=Fields!OccurrenceID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</Details>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox3">

<rd:DefaultName>textbox3</rd:DefaultName>

<ZIndex>9</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox25">

<rd:DefaultName>textbox25</rd:DefaultName>

<ZIndex>8</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>O ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox5">

<rd:DefaultName>textbox5</rd:DefaultName>

<ZIndex>7</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Infraction</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox6">

<rd:DefaultName>textbox6</rd:DefaultName>

<ZIndex>6</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Demerits Earned</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox42">

<rd:DefaultName>textbox42</rd:DefaultName>

<ZIndex>5</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Note</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

</Header>

<TableColumns>

<TableColumn>

<Width>0.25in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>0.375in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>1.75in</Width>

</TableColumn>

<TableColumn>

<Width>1.125in</Width>

</TableColumn>

<TableColumn>

<Width>3.75in</Width>

</TableColumn>

</TableColumns>

<Height>0.5in</Height>

</Table>

<Table Name="table1">

<TableGroups>

<TableGroup>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox1">

<rd:DefaultName>textbox1</rd:DefaultName>

<ZIndex>14</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox31">

<rd:DefaultName>textbox31</rd:DefaultName>

<ZIndex>13</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox2">

<rd:DefaultName>textbox2</rd:DefaultName>

<ZIndex>12</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ColSpan>6</ColSpan>

<ReportItems>

<Textbox Name="textbox32">

<rd:DefaultName>textbox32</rd:DefaultName>

<ZIndex>11</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=iif(Parameters!GroupBy.Value = " ", " ", Parameters!GroupBy.Label &amp; ":" &amp; " " &amp; " "&amp;Fields(Parameters!GroupBy.Value).Value) &amp;" "&amp; "Total Students in Group:" &amp; " " &amp; Count(Fields!StudentNumber.Value)</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox49">

<rd:DefaultName>textbox49</rd:DefaultName>

<ZIndex>10</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

</Header>

<Grouping Name="table1_Group1">

<GroupExpressions>

<GroupExpression>=Fields!StudentID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</TableGroup>

</TableGroups>

<ZIndex>20</ZIndex>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="StudentID">

<rd:DefaultName>StudentID</rd:DefaultName>

<ZIndex>9</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!StudentID.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="OccurrenceID">

<rd:DefaultName>OccurrenceID</rd:DefaultName>

<ZIndex>8</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!OccurrenceID.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="StudentNumber_1">

<rd:DefaultName>StudentNumber_1</rd:DefaultName>

<ZIndex>7</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!StudentNumber.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="StudentName_1">

<rd:DefaultName>StudentName_1</rd:DefaultName>

<ZIndex>6</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!StudentName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="GradeLevelName_1">

<rd:DefaultName>GradeLevelName_1</rd:DefaultName>

<ZIndex>5</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!GradeLevelName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="HomeroomName_1">

<rd:DefaultName>HomeroomName_1</rd:DefaultName>

<ZIndex>4</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!HomeroomName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="GenderDescriptor_1">

<rd:DefaultName>GenderDescriptor_1</rd:DefaultName>

<ZIndex>3</ZIndex>

<Style>

<TextAlign>Center</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!GenderDescriptor.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="DateOfBirth_1">

<rd:DefaultName>DateOfBirth_1</rd:DefaultName>

<ZIndex>2</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!DateOfBirth.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="EthnicityName_1">

<rd:DefaultName>EthnicityName_1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!EthnicityName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Phone_1">

<rd:DefaultName>Phone_1</rd:DefaultName>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!Phone.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<Grouping Name="table1_Details_Group">

<GroupExpressions>

<GroupExpression>=Fields!StudentID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</Details>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox36">

<rd:DefaultName>textbox36</rd:DefaultName>

<ZIndex>24</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox27">

<rd:DefaultName>textbox27</rd:DefaultName>

<ZIndex>23</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>O ID</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox37">

<rd:DefaultName>textbox37</rd:DefaultName>

<ZIndex>22</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Number</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox38">

<rd:DefaultName>textbox38</rd:DefaultName>

<ZIndex>21</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Name</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox45">

<rd:DefaultName>textbox45</rd:DefaultName>

<ZIndex>20</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>GR</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox48">

<rd:DefaultName>textbox48</rd:DefaultName>

<ZIndex>19</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Home</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox51">

<rd:DefaultName>textbox51</rd:DefaultName>

<ZIndex>18</ZIndex>

<Style>

<TextAlign>Center</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>G</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox54">

<rd:DefaultName>textbox54</rd:DefaultName>

<ZIndex>17</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Birthdate</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox57">

<rd:DefaultName>textbox57</rd:DefaultName>

<ZIndex>16</ZIndex>

<Style>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Ethnic</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox60">

<rd:DefaultName>textbox60</rd:DefaultName>

<ZIndex>15</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Phone</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

</Header>

<TableColumns>

<TableColumn>

<Width>0.125in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>0.125in</Width>

<Visibility>

<Hidden>true</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>0.625in</Width>

</TableColumn>

<TableColumn>

<Width>1.75in</Width>

</TableColumn>

<TableColumn>

<Width>0.375in</Width>

</TableColumn>

<TableColumn>

<Width>0.5in</Width>

</TableColumn>

<TableColumn>

<Width>0.25in</Width>

</TableColumn>

<TableColumn>

<Width>0.75in</Width>

</TableColumn>

<TableColumn>

<Width>1.5in</Width>

</TableColumn>

<TableColumn>

<Width>1.5in</Width>

</TableColumn>

</TableColumns>

<Height>0.75in</Height>

</Table>

<Line Name="line1">

<Top>2in</Top>

<ZIndex>19</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

</Style>

<Height>0in</Height>

</Line>

<Textbox Name="textbox21">

<Left>4.625in</Left>

<Top>1.625in</Top>

<ZIndex>18</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Date:</Value>

</Textbox>

<Textbox Name="textbox20">

<Left>4.625in</Left>

<Top>1.375in</Top>

<ZIndex>17</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Admin:</Value>

</Textbox>

<Textbox Name="textbox19">

<Left>4.625in</Left>

<Top>1.125in</Top>

<ZIndex>16</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Location:</Value>

</Textbox>

<Textbox Name="AdministeredDate">

<Left>5.25in</Left>

<Top>1.625in</Top>

<rd:DefaultName>AdministeredDate</rd:DefaultName>

<ZIndex>15</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!AdministeredDate.Value</Value>

</Textbox>

<Textbox Name="AdministeredName">

<Left>5.25in</Left>

<Top>1.375in</Top>

<rd:DefaultName>AdministeredName</rd:DefaultName>

<ZIndex>14</ZIndex>

<Width>1.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!AdministeredName.Value</Value>

</Textbox>

<Textbox Name="Location">

<Left>5.25in</Left>

<Top>1.125in</Top>

<rd:DefaultName>Location</rd:DefaultName>

<ZIndex>13</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!Location.Value</Value>

</Textbox>

<Textbox Name="textbox17">

<Left>2.5in</Left>

<Top>1.625in</Top>

<ZIndex>12</ZIndex>

<Width>0.5in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Name:</Value>

</Textbox>

<Textbox Name="ShortName">

<Left>3in</Left>

<Top>1.625in</Top>

<rd:DefaultName>ShortName</rd:DefaultName>

<ZIndex>11</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!ShortName.Value</Value>

</Textbox>

<Textbox Name="textbox16">

<Left>4.625in</Left>

<Top>0.875in</Top>

<ZIndex>10</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Teacher:</Value>

</Textbox>

<Textbox Name="textbox15">

<Left>2.5in</Left>

<Top>1.375in</Top>

<ZIndex>9</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Number:</Value>

</Textbox>

<Textbox Name="textbox14">

<Left>2.5in</Left>

<Top>1.125in</Top>

<ZIndex>8</ZIndex>

<Width>0.5in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Period:</Value>

</Textbox>

<Textbox Name="textbox13">

<Left>2.5in</Left>

<Top>0.875in</Top>

<ZIndex>7</ZIndex>

<Width>0.5in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Date:</Value>

</Textbox>

<Textbox Name="PrimaryTeacherDisplayName">

<Left>5.25in</Left>

<Top>0.875in</Top>

<rd:DefaultName>PrimaryTeacherDisplayName</rd:DefaultName>

<ZIndex>6</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!PrimaryTeacherDisplayName.Value</Value>

</Textbox>

<Textbox Name="FullSectionNumber">

<Left>3.125in</Left>

<Top>1.375in</Top>

<rd:DefaultName>FullSectionNumber</rd:DefaultName>

<ZIndex>5</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!FullSectionNumber.Value</Value>

</Textbox>

<Textbox Name="TimeSlot">

<Left>3in</Left>

<Top>1.125in</Top>

<rd:DefaultName>TimeSlot</rd:DefaultName>

<ZIndex>4</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!TimeSlot.Value</Value>

</Textbox>

<Textbox Name="OccurrenceDate">

<Left>3in</Left>

<Top>0.875in</Top>

<rd:DefaultName>OccurrenceDate</rd:DefaultName>

<ZIndex>3</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!OccurrenceDate.Value</Value>

</Textbox>

<Textbox Name="textbox11">

<Top>0.875in</Top>

<ZIndex>2</ZIndex>

<Width>0.625in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Address:</Value>

</Textbox>

<Textbox Name="AddressLine2">

<Left>0.625in</Left>

<Top>1.125in</Top>

<rd:DefaultName>AddressLine2</rd:DefaultName>

<ZIndex>1</ZIndex>

<Width>1.5in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!AddressLine2.Value</Value>

</Textbox>

<Textbox Name="AddressLine1">

<Left>0.625in</Left>

<Top>0.875in</Top>

<rd:DefaultName>AddressLine1</rd:DefaultName>

<Width>1.5in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontSize>8pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!AddressLine1.Value</Value>

</Textbox>

</ReportItems>

<DataSetName>dsHeaderData</DataSetName>

<ZIndex>1</ZIndex>

<Grouping Name="list1_Details_Group">

<PageBreakAtEnd>true</PageBreakAtEnd>

<Parent>=Fields!OccurrenceID.Value</Parent>

<GroupExpressions>

<GroupExpression>=Fields!StudentID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Height>3.625in</Height>

</List>

<Line Name="line2">

<Top>3.75in</Top>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<BorderWidth>

<Default>2pt</Default>

</BorderWidth>

</Style>

<Height>0in</Height>

</Line>

</ReportItems>

<Height>4.25in</Height>

</Body>

<PageHeader>

<ReportItems>

<Rectangle Name="rectangle2">

<ReportItems>

<Textbox Name="textbox34">

<ZIndex>2</ZIndex>

<Width>2.125in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>12pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>= iif(Parameters!CustomReportTitle.Value = "","Discipline Report", "")</Value>

</Textbox>

<Textbox Name="textbox4">

<Left>2.5in</Left>

<ZIndex>1</ZIndex>

<Width>2.125in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>12pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>= iif(Parameters!CustomReportTitle.Value &lt;&gt; " ",Parameters!CustomReportTitle.Value, "")</Value>

</Textbox>

<Textbox Name="textbox28">

<Top>0.25in</Top>

<Width>7.375in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>="Report Filters - "</Value>

</Textbox>

</ReportItems>

<Style>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

</Style>

</Rectangle>

</ReportItems>

<Height>0.5in</Height>

<PrintOnLastPage>true</PrintOnLastPage>

<PrintOnFirstPage>true</PrintOnFirstPage>

</PageHeader>

<rd:ReportID>ae97d07c-7c7a-4b37-aea3-4558dd51b029</rd:ReportID>

<LeftMargin>0.5in</LeftMargin>

<DataSets>

<DataSet Name="dsHeaderData">

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>p_000016_GetHeader</CommandText>

<QueryParameters>

<QueryParameter Name="@.AcadSessionID">

<Value>=Parameters!AcadSessionID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StudentFilterID">

<Value>=Parameters!StudentFilterID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StartOccurrenceDate">

<Value>=Parameters!StartOccurrenceDate.Value</Value>

</QueryParameter>

<QueryParameter Name="@.EndOccurrenceDate">

<Value>=Parameters!EndOccurrenceDate.Value</Value>

</QueryParameter>

<QueryParameter Name="@.IncludeWithdrawn">

<Value>=Parameters!IncludeWithdrawn.Value</Value>

</QueryParameter>

<QueryParameter Name="@.IncludeUnlisted">

<Value>=Parameters!IncludeUnlisted.Value</Value>

</QueryParameter>

<QueryParameter Name="@.CustomReportTitle">

<Value>=Parameters!CustomReportTitle.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OrderBy">

<Value>=Parameters!OrderBy.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="OccurrenceID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>OccurrenceID</DataField>

</Field>

<Field Name="StudentID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>StudentID</DataField>

</Field>

<Field Name="OccurrenceDate">

<rd:TypeName>System.String</rd:TypeName>

<DataField>OccurrenceDate</DataField>

</Field>

<Field Name="FullSectionNumber">

<rd:TypeName>System.String</rd:TypeName>

<DataField>FullSectionNumber</DataField>

</Field>

<Field Name="ShortName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>ShortName</DataField>

</Field>

<Field Name="PrimaryTeacherDisplayName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>PrimaryTeacherDisplayName</DataField>

</Field>

<Field Name="TimeSlot">

<rd:TypeName>System.String</rd:TypeName>

<DataField>TimeSlot</DataField>

</Field>

<Field Name="Location">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Location</DataField>

</Field>

<Field Name="AdministeredName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>AdministeredName</DataField>

</Field>

<Field Name="AdministeredDate">

<rd:TypeName>System.String</rd:TypeName>

<DataField>AdministeredDate</DataField>

</Field>

<Field Name="StudentNumber">

<rd:TypeName>System.String</rd:TypeName>

<DataField>StudentNumber</DataField>

</Field>

<Field Name="StudentName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>StudentName</DataField>

</Field>

<Field Name="GradeLevelName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>GradeLevelName</DataField>

</Field>

<Field Name="HomeroomName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>HomeroomName</DataField>

</Field>

<Field Name="GenderDescriptor">

<rd:TypeName>System.String</rd:TypeName>

<DataField>GenderDescriptor</DataField>

</Field>

<Field Name="DateOfBirth">

<rd:TypeName>System.String</rd:TypeName>

<DataField>DateOfBirth</DataField>

</Field>

<Field Name="EthnicityName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>EthnicityName</DataField>

</Field>

<Field Name="AddressLine1">

<rd:TypeName>System.String</rd:TypeName>

<DataField>AddressLine1</DataField>

</Field>

<Field Name="AddressLine2">

<rd:TypeName>System.String</rd:TypeName>

<DataField>AddressLine2</DataField>

</Field>

<Field Name="Phone">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Phone</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsAcadSession">

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>select acadsessionID from studentacadsession</CommandText>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="acadsessionID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>acadsessionID</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsDistrict">

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>select districtname from district</CommandText>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="districtname">

<rd:TypeName>System.String</rd:TypeName>

<DataField>districtname</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsInfractions">

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>p_000016_GetInfractions</CommandText>

<QueryParameters>

<QueryParameter Name="@.AcadSessionID">

<Value>=Parameters!AcadSessionID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.XmlInfractions">

<Value>=Parameters!XmlInfractions.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OrderBy">

<Value>=Parameters!OrderBy.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OccurrenceID">

<Value>=Parameters!OccurrenceID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StudentID">

<Value>=Parameters!StudentID.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="StudentID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>StudentID</DataField>

</Field>

<Field Name="OccurrenceID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>OccurrenceID</DataField>

</Field>

<Field Name="InfractionName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>InfractionName</DataField>

</Field>

<Field Name="NumberOfDemeritsEarned">

<rd:TypeName>System.Byte</rd:TypeName>

<DataField>NumberOfDemeritsEarned</DataField>

</Field>

<Field Name="Note">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Note</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsDispositions">

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>p_000016_GetDispositions</CommandText>

<QueryParameters>

<QueryParameter Name="@.AcadSessionID">

<Value>=Parameters!AcadSessionID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StartDispositionDate">

<Value>=Parameters!StartDispositionDate.Value</Value>

</QueryParameter>

<QueryParameter Name="@.EndDispositionDate">

<Value>=Parameters!EndDispositionDate.Value</Value>

</QueryParameter>

<QueryParameter Name="@.XmlDispositions">

<Value>=Parameters!XmlDispositions.Value</Value>

</QueryParameter>

<QueryParameter Name="@.DisplayDispositions">

<Value>=Parameters!DisplayDispositions.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OrderBy">

<Value>=Parameters!OrderBy.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OccurrenceID">

<Value>=Parameters!OccurrenceID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StudentID">

<Value>=Parameters!StudentID.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="StudentID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>StudentID</DataField>

</Field>

<Field Name="OccurrenceID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>OccurrenceID</DataField>

</Field>

<Field Name="DispositionName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>DispositionName</DataField>

</Field>

<Field Name="DispositionStartDate">

<rd:TypeName>System.String</rd:TypeName>

<DataField>DispositionStartDate</DataField>

</Field>

<Field Name="DispositionEndDate">

<rd:TypeName>System.String</rd:TypeName>

<DataField>DispositionEndDate</DataField>

</Field>

<Field Name="Note">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Note</DataField>

</Field>

<Field Name="Dispositions">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Dispositions</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsActions">

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>p_000016_GetActions</CommandText>

<QueryParameters>

<QueryParameter Name="@.AcadSessionID">

<Value>=Parameters!AcadSessionID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.OccurrenceID">

<Value>=Parameters!OccurrenceID.Value</Value>

</QueryParameter>

<QueryParameter Name="@.XmlActions">

<Value>=Parameters!XmlActions.Value</Value>

</QueryParameter>

<QueryParameter Name="@.StudentID">

<Value>=Parameters!StudentID.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>FozzieDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="StudentID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>StudentID</DataField>

</Field>

<Field Name="OccurrenceID">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>OccurrenceID</DataField>

</Field>

<Field Name="ActionName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>ActionName</DataField>

</Field>

<Field Name="OccurrenceActionDate">

<rd:TypeName>System.String</rd:TypeName>

<DataField>OccurrenceActionDate</DataField>

</Field>

<Field Name="OccurrenceActionTime">

<rd:TypeName>System.String</rd:TypeName>

<DataField>OccurrenceActionTime</DataField>

</Field>

<Field Name="Note">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Note</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

<Code />

<Width>7.5in</Width>

<InteractiveHeight>11in</InteractiveHeight>

<Language>en-US</Language>

<PageFooter>

<ReportItems>

<Rectangle Name="rectangle1">

<ReportItems>

<Textbox Name="Copyright">

<Left>4.25in</Left>

<ZIndex>3</ZIndex>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontSize>6pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.2in</Height>

<Value>=Globals!ExecutionTime</Value>

</Textbox>

<Textbox Name="textbox8">

<Left>4.625in</Left>

<Top>0.25in</Top>

<rd:DefaultName>textbox8</rd:DefaultName>

<ZIndex>2</ZIndex>

<Width>2.85in</Width>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontSize>6pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<Value>=("Copyright ? Software Technology, Inc. 2006 " )&amp; "ST.US.000016.001"</Value>

</Textbox>

<Textbox Name="textbox12">

<Top>0.25in</Top>

<ZIndex>1</ZIndex>

<Width>3.25in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontSize>6pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Parameters!DistrictName.Label</Value>

</Textbox>

<Textbox Name="textbox18">

<Width>3.25in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontSize>6pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.2in</Height>

<Value>="Page " &amp; Globals!PageNumber &amp; " of " &amp; Globals!TotalPages</Value>

</Textbox>

</ReportItems>

<Style>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

</Style>

</Rectangle>

</ReportItems>

<Height>0.45in</Height>

<PrintOnLastPage>true</PrintOnLastPage>

<PrintOnFirstPage>true</PrintOnFirstPage>

</PageFooter>

<TopMargin>0.5in</TopMargin>

</Report>

|||Looks like you have one top level List (list1) and four tables inside of the list. The dataset for list1 is "dsHeaderData", since all inner data regions will use the same dataset, all your tables will use "dsHeaderData" as well. Is this the intended behavior?|||

It is not, three of the tables have their own individual datasets. I changed the rdl to include a subreport for the three detail tables without any grouping passing the situation from the subreport to the main rdl and this corrected my problem.

Thank you so much for your help.