im working with sql and crystal report this is my query..SELECT `tblpr`.`PR_Number`, `tblpr`.`Date_Submitted`, `tblpr`.`Date_Needed`, `tblpr`.`Department`, `tblpr`.`Purpose`, `tblprproducts`.`Product_Name`, `tblprproducts`.`Brand`, `tblprproducts`.`Description`, `tblprproducts`.`Part_Number`, `tblprproducts`.`Quantity`, `tblprproducts`.`Unit_Measurement`, `tblsignatories`.`Signatory1`, `tblsignatories`.`Designation1`, `tblsignatories`.`Signatory2`, `tblsignatories`.`Designation2`, `tblsignatories`.`Signatory3`, `tblsignatories`.`Designation3` FROM (`tblpr` `tblpr` INNER JOIN `tblprproducts` `tblprproducts` ON `tblpr`.`PR_Number`=`tblprproducts`.`PR_Number`) INNER JOIN `tblsignatories` `tblsignatories` ON `tblpr`.`PR_Number`=`tblsignatories`.`PR_Number` where tblpr.pr_number = '" & lstpr.FocusedItem.SubItems(0).Text & "' and tblprproducts.pr_number = '" & lstpr.FocusedItem.SubItems(0).Text & "'"this query will return 4 records from the database that''s good, but when it is displayed in crystal report 4 records will be displayed 16 records.. each item is repeated 4 times..what should be the problem?thanks in advance! 解决方案 这篇关于水晶报表重复的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
09-15 19:00