﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="1">
      <Barn Ref="2" type="DataTableSource" isKey="true">
        <Alias>Barn</Alias>
        <Columns isList="true" count="2">
          <value>Tid,System.DateTime</value>
          <value>Antal_x0020_barn,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Barn</Name>
        <NameInSource>Schema förskola.Barn</NameInSource>
      </Barn>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="6">
      <value>,ddd,ddd,System.DateTime,_x0031__x002F_17_x002F_2008_x0020_12:00:00_x0020_AM,False,False</value>
      <value>,mmm,mmm,System.Int32,_x0030_,False,False</value>
      <value>,yyy,yyy,System.Int32,_x0030_,False,False</value>
      <value>,Varningsgränsvärde,Varningsgränsvärde,System.Int32,_x0030_,False,False</value>
      <value>,Vecka,Vecka,System.Int32,_x0032_,False,False</value>
      <value>,Schemalösa_barn,Schemalösa_barn,System.Int32,_x0034_8,False,False</value>
    </Variables>
  </Dictionary>
  <EndRenderEvent>foreach (StiPage page in this.RenderedPages)
{
	double maxH = 0;
	double maxW = 0;
	foreach (StiComponent comp in page.GetComponents())
	{
		if (comp.Bottom &gt; maxH) maxH = comp.Bottom;
		if (comp.Right &gt; maxW) maxW = comp.Right;
	}
    page.PageHeight = maxH + page.Margins.Top + page.Margins.Bottom;
	page.PageWidth = maxW + page.Margins.Left + page.Margins.Right;
}</EndRenderEvent>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="3" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <CrossTab1 Ref="4" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Border>Left, Right, Bottom;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0,15,1.4</ClientRectangle>
          <Components isList="true" count="8">
            <CrossTab1_RowTotal1 Ref="5" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,1.3,0.8,0</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>0a1a127a5afd45ad9af0b2f3e26cf24c</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal1>
            <CrossTab1_Row1_Title Ref="6" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.25,0.6,0.6</ClientRectangle>
              <Font>Arial,9.75,Regular,Point,False,0</Font>
              <Guid>68211045ba2c44858fd8392c27cbddc2</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Tid</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
            </CrossTab1_Row1_Title>
            <CrossTab1_ColTotal1 Ref="7" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>1.45,0.45,0,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>fd46c5c4bdb0411396b4966d95c778e6</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_LeftTitle Ref="8" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0,0.6,0.2</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>36bc0124de43437a8baac71b363a6165</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>LeftTitle</TypeOfComponent>
            </CrossTab1_LeftTitle>
            <CrossTab1_RightTitle Ref="9" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.65,0,2,0.2</ClientRectangle>
              <Font>Arial,15.75,Regular,Point,False,0</Font>
              <Guid>afbf1909add84913b1a52a95dd32d130</Guid>
              <Margins>5,5,5,5</Margins>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Antal barn schemalagda under vecka {Vecka}</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <Type>Expression</Type>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
            <CrossTab1_Row1 Ref="10" type="CrossRow" isKey="true">
              <Alias>Tid</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.9,0.6,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Format("{0:HH:mm}", Barn.Tid)}</DisplayValue>
              <Font>Arial,9.75,Regular,Point,False,0</Font>
              <Guid>5768794659e2440798ec5556306cbd31</Guid>
              <Margins>10,10,1,1</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>Tid</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>0a1a127a5afd45ad9af0b2f3e26cf24c</TotalGuid>
              <Value>{Hour(Barn.Tid)}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Column1 Ref="11" type="CrossColumn" isKey="true">
              <Alias>Tid</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.65,0.25,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{DayOfWeek(Barn.Tid)}</DisplayValue>
              <Font>Arial,9.75,Bold,Point,False,0</Font>
              <Guid>ec33540859de4d03babe3e6fd827f448</Guid>
              <Margins>0,0,0,0</Margins>
              <MinSize>2,0</MinSize>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <SortDirection>None</SortDirection>
              <Text>Tid</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>fd46c5c4bdb0411396b4966d95c778e6</TotalGuid>
              <Value>{DayOfWeek(Barn.Tid)}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="12" type="CrossSummary" isKey="true">
              <Alias>Antal barn</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.65,0.9,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9.75,Regular,Point,False,0</Font>
              <Guid>8f18c108c236496b827e127f584e1f36</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <ProcessCellEvent>if (e.Value &gt; Varningsgränsvärde)
	e.Cell.Field.TextBrush = new StiSolidBrush(Color.Red);</ProcessCellEvent>
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <Value>{Barn.Antal_barn}</Value>
            </CrossTab1_Sum1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>Barn</DataSourceName>
          <DockStyle>Top</DockStyle>
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Locked>True</Locked>
          <Name>CrossTab1</Name>
          <Page isRef="3" />
          <Parent isRef="3" />
          <PrintIfEmpty>False</PrintIfEmpty>
          <Sort isList="true" count="0" />
        </CrossTab1>
        <Text1 Ref="13" type="Text" isKey="true">
          <AutoWidth>True</AutoWidth>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.4,15,11.6</ClientRectangle>
          <Conditions isList="true" count="0" />
          <DockStyle>Left</DockStyle>
          <Font>Arial,9.75,Bold,Point,False,0</Font>
          <Margins>0,0,0,0</Margins>
          <Name>Text1</Name>
          <Page isRef="3" />
          <Parent isRef="3" />
          <Text>Antal barn utan schema {Schemalösa_barn}</Text>
          <TextBrush>Black</TextBrush>
          <Type>Expression</Type>
        </Text1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>db5f8582283d4ad381d7052944905cc9</Guid>
      <Margins>0,0,0,0</Margins>
      <Name>Page1</Name>
      <PageHeight>13</PageHeight>
      <PageWidth>15</PageWidth>
      <Report isRef="0" />
      <StretchToPrintArea>True</StretchToPrintArea>
      <UnlimitedHeight>True</UnlimitedHeight>
      <Watermark Ref="14" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="15" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>7/3/2014 9:25:20 AM</ReportChanged>
  <ReportCreated>6/23/2014 2:04:53 PM</ReportCreated>
  <ReportFile>C:\src\Edu\Services\Education\Internal\Host\WE.Education.Internal.Host\Reports\PlanningPreschool\ChildrenWeek.mrt</ReportFile>
  <ReportGuid>fac012a57ddf4cee9409c39a527de837</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2014.1.1810</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
		#endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="1">
    <Style1 Ref="16" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,8</Font>
      <Name>Style1</Name>
      <TextBrush>Black</TextBrush>
    </Style1>
  </Styles>
</StiSerializer>