I''m taking data from 3 tables to crystal report.Tables are1.Moblization -primary key is Fen_Inovoice_No2.invovoice details -Primary keys are Fen_Inovoice_No and description3.Client details-primary key is Contract nameWhen Search data from the Fen_Inovoice_No all the data have to be shown the crystal reportsI ''m using this query to retrive dataCrystalReportViewer1.SelectionFormula = "{Mobilization.Fen_Inovoice_No}= ''" & Varibles.invoice1 & "'' AND {Mobilization.Contract_Name}=''" & Varibles.ContractName & "'' "CrystalReportViewer1.SelectionFormula = "{invovoice details.Fen_Inovoice_No}= ''" & Varibles.invoice1 & "'' "cryRpt.Load("G:\Fentons project\m_invoice.rpt")CrystalReportViewer1.ReportSource = cryRptCrystalReportViewer1.Refresh()The Problem is data is showing at 3 times 解决方案 这篇关于水晶报表中的数据重复的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-04 03:26
查看更多