帮我看看关于水晶报表关联表内容显示完整性问题???项目第一次做报表,都愁死我了!
青梦奇缘 2009-02-24 08:38:26 ////////数据分别从BaseProject【收支父项表】 SubProject【收支子项表】 Pay【收支表】
select * from Pay
left join BaseProject on Pay.projectID=BaseProject.projectID
left join SubProject on Pay.subProjectID=SubProject.subProjectID
Go
select BaseProject.projectTyp,BaseProject.projectName, SubProject.subProjectName, Pay.payMoney from Pay
left join BaseProject on Pay.projectID=BaseProject.projectID
left join SubProject on Pay.subProjectID=SubProject.subProjectID
Go
//////图片在附件里,地址引用好像显示不出
////////看图上运行结果应该可以看出,当收支项目只有父项,没有子项的记录在水晶报表里显示不出!
////////希望有看出问题会的大哥大姐们帮我指出问题或给个解决方法!在这边先谢下了!完了给这贴再加分!