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

2
Contributors
2
Replies
18
Views
4 Years
Discussion Span
Last Post by Dili1234
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 & "' "
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.