/******************************************************************************************************************************* Diese Datei wurde automatisch erstellt. Bitte nicht verändern. Importieren Sie diese Datei mit der Funktion des Abfrageassistenten. Projekt: pm Abschnitt: Abfrageassistent, Abfrage Personalbestand (für die Personalkommission II) Mandant: 20010 auf KS30\I2017.pm Version: 19.03.2019 18:57 ********************************************************************************************************************************/ insert into flex_abfragen ( abfrSQL, abfrOrdnung, abfrGruppe, abfrInhalt, abfrBeschreibung, abfrStandard, abfrThemen, abfrNutzer, abfrMandant, abfrAnwendung, abfrVorlage, abfrXLVorlage, abfrSQL_DW) values ( -100 , 0 , §Statistiken§ , §§ , §Personalbestand (für die Personalkommission II)§ , §F§ , §§ , @abfrNutzer , @abfrMandant , 0 , null , null , §release 17; datawindow(units=0 timer_interval=0 color=1073741824 processing=1 print.margin.bottom=150 print.margin.left=300 print.margin.right=150 print.margin.top=150 print.preview.buttons=no ) table( column=(type=char(255) updatewhereclause = yes name=stammds dbname="StammDS") column=(type=char(80) updatewhereclause = yes name=name dbname="Name") column=(type=char(12) updatewhereclause = yes name=alter dbname="Alter") column=(type=char(10) updatewhereclause = yes name=lbg dbname="Lbg") column=(type=long identity=yes updatewhereclause = yes name=azubi dbname="Azubi") column=(type=char(1) updatewhereclause = yes name=status dbname="Status") column=(type=char(20) updatewhereclause = yes name=beschverh dbname="BeschVerh") column=(type=long identity=yes updatewhereclause = yes name=teilzeit dbname="Teilzeit") column=(type=number updatewhereclause = yes name=vzä dbname="VZÄ") column=(type=char(80) updatewhereclause = yes name=azgrund dbname="AzGrund") column=(type=char(255) updatewhereclause = yes name=abwds dbname="AbwDS") column=(type=number updatewhereclause = yes name=abwvzä dbname="AbwVZÄ") column=(type=char(80) updatewhereclause = yes name=abwgrund dbname="AbwGrund") column=(type=char(10) updatewhereclause = yes name=soll dbname="Soll") column=(type=char(20) updatewhereclause = yes name=projekt dbname="Projekt") column=(type=long identity=yes updatewhereclause = yes name=befristet dbname="befristet") column=(type=long updatewhereclause = yes name=pvsid dbname="PVSID") retrieve="Select OrgZ_Dienststelle as [StammDS],Name,'> ' + ltrim(str( (dbo.f_alter(dateadd(day, 1, Geboren), Stichtag) / 5) * 5 )) as [Alter],Eingr_Laufbahn as [Lbg],case when BeschV_Bezeichnung like '%Aus%bild%' then 1 else 0 end as [Azubi],case when BeschV_beamtenrechtlich = 'ja' then 'B' else 'A' end as [Status],BeschV_BezeichnungNeutral as [BeschVerh],case when Az_IstTeilzeit = 'ja' then 1 else 0 end as [Teilzeit],Az_Umfang as [VZÄ],Az_Begründung as [AzGrund],AbwBesch_Dienststelle as [AbwDS],AbwBesch_Umfang as [AbwVZÄ],case when charindex(', Org:', AbwBesch_Begründung) > 0 then left(AbwBesch_Begründung, charindex(',', AbwBesch_Begründung) - 1) else AbwBesch_Begründung end as [AbwGrund],St_Soll as [Soll],St_ProjektKz as [Projekt],case when Befr_Bezeichnung = 'befristet' then 1 else 0 end as [befristet],PVSID From #aa order by OrgZ_Dienststelle ASC, Name ASC") header(height=120) footer(height=80) detail(height=80 height.autosize=yes color="536870912 ") column(band=detail id=1 x="9" y="8" height="64" width="357" name=stammds height.autosize=yes visible="1" format="[general]" edit.limit=255 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="StammDS" x="9" y="0" height="52" width="357" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=stammds_t ) column(band=detail id=2 x="375" y="8" height="64" width="642" name=name height.autosize=yes visible="1" format="[general]" edit.limit=80 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Name" x="375" y="0" height="52" width="640" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=name_t ) column(band=detail id=3 x="1024" y="8" height="64" width="366" name=alter height.autosize=yes visible="1" format="[general]" edit.limit=12 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Alter" x="1024" y="0" height="52" width="366" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=alter_t ) column(band=detail id=4 x="1399" y="8" height="64" width="320" name=lbg height.autosize=yes visible="1" format="[general]" edit.limit=10 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Lbg" x="1399" y="0" height="52" width="320" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=lbg_t ) column(band=detail id=5 x="1728" y="8" height="64" width="329" name=azubi height.autosize=yes visible="1" format="[general]" alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Azubi" x="1728" y="0" height="52" width="329" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=azubi_t ) column(band=detail id=6 x="2066" y="8" height="64" width="188" name=status height.autosize=yes visible="1" format="[general]" edit.limit=1 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Status" x="2066" y="0" height="52" width="187" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=status_t ) column(band=detail id=7 x="2263" y="8" height="64" width="594" name=beschverh height.autosize=yes visible="1" format="[general]" edit.limit=20 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="BeschVerh" x="2263" y="0" height="52" width="594" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=beschverh_t ) column(band=detail id=8 x="2866" y="8" height="64" width="329" name=teilzeit height.autosize=yes visible="1" format="[general]" alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Teilzeit" x="2866" y="0" height="52" width="329" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=teilzeit_t ) column(band=detail id=9 x="3205" y="8" height="64" width="323" name=vzä height.autosize=yes visible="1" format="#0.0##" alignment="2" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="VZÄ" x="3205" y="0" height="52" width="325" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=vzä_t ) column(band=detail id=10 x="3538" y="8" height="64" width="534" name=azgrund height.autosize=yes visible="1" format="[general]" edit.limit=80 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="AzGrund" x="3538" y="0" height="52" width="535" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=azgrund_t ) column(band=detail id=11 x="4082" y="8" height="64" width="224" name=abwds height.autosize=yes visible="1" format="[general]" edit.limit=255 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="AbwDS" x="4082" y="0" height="52" width="224" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=abwds_t ) column(band=detail id=12 x="4315" y="8" height="64" width="279" name=abwvzä height.autosize=yes visible="1" format="#0.0##" alignment="2" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="AbwVZÄ" x="4315" y="0" height="52" width="279" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=abwvzä_t ) column(band=detail id=13 x="4603" y="8" height="64" width="362" name=abwgrund height.autosize=yes visible="1" format="[general]" edit.limit=80 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="AbwGrund" x="4603" y="0" height="52" width="361" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=abwgrund_t ) column(band=detail id=14 x="4974" y="8" height="64" width="320" name=soll height.autosize=yes visible="1" format="[general]" edit.limit=10 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Soll" x="4974" y="0" height="52" width="320" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=soll_t ) column(band=detail id=15 x="5303" y="8" height="64" width="594" name=projekt height.autosize=yes visible="1" format="[general]" edit.limit=20 alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="Projekt" x="5303" y="0" height="52" width="594" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=projekt_t ) column(band=detail id=16 x="5906" y="8" height="64" width="329" name=befristet height.autosize=yes visible="1" format="[general]" alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="befristet" x="5906" y="0" height="52" width="329" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=befristet_t ) column(band=detail id=17 x="6245" y="8" height="64" width="329" name=pvsid height.autosize=yes visible="1" format="[general]" alignment="0" font.face="Tahoma" font.height="-8" font.weight="400" font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.isbubble="0" edit.autoselect=yes edit.autohscroll=yes edit.autovscroll=no edit.focusrectangle=no ) text(band=header text="PVSID" x="6245" y="0" height="52" width="329" font.face="Tahoma" font.height="-8" font.weight="700" height.autosize=yes font.charset="0" font.pitch="2" font.family="2" font.underline="0" font.italic="0" font.strikethrough="0" border="0" color="0" background.mode="1" background.color="536870912" background.brushmode="0" background.gradient.color="8421504" background.gradient.scale="100" background.gradient.spread="100" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" tooltip.enabled="0" tooltip.icon="0" tooltip.backcolor="134217752" tooltip.textcolor="134217751" tooltip.delay.initial="0" tooltip.delay.visible="1" tooltip.isbubble="0" alignment="0" name=pvsid_t ) htmltable(border="0" cellpadding="1" cellspacing="1" generatecss="no" nowrap="no") sparse(names="")§ ) insert into flex_where_klausel (whAbfragen, whKlammerAuf, whColumn, whOperator, whParameter, whKlammerZu, whLogical, whOrdnung, whMandant) values ( -1 , §§ , §IstAktiv§ , §=§ , §'ja'§ , §§ , §§ , §1§ , @abfrMandant ) insert into flex_having_klausel (havAbfragen, havKlammerAuf, havAggregat, havColumn, havOperator, havParameter, havKlammerZu, havLogical, havMandant) values ( -1 , §§ , §§ , §§ , §§ , §§ , §§ , §§ , @abfrMandant )