InterviewPitch
Land the job you want — prepare
with Real interviews Q&A
Curated interview questions, company-wise guides and coding rounds. Practice mock interviews, improve with feedback, and track your progress.
Q&A
Top curated interview packs
Company-wise & role-wise packs, quality assured.
Mock interview
AI scoring
Coding rounds
Top 10 sets
Beginner
1. What is Crystal Reports?
Crystal Reports is a business intelligence reporting tool used to design and generate reports from various data sources.
Beginner
2. Who developed Crystal Reports?
Crystal Reports was originally developed by Crystal Services Inc. and later acquired by SAP.
Beginner
3. What file extension does Crystal Report use?
Crystal Reports files use the .rpt extension.
Beginner
4. What are the main sections in Crystal Report?
Report Header, Page Header, Details, Report Footer, and Page Footer.
Beginner
5. What is Record Selection Formula?
It filters data at the database level before generating the report.
Beginner
6. What is Grouping in Crystal Reports?
Grouping organizes data based on specific field values like department or date.
Beginner
7. What is a Parameter Field?
A parameter field allows users to pass input values to filter or customize report data.
Beginner
8. What is a Formula Field?
A formula field is used to perform calculations or manipulate data within the report.
Beginner
9. What is Cross-Tab Report?
A cross-tab displays summarized data in a matrix format similar to pivot tables.
Beginner
10. What is Subreport?
A subreport is a report embedded inside another report.
Beginner
11. What is Database Expert?
It is used to connect and select database tables for the report.
Beginner
12. What is Sorting in Crystal Reports?
Sorting arranges data in ascending or descending order.
Beginner
13. What is Summary Field?
A summary field calculates totals like Sum, Count, Average.
Beginner
14. What is Running Total Field?
A running total calculates cumulative totals while records are processed.
Beginner
15. What data sources can Crystal Reports connect to?
SQL Server, MySQL, Oracle, OLE DB, XML, Excel, and more.
Intermediate
16. Difference between Record Selection and Group Selection?
Record Selection filters data before grouping. Group Selection filters data after grouping.
Intermediate
17. What is shared variable in subreport?
A shared variable allows data exchange between main report and subreport.
Intermediate
18. How to pass parameter to subreport?
Using linked parameters or shared variables.
Intermediate
19. What is SQL Expression Field?
A field that allows writing SQL functions directly executed on the database server.
Intermediate
20. What is Command Object?
A custom SQL query used instead of selecting tables directly.
Intermediate
21. What is On-Demand Subreport?
A subreport that loads only when clicked by the user.
Intermediate
22. What is Conditional Formatting?
Applying formatting based on conditions.
Intermediate
23. What is Suppress Option?
Hides specific sections or fields based on conditions.
Intermediate
24. What is Drill Down?
Allows users to click summary data to view detailed information.
Intermediate
25. What is Report Footer used for?
Used to display grand totals and final summaries.
Intermediate
26. How to improve report performance?
Use record selection formula, proper indexing, avoid unnecessary subreports.
Intermediate
27. What is Null handling in Crystal?
Using functions like IsNull() or setting default values.
Intermediate
28. What is repository?
A centralized location to store reusable report objects.
Intermediate
29. What is Dynamic Parameter?
Parameter whose values are populated from database.
Intermediate
30. What is Static Parameter?
Parameter with manually defined fixed values.
Advanced
31. What is multi-pass reporting?
Crystal processes data multiple times to evaluate formulas and summaries.
Advanced
32. What is evaluation time in formulas?
Determines when a formula should be calculated during report processing.
Advanced
33. Difference between WhilePrintingRecords and WhileReadingRecords?
WhileReadingRecords runs during data fetch. WhilePrintingRecords runs during report rendering.
Advanced
34. What is database driver?
Software that enables Crystal Reports to communicate with databases.
Advanced
35. What is cascading parameter?
A parameter dependent on another parameter’s value.
Advanced
36. What is report bursting?
Splitting a report into multiple personalized reports.
Advanced
37. How to export reports?
Reports can be exported to PDF, Excel, Word, CSV, etc.
Advanced
38. What is report scheduling?
Automatically running reports at predefined intervals.
Advanced
39. What is SAP Crystal Server?
A platform for sharing, scheduling, and managing Crystal Reports.
Advanced
40. What is report caching?
Storing report data temporarily to improve performance.
Coding Round
41. Write formula to calculate total price
Answer hereCoding Round
42. Write formula to handle null values
Answer hereCoding Round
43. Suppress section if total is zero
Answer hereCoding Round
44. Create shared variable in subreport
Answer hereCoding Round
45. Retrieve shared variable in main report
Answer hereCoding Round
46. Convert date to string
Answer hereCoding Round
47. Conditional formatting formula
Answer hereCoding Round
48. Record selection formula example
Answer hereCoding Round
49. Display current date
CurrentDateCoding Round
50. Calculate running total formula
Answer here