Duplicating data in crystal report with MySQL and C#

I have a problem in displaying the data in crystal report using left join. When i use "where no_barang = 2" in Phpmyadmin is working. But in crystalreport not working (the data is duplicate, and showing all data).

table "barang"

no_barang | nama_barang | harga_barang

1 | sepatu | 25000

2 | baju | 47000

table "pelanggan"

no_pelanggan | nama_pelanggan

1 | Sugeng Agung Suganda

2 | Babay Azifahmi

table "pembelian"

no_order | no_pelanggan | no_barang | jumlah

1 | 1 | 2 | 2

2 | 2 | 1 | 1

This my code in crystalreport

MySqlParameter p;
MySqlConnection conn = new MySqlConnection("database=cs_reportmultitables;server=localhost;uid=root;pwd=");
public View(string sTitle)
{
InitializeComponent();
try
{
DataSet ds = new DataSet();
string query;
p = new MySqlParameter("@no_order", MySqlDbType.String);
p.Value = sTitle;
query = "SELECT pembelian.no_order, pelanggan.nama_pelanggan, barang.nama_barang, barang.harga_barang, pembelian.jumlah FROM pembelian LEFT JOIN pelanggan ON pembelian.no_pelanggan = pelanggan.no_pelanggan LEFT JOIN barang ON pembelian.no_barang = barang.no_barang WHERE no_order=@no_order";
MySqlDataAdapter dscmd = new MySqlDataAdapter(query, conn);
dscmd.SelectCommand.Parameters.Add(p);
dscmd.Fill(ds);
RPT cryds = new RPT();
cryds.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = cryds;
crystalReportViewer1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
conn.Close();
}

I have trying to all combination settings in crystal report.

Trying to display number 2 and my output was this:

no_order | nama_pelanggan | nama_barang | harga_barang | jumlah

1 | Sugeng Agung Suganda | sepatu | 25000 | 2

2 | Babay Azifahmi | sepatu | 25000 | 1

It duplicate in "nama_barang" and "harga_barang", should display data like this:

2 | Babay Azifahmi | sepatu | 25000 | 1

Please help me if anyone know? Full my source code is here

http://github.com/sgnd/csharp-reportmultitables

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suganda Suganda8y ago
Hi debasis saha, i have trying that. But the output was like:

no_order | nama_pelanggan | nama_barang | harga_barang | jumlah

1 | Sugeng Agung Suganda | sepatu | 25000 | 2

2 | Babay Azifahmi |

Not like this:

no_order | nama_pelanggan | nama_barang | harga_barang | jumlah

2 | Babay Azifahmi | sepatu | 25000 | 1
Debasis Saha8y ago
In Crystal Report Designer, Select the respective field and open its Format Field property window by right Click. There is a option called Suppress Duplicate Checkbox. Tick that Check box.