Crystal Report and asp.net C#

hii sanjay ..

you can select dropdown and selectedIndexChange event postback that time yo can displaying report particular data get and bind datatable. you can used below code.

Invoice invoice = new Invoice(); // instance of my rpt file
var ds = new DsBilling(); // DsBilling is mine XSD
var table2 = ds.Vendor;
var adapter2 = new VendorTableAdapter();
adapter2.Fill(table2);
var table = ds.Bill;
var adapter = new BillTableAdapter();
string name = cboCustReport.Text;
int month = int.Parse(cboRptFromMonth.SelectedItem.ToString());
int year = int.Parse(cboReportFromYear.SelectedItem.ToString());
adapter.Fill(table, name,month,year);
ds.AcceptChanges();
invoice.SetDataSource(ds);
crystalReportViewer1.ReportSource = invoice;
crystalReportViewer1.RefreshReport();

refer to below link

~ https://www.codeproject.com/Tips/754037/Bind-Crystal-Reports-with-Dataset-or-Datatable

~https://www.codeproject.com/Articles/28899/Crystal-Report-with-DataSet-and-DataTable-using-C

your query solve after please accept answare..

good luck

1 Reply

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

Bhavesh Ghul7y ago
hii sanjay ..

you can select dropdown and selectedIndexChange event postback that time yo can displaying report particular data get and bind datatable. you can used below code.
Invoice invoice = new Invoice(); // instance of my rpt file
var ds = new DsBilling();  // DsBilling is mine XSD
var table2 = ds.Vendor;
var adapter2 = new VendorTableAdapter();
adapter2.Fill(table2);

var table = ds.Bill;
var adapter = new BillTableAdapter();
string name = cboCustReport.Text;
int month = int.Parse(cboRptFromMonth.SelectedItem.ToString());
int year = int.Parse(cboReportFromYear.SelectedItem.ToString());
adapter.Fill(table, name,month,year);

ds.AcceptChanges();

invoice.SetDataSource(ds);
crystalReportViewer1.ReportSource = invoice;
crystalReportViewer1.RefreshReport();
refer to below link
~ https://www.codeproject.com/Tips/754037/Bind-Crystal-Reports-with-Dataset-or-Datatable

~https://www.codeproject.com/Articles/28899/Crystal-Report-with-DataSet-and-DataTable-using-C

your query solve after please accept answare..

good luck
0