Using Filter to fetch specific data in SAP Crystal Reports
I have a Crystal Report that I have created from scratch. In database expert, I used OLE DB(ADO). In OLE DB(ADO)-> I have added tables into the Database and showed it on Crystal Report.
Next is I developed a Win form on which i used Crystal Report Viewer and after that I use below code in viewer to call the report:
var cryRpt = new ReportDocument();
cryRpt.Load(@"C:\Users\TEST\Desktop\Software\Crystal Reports\Crystal.rpt");
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
When this report is called, it fetches all the data in table. I want that specifically for the invoice number entered in the form. Query used to get data consists of Joins. I also tried to check on internet however there is no success.
Any help is appreciated.