8
82625741
Unregistered / Unconfirmed
GUEST, unregistred user!
各位大俠我在用reportbuilder的時候預臨的時沒有問題,但一打印就會出現如下錯誤:
"Invalid pointer operation"然後就會打出一張空白紙張,但在設計時可以正常打印,
我現在隻有六十分,全部給你們吧,想再要沒有:(
請各位大俠幫忙解決一下,拜托!
我用的是三層結構的主從報表,連接用sql語句完成,其中
主表語句如下:
Select A.*,B.Bh as GysBh,B.Jc as GysJc,M.dj as newdj,M.rq,C.Bh as ZlBh,
C.Mc as ZlMc
from Productm A,Supplier B,Category C,
(select D.dj,D.hpid,E.rq from discount1 D,discount E where D.zbid=E.id) M,
A inner join B On A.GysID=B.ID,
A left outer join M on A.ID=M.hpid,
A inner join C on A.ZlID=C.ID
從表語句如下:
Select A.*,B.Bh as YsBh,B.Mc as YsMc,B.Jc as YsJc,B.RGB as RGB,
C.Bh as CmBh from Productd A,Color B,Size1 C,
A inner join B on A.YsID=B.ID,
A inner join C on A.CmID=C.ID where A.ZBID=:ZBIDS
其中ZBIDS是主表ID字段
我所需要的報表是主報表和子報表,主報表加入主表中的全部字段,子表中隻加
入A.BH作為條碼,加入B.MC,C.BH作為說明,因為子報表的條碼要求橫向打印,所
以我加入了4項Column,column traversal為left to right
"Invalid pointer operation"然後就會打出一張空白紙張,但在設計時可以正常打印,
我現在隻有六十分,全部給你們吧,想再要沒有:(
請各位大俠幫忙解決一下,拜托!
我用的是三層結構的主從報表,連接用sql語句完成,其中
主表語句如下:
Select A.*,B.Bh as GysBh,B.Jc as GysJc,M.dj as newdj,M.rq,C.Bh as ZlBh,
C.Mc as ZlMc
from Productm A,Supplier B,Category C,
(select D.dj,D.hpid,E.rq from discount1 D,discount E where D.zbid=E.id) M,
A inner join B On A.GysID=B.ID,
A left outer join M on A.ID=M.hpid,
A inner join C on A.ZlID=C.ID
從表語句如下:
Select A.*,B.Bh as YsBh,B.Mc as YsMc,B.Jc as YsJc,B.RGB as RGB,
C.Bh as CmBh from Productd A,Color B,Size1 C,
A inner join B on A.YsID=B.ID,
A inner join C on A.CmID=C.ID where A.ZBID=:ZBIDS
其中ZBIDS是主表ID字段
我所需要的報表是主報表和子報表,主報表加入主表中的全部字段,子表中隻加
入A.BH作為條碼,加入B.MC,C.BH作為說明,因為子報表的條碼要求橫向打印,所
以我加入了4項Column,column traversal為left to right