Showing posts with label extracting. Show all posts
Showing posts with label extracting. Show all posts

Tuesday, March 20, 2012

Problem Extracting DTS to Excel

HI,

I'm creating an Scheduled DTS to extract Sales data into Excel and Email the Excel sheet and I almost have it complete :) Apart of one small problem. (The bit I though would be easy).

The DTS is Emailing, scheduling and executing ok.

I have had to write a little bit of VBscript to cleardown the contents of the Excel fle before I begin loading the data each time, but when the data is loaded into Excel it does not start at the first Cell but maybe 700 lines down the worksheet

I think it is my VBscript that is the problem but I'm not sure. Has anyone else had problems like this?

Example

For Each Excel_WorkSheet in Excel_WorkBook.WorkSheets
If Excel_WorkSheet.Name = CStr(sSheetName) Then
Excel_WorkBook.Worksheets(sSheetName).Range
("A2:IV65536").ClearContents
Excel_WorkBook.Save
bFound = True
Exit For
End if
Nexti haven't looked into excel object, but can't you issue something like Excel_WorkBook.Home before you do Excel_WorkBook.Save?|||Have you tried deleting the range rather than clearing the contents ? Why do you need to do this ?
Posted by versatilitytyuh at 1:02 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

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.

Posted by versatilitytyuh at 1:02 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)