#BRJAVA
Input
$Var0#Schreibenart:##$Kat=SBA_SE
$Var1#erstellte Schreiben von:#01.01.2009#$NORM_DATUM
$Var2#erstellte Schreiben bis:#31.12.2009#$NORM_DATUM
SQL
report
NoHeader
<h2>übersicht über Vorgänge im Bearbeitungsstand :
</h2>
SQL
select txt1
from agkatde
where subid = 207
and guelbis > 2000000000
and nr = $Var0
Report
NoHeader>
<h2>%s
</h2>
sql
select count(*)
from sba_vgkontroll
where sba_vgkontroll.gueltig_bis = 0
and sba_se = $Var0
and (select erfdat from sba_dok where gueltig_bis = 0
and sba_dok.akz = sba_vgkontroll.sba_vg_akz
and lfdnr = (select max(lfdnr) from sba_dok
where sba_dok.akz = sba_vgkontroll.sba_vg_akz)) >= $Var1
and (select erfdat from sba_dok where gueltig_bis = 0
and sba_dok.akz = sba_vgkontroll.sba_vg_akz
and lfdnr = (select max(lfdnr) from sba_dok
where sba_dok.akz = sba_vgkontroll.sba_vg_akz)) <= $Var2
Report
<h3>Erstellt im Zeitraum vom $Var1 bis zum $Var2 (%s Vorgänge)
</h3>
sql
select sba_vgkontroll.sba_vg_akz "AKZ",
bs_name "Betriebsstätte",
bt.bt_name + ', ' + bt.bt_vorname "Betroffener",
sba_vgkontroll.sba_vg_manr "Sachbearbeiter",
wiedervorlage "Wiedervorlage"
from sba_vgkontroll, bs, bt
where $WHERE
and sba_vgkontroll.sba_bs_nr = bs.bs_nr
and bs.gueltig_bis = 0
and sba_vgkontroll.sba_vg_btnr = bt.bt_nr
and bt.gueltig_bis = 0
order by sba_vg_akz, sba_vg_manr
report html
|
