Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

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.


1 Answer
Anil SAP Gupta

I think you need to setup filtering in Record Selection formula. Navigate to this path to open Record Selection Formula:

Report -> Selection Formula -> Record

This will open a new window where you can pass your condition and rerun the report.


To know more about Record Selection Formula, you can refer this link:

1217147 - Crystal Reports Record Selection Formula change order when modifying it via the Select Expert.

SAP Knowledge Base 1217147


Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.