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 all performance improvement techniques used in crystal reports? (Particularly cr xi)?
hi ... i've created one crystal report in windows form and one crystalreportviewer .. the following is my code.. in form1.cs file try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net- informations.pdf"; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } the above code is saving the file into pdf into specified path.. but i dont want to save a file i should get direct print preview and have a option to print .. As we do in web application using crystal report viewer clicking print and report will be opened in pdf.. and the click print.. i want the same function as we do in web application... i'm writing code in c#.net hope the above explaination will be understood clearly..
how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema
Can we use Crystal report as a stand-alone application?
Is there any feature like summing total in crystal report?
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
How many sections are there in the report
How many types of reports can be generated in crystal reports?
7 Answers Finite Infotech, Precision Techconet, VMware, winfoware,
HI all, I am developing reports using crystal reports in VS2005 in windows application. I have two crystalreports name called "studentReport" and "familyReport". I have a form with a button. If I click the button I need to show up the two reports in one report like page1, and page2. The page1 consists the "studentReport" and the page2 contains the "familyReport". The "familyReport" contains different header and footer. How to show up the two crystal reports in single crystalreportviewer?
How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)
Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers
Explain the various components in crystal reports?
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)