How to Filter the Crystal reports?




Answers were Sorted based on User's Feedback



How to Filter the Crystal reports?..

Answer / suman

cryastal report -> report->Selection formula -> record
Then you can write code in which condition do u want to
filter your report.

Is This Answer Correct ?    30 Yes 10 No

How to Filter the Crystal reports?..

Answer / swapna

To filter the reports we have to use ?Formulas?.
We can prepare the formulas with
(1) Field Explorer (Window) or
(2) Writing the code
Syntax for preparing the formulas:
{classname.FieldName}<operator> & value.

Ex:
?{Employee.Emp_id}=? + value
?{Employee.Emp_name}=? + value + ??? (Strings to be in
single quotes)

Is This Answer Correct ?    27 Yes 9 No

How to Filter the Crystal reports?..

Answer / tonmoy karim

crystalReportViewer1.ReportSource = sr;
crystalReportViewer1.SelectionFormula
="{salary_report.employee_id}=" + strEmpID + "";

Is This Answer Correct ?    16 Yes 5 No




How to Filter the Crystal reports?..

Answer / rakesh r. gosalia

Can Also Use Selection Formulae in the Report Menu to
Filter the Crystal Report on Basis of the Field
e.g. Stores>10 (this will display the report for all stores
greater than 10)

Is This Answer Correct ?    15 Yes 7 No

How to Filter the Crystal reports?..

Answer / vikas

we can filter the data using parameter also that can be
used in the Query and inside the report also .

Is This Answer Correct ?    16 Yes 11 No

How to Filter the Crystal reports?..

Answer / elaiyaraja nallathambi

Answer 3 Will be the Best Option and its better not to
handle the Filter Criteria from the Report Side as it Slows
down the Performance.And its better to handle the Filter
criteria from the Query Side.

Is This Answer Correct ?    0 Yes 0 No

How to Filter the Crystal reports?..

Answer / raju k

By using
Section expert
Writing the formula
By parameters creation
On different ways we can filter the report

Is This Answer Correct ?    0 Yes 0 No

How to Filter the Crystal reports?..

Answer / surendra

Field Explorer (Window)

Is This Answer Correct ?    5 Yes 6 No

How to Filter the Crystal reports?..

Answer / hemalatha

Yes as suman said,Click on Report Menu ->Edit Selection
Formula -> Record.Then we can give the filters

Is This Answer Correct ?    6 Yes 9 No

How to Filter the Crystal reports?..

Answer / arvind gupta

Using Grouping and expert selection

Is This Answer Correct ?    8 Yes 12 No

Post New Answer



More Crystal Reports Interview Questions

Can we export data of reports into other format like in world doc etc?

5 Answers  


Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainty if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all the reports at run time?

0 Answers  


How can we improve the performance of a crystal report?

0 Answers  


How to print two details fields at the bottom of the page

5 Answers  


what is the "refresh" button suppose to do on the crystal report viewer?

2 Answers  






Where can we find the log file generated when we run a crystal report?

0 Answers  


How many sub-reports can report can have?

4 Answers   IBM,


Explain basic steps required to display a simple report in crystal?

0 Answers  


I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?

5 Answers  


Can we use stored procedure for creating the report?

11 Answers   Medreich,


Can we use our own SQL for creating a report?

5 Answers  


How do you add a subreport to a report in Crystal Reports?

0 Answers   MindCracker,






Categories