关于使用syntaxfromsql,该如何解决
关于使用syntaxfromsql
用syntaxfromsql 创建一动态数据窗口后,想在summary区,给相应的字段加求和的列,要怎么写??
------解决方案--------------------
用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" )')