Member Avatar for Dili1234

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
  • 174 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Dili1234
Member Avatar for kvprajapati

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.

Member Avatar for Dili1234

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 & "' "
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.