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 use our own SQL for creating a report?

5 Answers  


How the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?

0 Answers  


Why is Excel Report preferred over crystal reports?

3 Answers   Atos Origin, Collabera, Lighthouse Technologies,


Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.

0 Answers  


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

5 Answers  






Where is the image located, after youve placed it on the report?

0 Answers  


Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?

4 Answers   IBM,


Explain reporter footer contents are move depend the page footer values?

0 Answers  


How to open subreport in New IE window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report. Can anybody answer this please....... Regards Vimal.

1 Answers   GRV India, Patni,


How to conditionally suppress a field based on whether a page number is odd or even?

3 Answers  


How many sections are there in the report

6 Answers  


reporter footer contents are move depend the page footer values...........

2 Answers  


Categories