Start New Discussion within our Software Development Community

I taking data from 3 tables to crystal report.Tables are
1.Moblization -primary key is Fen_Inovoice_No
2.invovoice details -Primary keys are Fen_Inovoice_No and description
3.Client details-primary key is Contract name

I 'm using this query to retrive data

Dim cryRpt As New ReportDocument

        CrystalReportViewer1.SelectionFormula = "{Mobilization.Fen_Inovoice_No}= '" & Varibles.invoice1 & "'"
        cryRpt.Load("G:\Fentons project\m_invoice.rpt")
        CrystalReportViewer1.ReportSource = cryRpt

The problem every data is showing at three times

The problem every data is showing at three times

Please review the query that is used to fetch result. Also verify the Links section of Data Source of CrystalReport designer.

Query is this

            CrystalReportViewer1.SelectionFormula = "{Mobilization.Fen_Inovoice_No}= '" & Varibles.invoice1 & "' AND {Mobilization.Contract_Name}='" & Varibles.ContractName & "' "
            CrystalReportViewer1.SelectionFormula = "{invovoice details.Fen_Inovoice_No}= '" & Varibles.invoice1 & "' "
This question has already been answered. Start a new discussion instead.