By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

Crystal Reports Duplicate Result

P: 22
Here's my sql string, When i run it into SQL Server it's work fine but when use it with my Reports,some data getting duplicated
Expand|Select|Wrap|Line Numbers
  1.  MySqlCommand = New SqlCommand("SELECT * FROM Tbl_Product_Definition_1 join Tbl_PO_Item ON Tbl_Product_Definition_1.P_Article_No = Tbl_PO_Item.F_Article_No join Tbl_PO ON Tbl_PO_Item.F_PO_No = Tbl_PO.P_PO_No join Tbl_Payment ON Tbl_PO.P_PO_No=Tbl_Payment.P_OR_No WHERE Tbl_Payment.F_Member_Code='" & frmSalesOrder.lblCustomerNo.Text & "' and Tbl_PO.Create_Date between '" & dtp1.Value.Date.ToString & "' and '" & dtp2.Value.Date.ToString & "'", conn)
Apr 25 '14 #1
Share this Question
Share on Google+
1 Reply

P: 299
If the command works fine within SQL then it's probably an issue with the way you are displaying the data in your VB.NET application.
Apr 25 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.