1,105,242 Community Members

Data is duplicating

Member Avatar
Dili1234
Junior Poster
169 posts since Aug 2012
Reputation Points: -2 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 3 [?]
 
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

Member Avatar
__avd
Posting Genius (adatapost)
6,703 posts since Oct 2008
Reputation Points: 1,811 [?]
Q&As Helped to Solve: 1,272 [?]
Skill Endorsements: 61 [?]
Moderator
 
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.

Member Avatar
Dili1234
Junior Poster
169 posts since Aug 2012
Reputation Points: -2 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 3 [?]
 
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 7 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