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 |
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 the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?
When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From
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)?
Can we export data of reports into other format like in world doc etc?
Suppose I am not able to see any image on crystal report at run time. So how can I load any image which is saved in local disk so that it can be viewed at runtime in crystal reports?
Are there any limitations in crystal reports?
What all performance improvement techniques used in crystal reports? (Particularly cr xi)?
Why is Excel Report preferred over crystal reports?
3 Answers Atos Origin, Collabera, Lighthouse Technologies,
Where can we find the log file generated when we run a crystal report?
I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
How do you add a subreport to a report in Crystal Reports?