读书人

关于使用syntaxfromsql,该如何解决

发布时间: 2012-05-22 18:18:54 作者: rapoo

关于使用syntaxfromsql
用syntaxfromsql 创建一动态数据窗口后,想在summary区,给相应的字段加求和的列,要怎么写??

[解决办法]

C# code
dw_5.Modify("datawindow.summary.height=84 datawindow.summary.color='536870912' ")dw_5.Modify('create compute(band=summary alignment="0" expression="~'合计:~'"border="0" '+&    'color="33554432" x="10" y="4" height="76" width="' + dw_5.Describe("部门_t.width") + &    '" html.valueishtml="0"  name=c_hj_t visible="1"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="536870912" )')dw_5.Modify('create compute(band=summary alignment="1" expression="sum(qtyi)"border="0" color="33554432" x="' +&    dw_5.Describe("qtyi_t.x") + '" y="4" height="76" width="' + dw_5.Describe("qtyi_t.width") +&    '" format="#,##0" html.valueishtml="0"  name=qtyi_sum visible="1"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="536870912" )') 

读书人网 >PB

热点推荐