You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
154 lines
13 KiB
154 lines
13 KiB
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ScriptLanguage="Vb" ReportInfo.Created="08/21/2011 20:13:57" ReportInfo.Modified="06/06/2013 09:59:48" ReportInfo.CreatorVersion="2013.2.2.0">
|
|
<ScriptText>Imports System
|
|
Imports System.Collections
|
|
Imports System.Collections.Generic
|
|
Imports System.ComponentModel
|
|
Imports System.Windows.Forms
|
|
Imports System.Drawing
|
|
Imports Microsoft.VisualBasic
|
|
Imports FastReport
|
|
Imports FastReport.Data
|
|
Imports FastReport.Dialog
|
|
Imports FastReport.Table
|
|
Imports FastReport.Barcode
|
|
Imports FastReport.Utils
|
|
|
|
Namespace FastReport
|
|
Public Class ReportScript
|
|
|
|
|
|
|
|
|
|
Private Sub Picture1_BeforePrint(ByVal sender As object, ByVal e As EventArgs)
|
|
Picture1.ImageLocation= CType(Report.GetParameterValue("URL"), String)
|
|
End Sub
|
|
End Class
|
|
End Namespace
|
|
</ScriptText>
|
|
<Dictionary>
|
|
<TableDataSource Name="Daten" ReferenceName="Data.Daten" DataType="System.Int32" Enabled="true">
|
|
<Column Name="Berufnr" DataType="System.Int64"/>
|
|
<Column Name="Bezeichnung" DataType="System.String"/>
|
|
<Column Name="Beruf" DataType="System.String"/>
|
|
<Column Name="NameZ1" DataType="System.String"/>
|
|
<Column Name="Zeit" DataType="System.String"/>
|
|
<Column Name="AnzZuteilungen" DataType="System.Int32"/>
|
|
<Column Name="AnzahlAngebot" DataType="System.Int32"/>
|
|
<Column Name="MinZuteilung" DataType="System.Int32"/>
|
|
<Column Name="Nachgefragt" DataType="System.Int32"/>
|
|
<Column Name="FirmaBerufNr" DataType="System.Int32"/>
|
|
<Column Name="KlasseNr" DataType="System.Int32"/>
|
|
<Column Name="pk" DataType="System.Int32"/>
|
|
<Column Name="TotalAnzahlNachgefragt" DataType="System.Int32"/>
|
|
<Column Name="TotalZugeteilt" DataType="System.Int32"/>
|
|
<Column Name="TotalAngebot" DataType="System.Int32"/>
|
|
<Column Name="tap1" DataType="System.Int32"/>
|
|
<Column Name="tzp1" DataType="System.Int32"/>
|
|
<Column Name="tap2" DataType="System.Int32"/>
|
|
<Column Name="tzp2" DataType="System.Int32"/>
|
|
<Column Name="tap3" DataType="System.Int32"/>
|
|
<Column Name="tzp3" DataType="System.Int32"/>
|
|
<Column Name="tap4" DataType="System.Int32"/>
|
|
<Column Name="tzp4" DataType="System.Int32"/>
|
|
<Column Name="tap5" DataType="System.Int32"/>
|
|
<Column Name="tzp5" DataType="System.Int32"/>
|
|
<Column Name="TA" DataType="System.Int32"/>
|
|
<Column Name="TZ" DataType="System.Int32"/>
|
|
<Column Name="TotalSchueler" DataType="System.Int32"/>
|
|
<Column Name="TotalZuWenigZuteilung" DataType="System.Int32"/>
|
|
<Column Name="ZuWenigZugeteilt" DataType="System.Int32"/>
|
|
</TableDataSource>
|
|
<Parameter Name="Parcours" DataType="System.String"/>
|
|
<Parameter Name="Spruch" DataType="System.String"/>
|
|
<Parameter Name="URL" DataType="System.String"/>
|
|
<Total Name="Total" Expression="[Daten.AnzahlAngebot]" Evaluator="Data1" PrintOn="GroupFooter2"/>
|
|
<Total Name="Total1" Expression="[Daten.AnzZuteilungen]" Evaluator="Data1" PrintOn="GroupFooter2"/>
|
|
</Dictionary>
|
|
<ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9">
|
|
<PageHeaderBand Name="PageHeader1" Width="1047.06" Height="151.2">
|
|
<TextObject Name="Text6" Left="557.55" Width="463.05" Height="18.9" Text="[Parcours]" HorzAlign="Right" Font="Arial, 12pt, style=Bold"/>
|
|
<TextObject Name="Text22" Left="557.55" Top="28.35" Width="463.05" Height="18.9" Text="Berufe / Firmen / Zuteilungen" HorzAlign="Right" Font="Arial, 12pt, style=Bold"/>
|
|
<PictureObject Name="Picture1" Left="37.8" Width="141.75" Height="122.85" BeforePrintEvent="Picture1_BeforePrint"/>
|
|
<TextObject Name="Text9" Left="37.8" Top="132.3" Width="94.5" Height="18.9" Text="Beruf" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text23" Left="283.5" Top="132.3" Width="66.15" Height="18.9" Text="Firma" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text24" Left="585.9" Top="132.3" Width="94.5" Height="18.9" Text="Zeit" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text25" Left="746.55" Top="132.3" Width="66.15" Height="18.9" Text="Angebot" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text26" Left="812.7" Top="132.3" Width="66.15" Height="18.9" Text="Zugeteilt" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text27" Left="982.8" Top="132.3" Width="37.8" Height="18.9" Text="Min." HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text28" Left="689.85" Top="132.3" Width="47.25" Height="18.9" Text="Typ" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text29" Left="878.85" Top="117.85" Width="94.5" Height="28.35" Text="Total nachgefragt" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<LineObject Name="Line2" Left="37.8" Top="151.2" Width="982.8"/>
|
|
</PageHeaderBand>
|
|
<GroupHeaderBand Name="GroupHeader1" Top="155.2" Width="1047.06" Height="18.9" FirstRowStartsNewPage="true" KeepWithData="true" Condition="[Daten.Beruf]" KeepTogether="true">
|
|
<TextObject Name="Text4" Left="37.8" Width="28.35" Height="18.9" Text="[Daten.Berufnr]" Duplicates="Hide" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text1" Left="75.6" Width="349.65" Height="18.9" CanGrow="true" Text="[Daten.Beruf]" Duplicates="Hide" Font="Arial, 9pt"/>
|
|
<GroupHeaderBand Name="GroupHeader2" Top="178.1" Width="1047.06" KeepWithData="true" Condition="[Daten.KlasseNr]" KeepTogether="true">
|
|
<DataBand Name="Data1" Top="182.1" Width="1047.06" Height="18.9" DataSource="Daten">
|
|
<TextObject Name="Text2" Left="283.5" Width="292.95" Height="18.9" Text="[Daten.NameZ1]" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text3" Left="585.9" Width="94.5" Height="18.9" Text="[Daten.Zeit]" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text5" Left="746.55" Width="66.15" Height="18.9" Text="[Daten.AnzahlAngebot]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text7" Left="812.7" Width="66.15" Height="18.9" Text="[Daten.AnzZuteilungen]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text8" Left="982.8" Width="37.8" Height="18.9" Text="[IIf([Daten.MinZuteilung]=0,"",[Daten.MinZuteilung])]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text10" Left="689.85" Width="56.7" Height="18.9" Text="[Daten.Bezeichnung]" Font="Arial, 9pt"/>
|
|
<Sort>
|
|
<Sort Expression="[Daten.NameZ1]"/>
|
|
<Sort Expression="[Daten.Zeit]"/>
|
|
</Sort>
|
|
</DataBand>
|
|
<GroupFooterBand Name="GroupFooter2" Top="205" Width="1047.06" Height="28.35">
|
|
<TextObject Name="Text11" Left="907.2" Width="66.15" Height="18.9" Text="[Daten.Nachgefragt]" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text12" Left="746.55" Width="66.15" Height="18.9" Text="[Total]" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text13" Left="812.7" Width="66.15" Height="18.9" Text="[Total1]" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<LineObject Name="Line1" Left="689.85" Width="330.75"/>
|
|
<TextObject Name="Text30" Left="689.85" Width="56.7" Height="18.9" Text="[Daten.Bezeichnung]" Font="Arial, 9pt, style=Bold"/>
|
|
</GroupFooterBand>
|
|
</GroupHeaderBand>
|
|
<GroupFooterBand Name="GroupFooter1" Top="237.35" Width="1047.06" CanGrow="true" KeepWithData="true"/>
|
|
</GroupHeaderBand>
|
|
<ReportSummaryBand Name="ReportSummary1" Top="241.35" Width="1047.06" Height="359.1" StartNewPage="true">
|
|
<TextObject Name="Text37" Left="264.6" Top="264.6" Width="94.5" Height="18.9" BeforePrintEvent="Text37_BeforePrint" Text="[Daten.tzp2]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text36" Left="37.8" Top="264.6" Width="94.5" Height="18.9" Text="Zugeteilt" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text33" Left="151.2" Top="264.6" Width="94.5" Height="18.9" Text="[Daten.tzp1]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text39" Left="368.55" Top="264.6" Width="94.5" Height="18.9" Text="[Daten.tzp3]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text41" Left="472.5" Top="264.6" Width="94.5" Height="18.9" Text="[Daten.tzp4]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text43" Left="576.45" Top="264.6" Width="94.5" Height="18.9" Text="[Daten.tzp5]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text50" Left="661.5" Top="264.6" Width="94.5" Height="18.9" Text="[Daten.TZ]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text14" Left="37.8" Top="85.05" Width="113.4" Height="18.9" Text="Total Angebot:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text32" Left="37.8" Top="103.95" Width="122.85" Height="18.9" Text="Total nachgefragt:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text17" Left="160.65" Top="103.95" Width="94.5" Height="18.9" Text="[Daten.TotalAnzahlNachgefragt]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text15" Left="160.65" Top="85.05" Width="94.5" Height="18.9" Text="[Daten.TotalAngebot]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text31" Left="37.8" Top="122.85" Width="113.4" Height="18.9" Text="Total zugeteilt:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text16" Left="160.65" Top="122.85" Width="94.5" Height="18.9" Text="[Daten.TotalZugeteilt]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text44" Left="151.2" Top="217.35" Width="94.5" Height="18.9" Text="Prio 1" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text45" Left="264.6" Top="217.35" Width="94.5" Height="18.9" Text="Prio 2" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text46" Left="368.55" Top="217.35" Width="94.5" Height="18.9" Text="Prio 3" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text47" Left="472.5" Top="217.35" Width="94.5" Height="18.9" Text="Prio 4" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text48" Left="576.45" Top="217.35" Width="94.5" Height="18.9" Text="Prio > 4" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<LineObject Name="Line3" Left="37.8" Top="236.25" Width="718.2"/>
|
|
<LineObject Name="Line5" Left="37.8" Top="236.25" Width="604.8"/>
|
|
<TextObject Name="Text51" Left="37.8" Top="217.35" Width="94.5" Height="18.9" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text18" Left="37.8" Top="245.7" Width="94.5" Height="18.9" Text="Nachgefragt" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text19" Left="151.2" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.tap1]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text34" Left="264.6" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.tap2]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text38" Left="368.55" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.tap3]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text40" Left="472.5" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.tap4]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text42" Left="576.45" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.tap5]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text49" Left="661.5" Top="245.7" Width="94.5" Height="18.9" Text="[Daten.TA]" HorzAlign="Right" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text52" Left="661.5" Top="217.35" Width="94.5" Height="18.9" Text="Total" HorzAlign="Right" Font="Arial, 9pt, style=Bold"/>
|
|
<TextObject Name="Text35" Left="37.8" Top="37.8" Width="160.65" Height="18.9" Text="Zusammenfassung" Font="Arial, 10pt, style=Bold, Underline"/>
|
|
<TextObject Name="Text53" Left="349.65" Top="85.05" Width="113.4" Height="18.9" Text="Total Schüler:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text54" Left="661.5" Top="85.05" Width="94.5" Height="18.9" Text="[Daten.TotalSchueler]" HorzAlign="Right"/>
|
|
<TextObject Name="Text55" Left="349.65" Top="103.95" Width="292.95" Height="18.9" Text="Schüler mit ungenügender Anzahl Berufswünschen:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text56" Left="661.5" Top="103.95" Width="94.5" Height="18.9" Text="[Daten.TotalZuWenigZuteilung]" HorzAlign="Right"/>
|
|
<TextObject Name="Text57" Left="349.65" Top="122.85" Width="292.95" Height="18.9" Text="Schüler mit ungenügender Anzahl Zuteilungen:" Font="Arial, 9pt"/>
|
|
<TextObject Name="Text58" Left="661.5" Top="122.85" Width="94.5" Height="18.9" Text="[Daten.ZuWenigZugeteilt]" HorzAlign="Right"/>
|
|
</ReportSummaryBand>
|
|
<PageFooterBand Name="PageFooter1" Top="604.45" Width="1047.06" Height="47.25">
|
|
<TextObject Name="Text20" Left="37.8" Top="18.9" Width="94.5" Height="18.9" Text="[Date]" Format="Date" Format.Format="d"/>
|
|
<TextObject Name="Text21" Left="926.1" Top="18.9" Width="66.15" Height="18.9" Text="[Page#]" HorzAlign="Right"/>
|
|
<LineObject Name="Line4" Left="37.8" Top="18.9" Width="982.8"/>
|
|
</PageFooterBand>
|
|
</ReportPage>
|
|
</Report>
|