How to Filter the Crystal reports?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / tonmoy karim
crystalReportViewer1.ReportSource = sr;
crystalReportViewer1.SelectionFormula
="{salary_report.employee_id}=" + strEmpID + "";
| Is This Answer Correct ? | 16 Yes | 5 No |
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 |
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 |
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 |
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 |
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 |
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)?
When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From
what is the "refresh" button suppose to do on the crystal report viewer?
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?
How many sub-reports can report can have?
hi...to all i want to generate the two crystal reports one is employee and another is project. now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer.. can anybody help me.. plz
Where is the image located, after youve placed it on the report?
hi.. i've created one crystal report. and one global resource file .. in crystal report there's one text object with id Text1. and i want to take the values of resource file i've got it CrystalDecisions.CrystalReports.Engine.TextObject Dtemp1 = ((CrystalDecisions.CrystalReports.Engine.TextObject)myreport .ReportDefinition.Sections["section1"].ReportObjects["Text1" ]); Dtemp1.Text = Resources.Resource.ResourceManager.GetString("Dsec1"); it is showing the correct value want i want but when i give print it is disappearing.. how to solve this please help me..
How do we connect to the database?
How the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?
Why is Excel Report preferred over crystal reports?
3 Answers Atos Origin, Collabera, Lighthouse Technologies,
How to print two details fields at the bottom of the page
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)