datawindow中header如何分成header(1),header(2)...？？？

mashansj 2001-09-06 05:20:16

...全文

70 3 打赏收藏转发到动态举报

写回复

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

mashansj 2001-09-07

打赏
举报

回复

在创建datawindow时，选择crosstab显示风格

mashansj 2001-09-06

打赏
举报

回复

不是

wscxy 2001-09-06

打赏
举报

回复

你是不是指分组？

datawindow_header

数据窗口源码介绍 (举例见d_dbit_example.srd,测试数据库为PB自带的EAS Demo DB V120) 1.第一行:release 12; 数据窗口所属PB的版本号,如果想把高版本的datawindow导入低版本的PB中要修改此数字; 2.datawindow()行通常用修改processing属性,可以把你的数据窗口由grid变成freeform或其它类型例:freeform:0 grid:1 3.header()行可以整行复制粘贴,并命名为header[1],header[2],这样可以让数据窗口有多个header 4.table()行这里全是定义的数据属性,是setitem,update,object.data等方法访问的根源如果存在table()里的column,数据窗口里可以不存在任何对象,仍然可以访问数据窗口的数据如果想创建一个空的数据窗口,可以只定义: release 12; table() 5.table(column行) 是第几个column,它的ID就是多少,其中也定义了是否可以update时和更新到数据表的字段名 6.table(retrieve行) 检索数据时使用的SQL语句,可以通过setsqlselect或modify("table.sqlselect")方法去动态修改修改后要重新定义数据窗口的更新属性 7.column()行 id即是对应table(column行)里的行次,名称(name)可以随便命名,也可以没有,则默认为table(column行)里的name 8.compute()行计算列,可以通过表达式计算显示特定值(具体函数可以见共享里的画笔函数). 9.text()行有时可以代替计算列; 通过定义text的表达式,可以实现一列中显示两个字段值,注意结果必须要转换成string类型(而column和compute则不行); 10.htmltable()行按照格式导出(saveas)html文件,为了保证格式的完整,数据窗口的单位最好设置成pixels GenerateCSS='1' //保持格式及颜色 Border='0' //不要table边框 CellSpacing='0' //单元格无间距(此项在界面上经常设置不上) 注: (1)Grid生成标签,Freeform生成

+ 标签; (2)生成htmltable时,不知为何会在CSS中的开始自动加一个分号";",导致excel等浏览器打开不能正常显示格式; (3)band为foreground或background的对象导不出来,可以动态修改后再导出. 11.export.xml()行定义导出xml文件的格式,并为模板保存名称使用时一定要设置usetemplate值 12.import.xml()行定义导入xml文件的格式,并为模板保存名称使用时一定要设置usetemplate值 13.表达式介绍略 14.其它也略

$PBExportComments$用数据窗口做跑马灯 release 7; datawindow(units=1 timer_interval=10 color=15780518 processing=0 HTMLDW=no print.documentname="" print.orientation = 0 print.margin.left = 24 print.margin.right = 24 print.margin.top = 24 print.margin.bottom = 24 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) summary(height=0 color="536870912" ) footer(height=0 color="536870912" ) detail(height=87 color="536870912" ) table(column=(type=char(10) updatewhereclause=yes name=s dbname="s" ) ) text(band=header alignment="1" text="S:" border="0" color="0" x="13" y="6" height="14" width="18" name=s_t font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="0" x="2" y="32" height="1" width="16" format="[general]" name=s edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=detail alignment="0" text="现在跑马灯可以用了！" border="0" color="8421376" x="0~t333 - (long(left(right(string(t),4),3))) /1.5" y="0" height="33" width="279" name=t_1 font.face="Arial" font.height="-20" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) compute(band=summary alignment="0" expression="left(string(cpu()) + string(today(),'yyyymmdd'),len(string(cpu()) + string(today(),'yyyymmdd')) -8)"border="0" color="0" x="43" y="11" height="19" width="371" format="[general]" name=t visible="1~t0" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" ) text(band=detail alignment="0" text="/*truncate((long(left(right(string(t),4),3)) /50),0) * 50* (rgb(255,255,255) /1000)*/rand(100)/100 * rgb(255,255,255)" border="0" color="16711935" x="1" y="44" height="14" width="1418" name=t_2 font.face="Arial" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) text(band=detail alignment="0" text="333 - (long(left(right(string(t),4),3))) /1.5" border="0" color="16711935" x="0" y="66" height="14" width="508" name=t_3 font.face="Arial" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) htmltable(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" )

DW2XLS 4.0 release notes. New features in 4.0 - Added support for the new Excel file format, OOXML (XML based Excel 2007 format) Set parm.is_version = "OOXML" Default is still 97. - Added support for rectangles and solid lines (only vertical and horizontal). Set parm.ib_lines and parm.ib_rectangles. These objects are emulated using slim cells. - Added support for band background color and color expressions - Added support for exporting more than one datawindow on a single sheet See doc/multidwexample.htm - Overlapping objects are trimmed so that they do not overlap - Grid column's header is not exported anymore if the column is hidden Known issues. These issues will be fixed in future releases. - Size of resulting cells is not exactly the same as in the original DW, but the proportion is preserved (this comes from 2.X). - SlideLeft, SlideUp are not supported yet. - AutoSize Height (for columns) is not supported yet. - If a line or a rectangle is too close to another cell, then it may be displayed not properly in Excel. - When exporting to OOXML format, inserting pictures is not yet supported.

PB 数据窗口的绝对技巧

609

社区成员

20,469

社区内容

社区管理员

近7日
近30日
至今

加载中

查看更多榜单

试试用AI创作助手写篇文章吧

+ 用AI写文章