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 |
to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report
How do you add a subreport to a report in Crystal Reports?
How to access crystal reports in .net?
How many sections are there in the report
Can we export data of reports into other format like in world doc etc?
Kindly Help for this Below Scenario, I am going to implement Power BI into our internal software. I’m familiar with the fact that each user can pay $9.99 a month to build and view reports but what I need to know is how can we embed Power BI into our application so that any users that log into our application can see the reports without the monthly fee. I’ve researched enough that it can be done. What I am not familiar with is how to do it or the pricing of embedding it into an application. I think they do pricing on how many renders you do or something. Would you be able to look into how we could embed it into our software and the cost?
What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?
How to Filter the Crystal reports?
12 Answers CCIL, Mammut Building Systems,
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....
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
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?
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.
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)