有一段代码是这样的
---------------------
release 9;
datawindow ( units=0 timer_interval=0 color=15793151 processing=0 pointer="HyperLink!" print.printername="" print.documentname="" print.orientation=0 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 print.paper.size=0 print.paper.source=0 print.canusedefaultprinter=yes selected.mouse=no rows_per_detail=2)
header(height=8 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=320 color="536870912" )
table(column=(type=char(4) update=yes updatewhereclause=yes name=ch_tableno dbname="cybr_bt_table.ch_tableno" )
column=(type=char(12) update=yes updatewhereclause=yes name=vch_tablename dbname="cybr_bt_table.vch_tablename" )
column=(type=char(2) update=yes updatewhereclause=yes name=ch_typeno dbname="bt_table.ch_typeno" )
column=(type=char(64) updatewhereclause=yes name=flag dbname="flag" )
column=(type=long updatewhereclause=yes name=int_id dbname="cybr_bt_table.int_id" )
column=(type=char(2) updatewhereclause=yes name=book dbname="book" )
column=(type=char(1) updatewhereclause=yes name=booktype dbname="booktype" )
retrieve=" SELECT a.ch_tableno,
a.vch_tablename,
a.ch_typeno,
a.ch_areano,
a.ch_billno,
a.ch_state,
(case when a.ch_billno is null and a.ch_state = 'Y' then 'bitmaps~\tablestate4.jpg'
when a.ch_billno is not null and a.ch_state = 'N' then 'bitmaps~\tablestate2.jpg'
else (case when b.vch_picname is null or rtrim(b.vch_picname) = ''
then 'bitmaps~\tablestate1.jpg' else b.vch_picname end)
end) as flag,
' ' as cost,
' ' as checked,
datediff(mi,a.dt_opertime,getdate()) as time_len,
(case when a.ch_billno is null and a.ch_state = 'Y' then 4
when a.ch_billno is not null and a.ch_state = 'N' then 2
when a.ch_billno is not null and a.ch_state = 'Y' then 3
when a.ch_billno is not null and a.ch_state = 'P' then 5
else 1 end) as state,
' ' as memo,
' ' as bt_state,
a.ch_temp,
a.int_id,
a.int_person,
ch_page = 'N',
' ' as book,
'1' as booktype
FROM cybr_bt_table a, cybr_bt_table_type b
Where a.ch_typeno = b.ch_typeno
order by a.ch_typeno,a.ch_tableno
"
sort="ch_typeno A, ch_tableno A"
)
compute(name=compute_1 visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127" color="33554432" x="151" y="8" height="64" width="613" format="[GENERAL]" expression="sum( if (state = 1 , 1 , 0))" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_2 visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127"
htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )