Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to Filter the Crystal reports?

Answers were Sorted based on User's Feedback



How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

Answer / tonmoy karim

crystalReportViewer1.ReportSource = sr;
crystalReportViewer1.SelectionFormula
="{salary_report.employee_id}=" + strEmpID + "";

Is This Answer Correct ?    16 Yes 5 No

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

Answer / surendra

Field Explorer (Window)

Is This Answer Correct ?    5 Yes 6 No

How to Filter the Crystal reports?..

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

How to Filter the Crystal reports?..

Answer / arvind gupta

Using Grouping and expert selection

Is This Answer Correct ?    8 Yes 12 No

Post New Answer

More Crystal Reports Interview Questions

What all performance improvement techniques used in crystal reports? (Particularly cr xi)?

0 Answers  


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..

0 Answers  


how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema

0 Answers   CSC,


Can we use Crystal report as a stand-alone application?

4 Answers   Covansys,


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,


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

1 Answers  


How many sections are there in the report

6 Answers  


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?

2 Answers  


How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)

9 Answers   CSC, ERS, Jupiter,


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

3 Answers   Wipro,


Explain the various components in crystal reports?

0 Answers  


Categories