freeform窗口中的nested report 动态构建
能动态构建吗,全部分都给了。getchild是不行的,是针对composite下的子窗口。modify(create report...)不能构建子数据窗口sql动态语法。
[解决办法]
把freeform数据窗口的语法中的processing=0修改为processing=5, 这样的话,你就可以用getchild来取和里面嵌套的数据窗口了,然后动态创建试试
[解决办法]
'report(band=detail dataobject="d_yreport_grouptotal" x="23" y="1640" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_13 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouparound" x="23" y="1776" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_14 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_groupevent" x="23" y="1912" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_15 visible="1" slideup=directlyabove )'
ls_parm3='report(band=detail dataobject="d_yreport_groupset" x="23" y="2048" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_16 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptemp" x="23" y="2192" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_17 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptotal" x="23" y="2320" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_18 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_groupkill" x="23" y="2456" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_19 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptotal" x="23" y="2592" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_20 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouparound" x="23" y="2728" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_21 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_groupevent" x="23" y="2864" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_22 visible="1" slideup=directlyabove )'
ls_parm4='report(band=detail dataobject="d_yreport_groupset" x="23" y="3000" height="120" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_23 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptemp" x="23" y="3120" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_24 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptotal" x="23" y="3256" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_25 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_groupkill" x="23" y="3392" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_26 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouptotal" x="23" y="3528" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_27 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_grouparound" x="23" y="3684" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_28 visible="1" slideup=directlyabove )'+&
'report(band=detail dataobject="d_yreport_groupevent" x="23" y="3820" height="136" width="4736" border="0" height.autosize=yes criteria="" newpage = yes trail_footer = yes name=dw_29 visible="1" slideup=directlyabove )'
choose case ai_groupt
case 2
ls_syn_add=ls_parm2
ls_detail="datawindow.detail.height='2150' "
case 3
ls_syn_add=ls_parm2+ls_parm3
ls_detail="datawindow.detail.height='3000' "
case 4
ls_syn_add=ls_parm2+ls_parm3+ls_parm4
ls_detail="datawindow.detail.height='3950' "
end choose
ls_syn=left(ls_syn,ll_pos -1)+ls_syn_add+mid(ls_syn,ll_pos)
dw_1.create(ls_syn,ls_mss)
if len(ls_mss)>1 then messagebox('数据窗口创建错误!',ls_mss)
dw_1.modify(ls_detail)
return 1