Subtotal fg.ColFormat(3) = "$(#,###.00)" ' set format for calculated totals
fg.Subtotal flexSTClear ' remove old values ' calculate subtotals (the order doesn't matter)
' (sales values to be added are in column 3)
' col 0: product
fg.Subtotal flexSTSum, 0, 3, , vbRed ,,," TotPrd %s",,True
' col 1: employee
fg.Subtotal flexSTSum, 1, 3, , vbGreen,,," TotEmp %s",,True
' col 2: region
fg.Subtotal flexSTSum, 2, 3, , vbBlue ,,," TotRgn %s",,True ' total on a negative column to get a grand total
fg.Subtotal flexSTSum, -1, 3, , vbblue, vbwhite, true
Help中有帮助的
fg.Subtotal flexSTClear ' remove old values ' calculate subtotals (the order doesn't matter)
' (sales values to be added are in column 3)
' col 0: product
fg.Subtotal flexSTSum, 0, 3, , vbRed ,,," TotPrd %s",,True
' col 1: employee
fg.Subtotal flexSTSum, 1, 3, , vbGreen,,," TotEmp %s",,True
' col 2: region
fg.Subtotal flexSTSum, 2, 3, , vbBlue ,,," TotRgn %s",,True ' total on a negative column to get a grand total
fg.Subtotal flexSTSum, -1, 3, , vbblue, vbwhite, true
Help中有帮助的
解决方案 »
- VB6 中,MSCHART如何设置 坐标间隔?
- VB 6 的报表在VISTA下出错
- 菜鸟问利用VB设计、查询SQL数据库的相关资料!请支持,60分相送!^-^
- 单元格格式的显示问题?
- 如何向窗体传递一个参数?急
- VB中网页textArea赋值问题
- 救命!!!我为什么找不到dbgrid控件?
- 用打包展开的方式做了一个安装程序?但在别的机子上安装后,运行始终显示一个类未注册的问题?请高手指教!小弟急用,解决不了:(
- 有做安装程序的软件么?
- 在InstallShield中打包mdac_typ.exe组件,如何让其自动运行展开?如何设置?
- 如何将二进制的四个字节转换成单精度浮点数?
- MSHFlexGrid可以修改上面的内容吗?
能稍微解释一下这些代码吗?特别是TotRgn %s、TotPrd %s等。谢谢你了!