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

I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) 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 uncertainity 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 teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,


How can we improve the performance of a crystal report?

0 Answers  


hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.

0 Answers  


Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?

0 Answers  


What are the sections that we have in Crystal reports?

11 Answers  






hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing parameter also... please help....

0 Answers  


Does Crystal Report support all the functions that we have in Oracle?

2 Answers   MPS Techologies, Target,


How many types of reports can be generated in crystal reports?

7 Answers   winfoware, Finite Infotech, Precision Techconet, VMware,


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

2 Answers  


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

0 Answers  


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

3 Answers  


How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format

3 Answers   Target,






Categories