1.11M Members

Data is duplicating

 
0
 

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
        CrystalReportViewer1.Refresh()

The problem every data is showing at three times

 
0
 

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.

 
0
 

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 & "' "
Question Answered as of 10 Months Ago by __avd
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article