[Quote=引用 4 楼 xys_777 的回复:] 输入的什么语句select xv_aver_pri.month_no,xv_aver_pri.item_no,xv_aver_pri.part_name,xv_aver_pri.part_spec, xv_aver_pri.aver_pri,opur_pur2.sheet_lot,opur_pur2.pur_pri from xv_pur_total_yjj as xv_aver_pri,opur_pur1,opur_pur2,oacc_period where xv_aver_pri.month_no=oacc_period.month_no and xv_aver_pri.part_no=opur_pur2.part_no and opur_pur1.sheet_date between oacc_period.start_date and oacc_period.end_date and opur_pur2.sheet_sta='0'
输入的什么语句select xv_aver_pri.month_no,xv_aver_pri.item_no,xv_aver_pri.part_name,xv_aver_pri.part_spec,
xv_aver_pri.aver_pri,opur_pur2.sheet_lot,opur_pur2.pur_pri
from xv_pur_total_yjj as xv_aver_pri,opur_pur1,opur_pur2,oacc_period
where xv_aver_pri.month_no=oacc_period.month_no
and xv_aver_pri.part_no=opur_pur2.part_no
and opur_pur1.sheet_date between oacc_period.start_date and oacc_period.end_date
and opur_pur2.sheet_sta='0'
1、建立一个grid类型的。然后edit source改为crosstab的
2、存储过程作为数据源,然后加入到crosstab
你可以在datawindow上右键edit source
找到 processing (第二行 datawindow 开头的里面)修改为 processing=4创建crosstab的选择
谢谢7楼按照您上面说的,已经创建了一个可以使用crosstab的DD但我是用PB开发报表,现在做成的是一个pbl库,如何将其转换成PSR,以放入到系统中呢