Answer / suman

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

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)

Answer / tonmoy karim

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

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)

Answer / vikas

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

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.

Answer / raju k

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

Answer / surendra

Field Explorer (Window)

Answer / hemalatha

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

Answer / arvind gupta

Using Grouping and expert selection

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  

How to pass stored Procedure Parameters to the report?

2 Answers  

What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?

3 Answers  

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From

3 Answers  

Can we use Crystal report as a stand-alone application?

4 Answers   Covansys,

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

0 Answers  

Can we use stored procedure for creating the report?

11 Answers   Medreich,

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 many sub-reports can report can have?

4 Answers   IBM,

Can we use our own SQL for creating a report?

5 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  

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

4 Answers   IBM,