crystal report

Question

i want a complete code for crystal report to filter the data by maximum present in database. thanks

Satyapriya Nayak · Answer

Hi Amitesh Try Normal 0 CrystalReport1 r1 = new CrystalReport1(); private void button2_Click( object sender EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = select * from product where price=(select max(price) from product) ; com = new OleDbCommand (str con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds product ); dataGridView1.DataMember = product ; dataGridView1.DataSource = ds; con.Close(); r1.SetDataSource(ds); CrystalReportViewer1.ReportSource = r1; CrystalReportViewer1.RefreshReport(); CrystalReportViewer1.Refresh(); } Thanks