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 |
Does Crystal Report support all the functions that we have in Oracle?
2 Answers MPS Techologies, Target,
Can we call or add subreport within subreport?
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.
Where is the image located, after youve placed it on the report?
How do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format
how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema
Explain the various components in crystal reports?
How can we improve the performance of a crystal report?
where is the "save data with report" option?
Can we create report using more than one database?
3 Answers CSC, Seed Infotech, Target,
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..
Is there a way to export a report definition without writing code?
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)