30+ REAL-TIME Crystal Reports Interview Questions and Answers

Last updated on 10th Nov 2021, Blog, Interview Questions

E-mail this post

(5.0) | 19496 Ratings 3058

Getting prepared for SAP Crystal Reports job? Do not panic, we will guide you on how and what to answer in your interview. If you are preparing for the SAP Crystal Reports job interview then go through The interview questions and answers page. SAP Crystal Reports is the data collected from the database and presented in the required format and choice. The customers, colleagues, partners can use this tool to form reports. Huge demand for SAP Crystal Reports developers in the present situation. It is used to create custom reports from several data centers. Generating the crystal report is very simple and easy in Visual Studio. Please have a look at the SAP Crystal Reports interview questions and answers page to win your interview.

1. Explain about Crystal Reports?

Ans:

Crystal report is a window based report writer that enables the programmer to make reports from different data sources with a minimum of written code. Crystal report can access data from various data-bases and can synchronize data from multiple databases into a single report.

2. Explain how you can connect crystal reports to the databases?

Ans:

To connect crystal report to the databases, there are two ways :

Use crystal report built in query
Use the tool “Crystal SQL Designer” given by crystal report

3. Explain whether it is possible to create our own formulas in crystal reports?

Ans:

Yes, it is possible to create your own formulas in Crystal reports. For that from the insert menu item choose “Formula Field”. Write the formula in “Formula Editor”, here you will see “Function Tree” , “Field Tree” , “Operator Tree” which will show the report fields, functions supported by crystal reports, operators etc.

4. Is it possible to edit SQL made by Crystal Reports?

Ans:

No, it is not possible to edit SQL made by crystal reports, however you can view the SQL.

5. Explain how you can enhance the performance of Crystal Reports?

Ans:

To improve the performance of Crystal Reports :

Avoid using sub-reports as it hampers the performance
Use report bursting indexes

6. Mention what all new features are available in SAP Crystal?

Ans:

In SAP Crystal, you have following features :

Streamlines report design
Improvement to data sources
Mobile and viewer support
OEM and developer features

7. Mention what data source that SAP business one supports for Crystal reports?

Ans:

For crystal reports the data-source that SAP business one supports are :

SAP Business One
OLE DB (ADO.

8. List out some of the key differences between SSRS and Crystal Report?

Ans:

SSRS has table base design pattern while in CR you can place objects anywhere :

Export to Excel in SSRS is easy than Crystal Report
To manage your data crystal report have several options while SSRS
Crystal report has client side report creation API, that allows the client to modify and create new reports
SSRS uses expressions while Crystal Report uses formula in C and basic
SSRS is compatible with Share-point list and can generate reports based on lists.
Both of them support OLAP connections

9. Mention what is the general syntax for creating SAP business one token?

Ans:

To create SAP business token the general syntax includes :

@ SELECT….FROM…..WHERE, the SELECT command is not necessary for all tables.

10. Explain how you can edit crystal reports layout in SAP business one?

Ans:

To edit crystal reports layout in the SAP business one :

1. Go to the main menu of the SAP business one -> choose administration -> set up -> General -> Report & Layout Manager

2. In Report & Layout Manager window, in the navigation panel on the left, scroll down to the document type of the layout you need to edit.

3. In the work space on the right, select the crystal reports layout you need to edit and select edit

11. Explain how you can create a bar-code in crystal reports?

Ans:

To create a bar-code in crystal reports, you have to follow the following steps :

1. In crystal report, from the main menu -> Click on View -> Design -> Field Explorer

2. Choose formula field and click on New icon on the top of the menu bar

3. Enter the name for the new formula like MYUPCEANBarcode and click OK

4. Now enter the name and argument into the editor UPCA ({items.item_barcode}.. The item_barcode is the table name and field name from the data source. Click on Save and Close.

5. The new function will appear in Field Explorer now, to use it drag/drop it onto the report

6. Drag the field onto the report and configure its font properties

7. Report is ready, click on the preview to see or print

12. Mention how many subreports can be added in the MainReport?

Ans:

In the MainReport, you can add 255 sub reports, and you cannot add sub-report under a sub-report.

subreports in MainReport — ***Subreports in MainReport***

13. Explain how you can export a crystal report with linked subreports into one excel sheet?

Ans:

First create a main report and subreport discreetly
Now open the main report and in the insert menu, choose subreport option
In sub-report option, “select an existing report”
Choose the sub-report that is already created
Place the link between the Main report and Subreport with the fields required
Now, export the report to Excel Format.

14. Explain how you can burst crystal reports by email?

Ans:

There are traditionally three methods to burst crystal reports by email :

Using a PDF tool
Using Crystal Reports Scheduler such as CRD
Data driven publishing method

15. Mention if there are any limitations of the crystal report?

Ans:

Limitation of crystal report includes :

If database is having field whose length is more than 255 characters then you cannot make formula using that field
Formatting is lost while exporting data
By right clicking on the field you can browse data that is in the database and not the data selected by the query

16. Mention whether we can use our own SQL for creating a report?

Ans:

You can create your own query by using the tool “Crystal SQL Designer”. You can insert your own SQL statement, it will save your file as “.qry”. Also, while creating a report instead of using the “Database” button use the “Crystal SQL Statement” button.

17. Explain what does it mean when you choose Enforce to, Enforce and or Enforce from in Crystal Report?

Ans:

Enforce and, Enforce to or Enforce from in crystal reports are chosen to enforce link created in report. Enforcing a link between tables makes sure that the report’s respective SQL uses this link, regardless of whether fields are required from one or both the involved tables. The default function is unenforced links, which means that the crystal report uses the link only if the report’s select statement needs it.

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

Ans:

Generally we use Crystal Reports with VB6. However we can make crystal report stand-alone applications also. But for that limitation is for viewing the report user should have crystal reports installed on his/her PC.

19.How do we format fields?

Ans:

20.Can we give parameters to the report?

Ans:

We can very well give parameters to the report. For creating parameters select ‘Parameter Field’ in the Insert menu item. ‘Create Parameter Field’ dialog box will pop up, it will ask for the name of the parameter, prompting text and data type. Now when you run the report it will prompt for these parameters.

21.Can we create our own formulas in reports?

Ans:

We can create our own formulas in reports. Select ‘Formula Field’ in the Insert menu item. Write the formula in ‘Formula Editor’. Here you will get ‘Field Tree’, ‘Function Tree’, and ‘Operator Tree’, which will display the report fields, functions that are supported by crystal reports (like CDATE (. etc.., operators (arithmetic, strings etc.. respectively.

22.Can we create reports using more than one database?

Ans:

We can create reports using more than one database like Oracle Access. Create data source names for both the databases. Select tables from them and create the report. Only restriction is if you use two databases then you cannot see the SQL generated by crystal reports.

23.Can we export data from reports into other formats like in world doc etc?

Ans:

Generated data can be exported to word doc, or in rich text format. Just click on the ‘Export’ icon in the menu. Export dialog box will be popped up. It will ask for the ‘Format’ like comma-separated value (csv. etc and the ‘Destination’ like disk, application etc. After that it will ask for the file name and save the data.

Only restriction is formatting of data will be lost, but the crystal report will try to maintain as much formatting as it can.

24.Can we use our own SQL for creating a report?

Ans:

We can also make our own query using ‘Crystal SQL Designer’ tool provided by SQL. Here you can insert your SQL statement as such. It will save this file as ‘.query’ and when you create a report instead of using the ‘Database’ button use the ‘Crystal SQL Statement’ button.

25.Can we edit SQL made by Crystal reports?

We cannot edit the SQL made by crystal reports. However we can view the SQL. For that select ‘Show SQL Query’ in Database menu item. Limitation is if you are using only one database. If you use two databases then you can’t even view the SQL prepared by the crystal report.

26.Can we suppress printing in crystal reports if 0 records are fetched?

Ans:

Yes, we can suppress printing if no records are fetched. Select ‘Report Options’ in the File menu item. ‘Report Options’ dialog box will pop up. In that there is one option ‘ Suppress printing if no records’ Check this option. If no records are found then nothing will be printed on the report.

27.What are the sections that we have in Crystal reports?

Ans:

Report has got standard sections like ‘Page Header’, ‘Page Footer’, ‘Report Header’, ‘Report Footer’, and ‘Details’. However you can add other sections also. Select ‘Sections’ in the Insert menu item. You can insert group sections also. If you don’t want to show any section just right click on that section and suppress that.

28.Can we add any database field once we have chosen the ‘Close’ button?

Ans:

Yes, we can add any database field afterwards also. Select ‘Database Field’ in the Insert menu item. If you are using a crystal report built in query then it will display the tables that you have selected. And you can select whichever field you want to display on the report. But if you are using a ‘.qry’ file then it will display a Query and you can select only those fields, which are there in the query.

29.Does Crystal Report support all the functions that we have in Oracle?

Ans:

No, Crystal report does not support all the functions. Like the Decode function is there in SQL but not there is a crystal report. You need to convert that in crystal report format (in if and else etc. However if you use ‘.qry’ files then it takes the SQL as such. There is no need to change any syntax.

30.Can we use stored procedures for creating the report?

Ans:

Yes, we can use stored procedures.

stored procedures for creating the report

31.Is there any feature like summing total in a crystal report?

Ans:

Crystal reports provide features like grand total, sub-total, running total etc. You can select any of these features in the Insert menu item. You can sum up records on the basis of each record or on change of group using the ‘Running Total ‘ option in the Insert menu item.

32.I am using two tables, one is an access database and the other is an oracle database. I am getting an error saying ‘SQL odbc error’ what should I do?

Ans:

If you are getting such an error then click the icon for ‘Report Expert’. It will give a warning saying that formatting will be lost. Ignore this you will get ‘Standard Report Expert’ dialog box. Reverse the links of the access database table and it will work.

33.How do we access crystal reports in .NET?

Ans:

Crystal reports come with Visual studio setup itself. Right click the solution explorer and add a new item and you can see a crystal report template as shown in figure ‘Crystal report template’. You can add an ‘.rpt’ file using this template.

34.What are the various components in crystal reports?

Ans:

There are four major components in crystal reports: Report designer, Reports engine, Report viewer and object models.

Report designer gives a graphical interface to create and modify reports.

Reports engine does the formatting and conversion part of crystal reports. It helps convert the contents of reports in word, excel, PDF, HTML and other formats.

Report viewers are controls which you can see on the visual studio tool box; you can drag and drop those controls on an ASPX page or windows application to view reports made using crystal.

Object models help us manage crystal reports objects during design time and run time.

35.What basic steps are needed to display a simple report in crystal?

Ans:

To understand this sample let display a simple report using crystal.

Step 1 :- Create a web application project.
Step 2 :- Add a new item and select the crystal report from the template. This adds a new RPT file in your solution explorer.
Step 3 :- Double click on the RPT file click on Crystal reports
Step 4 :- a Right click on ‘Database fields’ on the field explorer a then click on database expert a Expand create new connection a Expand OLE DB ADO a Select Microsoft OLEDB provider for SQL Server ( this depends on what kind of data you want to connect . a Give the server credentials a Click finish and done.
Step 5 :- a Right click on ‘Database fields’ on the field explorer a then click on database expert a Expand the server , database and select table which you want to add to the report
Step 6 :- Expand database fields in a table ( in this case it is ‘FactCurrencyRate’ table.. Now you can drag and drop the fields on the report.
Step 7 :- We now need to display the report on the ASPX page. For that we need the ‘CrystalReportViewer’ control. So expand the crystal reports section of the toolbar and drag the component on the ASPX page
Step 8 :- Now we need to go to code behind and specify the report source. That’s it, now compile and run the project you can see your report live in action.

36.Can crystal reports be published as a web service?

Ans:

Right click on the ‘RPT’ file and click ‘Publish as web service’

37.How do we invoke the crystal report web service?

Ans:

We can consume the web service as a normal web service in .NET. The easiest way is by using the ‘ReportViewerControl’ and specifying the ASMX URL in the report source property.

38.How do we add formulas using crystal reports?

Ans:

To add any formula in a crystal report is a three step procedure. Below figure ‘Add formula in crystal report’ shows the three steps in a pictorial format. Step 1 Go to field explorer and right click and click the new formula. Step 2: Give a name to the formulae and click on ‘Use Editor’. Step 3 a You will be presented with a UI which has all the formulas and functions.

39.How do we pass parameters to crystal reports?

Ans:

Sometimes we want to accept input parameters and the report works according to the parameter. To add an input parameter go to field explorer , go to parameter fields , right click , create parameter and you should be popped with a dialog box as shown in the figure ‘Parameter field’. Give a name to the parameter , type and that’s it you are in action

40.How do we export from crystal reports?

Ans:

There are two ways of using the export option one is when we display a report using a crystal report viewer you can see an export icon as shown in figure ‘Export’ below. You can then select in which format you want to export.

Second option is through coding. Below is a simple code snippet which shows how we can export a report. Create an object of the crystal report and call the ‘ExportToDisk’ method specifying in which format you want to export. Dim Report as New CrystalReport1

Report.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, “c:\my.doc”.

41.How do we print to a printer using crystal?

Ans:

In print we have two ways by which we can print one is when you display the report using a crystal report viewer you have a print option and second is by code. Below is a simple code snippet which shows how we have created an object called a report from the rpt file , specified the printer name, paper size and then called the ‘PrintToPrinter’ method.

Report.PrintOptions.PrinterName = “MyPrinter”
Report.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4
Report.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape
Report.PrintToPrinter(1, True, 1, 3.

42.How do we generate cross tab reports?

Ans:

When we go to create a new report you can see the cross –tab option.

43.How can we group crystals?

Ans:

For grouping in crystal you need to use the group expert wizard.

44.Can you explain three-pass reporting which crystal report uses?

Ans:

Crystal report uses the three pass method for parsing reports. Before we understand what it means let’s define what is a pass ?. Pass is a process used by crystal reports to read and manipulate data as per the report format. Below figure ‘Three pass method’ shows how the parsing happens. Let’s understand the same step by step. In the Pre-Pass1 crystal report engine evaluates constants like x=1 and pie=3.14 for a report. Pass 1 does two important things: get data from the database and sort records with given conditions. Once this is done it’s saved in memory and given to pre-pass2 for further parsing and manipulation. Pre-pass2 is all about grouping and sorting the records according to conditions specified in the crystal report. Pass 2 formats a report, applies conditions and groups them. Pass 3 is the final tunnel; it just counts the pages and generates reports. e report’s respective SELECT statement needs it.

45.Can We Use Crystal Report As A Stand-alone Application?

Ans:

46. How Do We Format Field?

Ans:

For formatting any field just right click on it and you will get many options like ‘Format Field.’ ‘Browse field data’ etc. Click on ‘Format Field.’ You can align data, suppress, make it multiline, change the font size, style, and type, make it hyperlink etc. If it is an amount field then you can display currency symbols also. Right click on the field select ‘Format Field’.

47. Can We Give Parameters To The Report?

Ans:

48. Can We Create Our Own Formulas In Reports?

Ans:

49. Can We Create a Report Using More Than One Database?

Ans:

50. Can We Export Data Of Reports Into Other Format Like In World Doc Etc?

Ans:

51. Can We Use Our Own Sql For Creating A Report?

Ans:

We can also make our own query using the ‘Crystal SQL Designer’ tool provided by SQL. Here you can insert your SQL statement as such. It will save this file as ‘.qry’ . And when you create a report instead of using the ‘Database’ button use the ‘Crystal SQL Statement’ button.

52. Can We Edit Sql Made By Crystal Reports?

Ans:

53. Are There Any Limitations In Crystal Reports?

Ans:

There are certain limitations in crystal reports. They are: – If a database has a field whose length is more than 255 characters, then you cannot make a formula using that field. While exporting data formatting is lost. When you browse data just by right clicking on the field then it displays what is there in the database, not the data selected by the query.

54. Can We Suppress Printing In Crystal Reports If 0 Records Are Fetched?

Ans:

55. What Are The Sections That We Have In Crystal Reports?

Ans:

56. Can We Add Any Database Field Once We Have Chosen ‘close’ Button?

Ans:

57. Does Crystal Report Support All The Functions That We Have In Oracle?

Ans:

No, Crystal report does not support all the functions. Like the Decode function is there in SQL but not there is a crystal report. You need to convert that in crystal report format (in if and else etc… However if you use ‘.qry’ files then it takes the SQL as such. There is no need to change any syntax.l

58. Can We Use Stored Procedure For Creating The Report?

Ans:

Yes, we can use stored procedures.

59. Is There Any Feature Like Summing Total In Crystal Report?

Ans:

60. I Am Using Two Tables One Is Of Access Database And Other Is Of Oracle Database, I Am Getting An Error Saying That ‘sql Odbc Error’ What Should I Do?

Ans:

61. What Are The Advantages Or Disadvantages Of Using Crystal?

Ans:

Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control :

Advantages :

1. Secure as End user cannot modify the data which is appear in the report if we use crystal report to show the report but in HTML, user can modify the report data
2. Report layout is not transparent, so that end user will not know about how we design the report. But in HTML, anybody can study the report layout and can copy the technology
3. Can export into different formats like PDF, HTML, XML, etc, and many more.

Disadvantages :

1. End user needs to have the crystal report viewer in his PC in order to see the crystal report output. But this can be overcome if you export the report as PDF/HTML
2. You need to buy a Crystal Report license for each PC you use to design the crystal report.
3. Must buy the version which allows you to install run time components in end user PC
4. Crystal Report is slow as compare to Active Reports
5. If we have a 100 page report then the crystal will need to process all pages and then it shows the output. and many more.

62. How To “print” In Crystal Reports While Using Asp Dot Net Platform?

Ans:

Using Crystal Decisions. SharedCrystalReport1 cr= new CrystalReport1;’here crystalreport1 is crystal report which we design.CrystalViewer1.ReportSource = cr; OR we can directly print the report without showing Output.

reportCrystalReport1 cr= new CrystalReport1;cr.PrintToPrinter(1,False,1,1.;

63. What Are Crystal Reports And Crystal Reports Explorer?

Ans:

With Crystal reports explorer one can quickly create and modify reports on the web, and since it’s built on the trusted Business object enterprise platform, it can easily manage massive user loads, individual access, and application customization.l

64. How To Conditionally Suppress A Field Based On Whether A Page Number Is Odd Or Even?

Ans:

Select the field –>Click FORMAT–>Click FORMAT FIELD–>Select the COMMON tab–>Click the FORMULA BUTTON to the right of SUPPRESS (Don’t click the suppress check box.To suppress a field on odd numbered pages PageNumber MOD 2 = 1To suppress a field on even numbered pages PageNumber MOD 2 = 0 –>Click SAVE Icon–>Close the formula editor–>Click OK on the FORMAT screen

65. How To Pass Stored Procedure Parameters To The Report?

Ans:

Choose File–>Options menu. In the Options dialog box –>Click the Database tab and ensure that Stored Procedures is selected. Selecting “”Stored Procedures”” automatically displays any available stored procedures when you log on to an SQL database.–>Click OK to exit the Options dialog box. –>On the Start Page, click Blank Report.–>Locate and select the SQL Server data source that contains the stored procedure you want to use.–>Click Next to go to the Connection Information dialog box–>Enter the required information to log in.–>Click Finish–>Highlight an SQL stored procedure in the Stored Procedures folder, and click the–>arrow to add it to the Selected Tables list.–>The Enter Parameter Values dialog box appears.–>Highlight a parameter in the Parameter Fields list–>Assign a value by typing into the Discrete Value box and then click OK–>You are returned to the Database Expert–>Click OK and create your report using the fields in the stored procedure.l

66. What Is The “refresh” Button Supposed To Do On The Crystal Report Viewer?

Ans:

1. When you use the Refresh Button in the crystal report viewer, it refreshes the report data.

2. When you refresh data from the Preview tab, the Refresh Report Data dialog box appears.

Select the “Use current parameter values” option to use the current parameter value,
Select the “Prompt for new parameter values” option to enter a new parameter value.
When you select this option and click OK, the Enter Prompt Values dialog box appears.
The program now runs the report using the new value(s. you specified.

67. Is There A Way To Export A Report Definition Without Writing Code?

Ans:

Yes. The following steps work assuming you have Crystal Reports on the machine and the appropriate export dlls loaded :

Open the report
Preview it
Click the EXPORT envelope
Select REPORT DEFINITION for the format
Select DISK FILE
Click OK
Enter a filename or accept the default
Click SAVE. The file is a text file and can be viewed with NOTEPAD.

68. Is There A Way To Export The Report Formulas, Like Totals To Excel?

Ans:

Yeah we can do that using a crystal report.

69. What Does It Mean When We Get The Error Message “invalid Report Version” When Trying To Open A Crystal Report?

Ans:

Crystal in its evolution has changed the report file format several times. In most cases the file format is FORWARD-compatible. By this I mean a file created in Crystal 6 can be opened in Crystal 6 or higher. When the file format changes were major the format is not BACKWARD compatible. By this I mean a file created in CR 9 cannot be opened in CR 8 or before. Crystal changed the report file format with CR 8 and CR 9. The CR 9 change was because of the introduction of Unicode support. CR 8 has the ability to save a file in CR 7 format. Because of the support for Unicode CR 9, 10, and XI cannot save the file in previous formats.l

69.How To Write A Formula To Change A Font Based Upon Data?

Ans:

Select the field
Click FORMAT
Click FORMAT FIELD
Select the FONT tab
Click the FORMULA BUTTON to the right of FONTif ({YourField} = Value. then “Arial”else “Times New Roman
Click SAVE Icon
Close the formula editor
Click OK on the FORMAT screen

70. How To Refresh The Crystal Report From The Application?

Ans:

calling crystal report control name.reset (by selecting Report menu under Refresh the report menu item at design time. will refresh the report[crystalreport1.DiscardSavedData=True]

71. How Many Subreports it Can Report Have?

Ans:

0-256

72. Where Is The “Save Data With Report” Option?

Ans:

You can find the File menu.

73. Explain How You Can Connect Crystal Reports To The Databases?

Ans:

To connect crystal report to the databases, there are two ways

1. Use crystal report built in query
2. Use the tool “Crystal SQL Designer” given by crystal report

74. Explain Whether It Is Possible To Create Our Own Formulas In Crystal Reports?

Ans:

75. Mention What All New Features Available In Sap Crystal?

Ans:

In SAP Crystal, you have following features :

Streamlines report design
Improvement to data sources
Mobile and viewer support
OEM and developer features

76. Mention What Are The Data Sources That Sap Business One Supports For Crystal Reports?

Ans:

For crystal reports the data-source that SAP business one supports are :

SAP Business One
OLE DB (ADO.

77. List Out Some Of The Key Difference Between Ssrs And Crystal Report?

Ans:

SSRS has table base design pattern while in CR you can place objects anywhere
Export to Excel in SSRS is easy than Crystal Report
To manage your data crystal report have several options while SSRS does not have any
Crystal report has client side report creation API, that allows the client to modify and create new reports
SSRS uses expressions while Crystal Report uses formula in C and basic
SSRS is compatible with Share-point list and can generate reports based on lists
Both of them support OLAP connections

78. Mention What Is The General Syntax For Creating Sap Business One Token?

Ans:

To create SAP business token the general syntax includes :

@ SELECT….FROM…..WHERE, the SELECT command is not necessary for all tables.

79. Explain How You Can Edit Crystal Reports Layout In Sap Business One?

Ans:

To edit crystal reports layout in the SAP business one :

1. Go to the main menu of the SAP business one -> choose administration ->set up -> General -> Report & Layout Manager

2. In Report & Layout Manager window, in the navigation panel on the left, scroll down to the document type of the layout you need to edit

3. In the work space on the right, select the crystal reports layout you need to edit and select edit.

80. Is it possible to export a crystal report with linked subreports in one excel sheet? If yes,then how?

Ans:

Yes, Create a main Report, and sub report separately.

– Open the Main Report and in Insert menu, select subreport

– Option, and in that “select an existing report”,

– Sub report which is already created, and pt the link

– Main report and subreport with the required fields. Now Export the report to Excel format.

81. How many SubReports added in One MainReport?

Ans:

The correct answer is, At most you can add 255 sub reports in the main report. so the total count is 256 reports are allowed for a standalone report. You can not add a subreport inside a sub report. This is one of the important questions as far as the interview point.l

82. How to add Crystal Reports(Standalone. to my VB.NET project?

Ans:

There are 2 versions of crystal reports available :

1. standalone reports like Crystal Reports 10,XI,XI R2
2. Crystal Reports which comes with Visual Studio .Net like Crystal Reports for Visual Studio-Embedded Reports.

If want to add reports, then go to Add Existing Item (right click on the project name in the solution explorer., browse to the .rpt file and select it or Add New Item in select Crystal Reports from the Templates. if you want to display reports, you should use Crystal

Reports Viewer :

Coding :

private ReportDocument hierarchicalGroupingReport;

protected void Page_Init(object sender,eventargs e.

{

configure crystal reports(.;

}

private void configure crystal reports(.

{

hierarchicalGroupingReport=new ReportDocument(.;

string reportPath=server.mappath(“Hierarchical

Grouping.rpt”.;

hierarchicalGroupingReport.Load(reportPath.;

CrystalReportViewer1.ReportSource=hierarchicalGroupingReport ;

}

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

Ans:

There are multiple ways to do that.

Using Report bursting indexes.
and Sub reports degrade the performance, So avoid using sub reports

84.How to show up the two crystal reports in a single crystalreportviewer?

Ans:

If I am not mistaken then this can be achieved by making Student report as main report and your other report family report as subreport of the main report opening in a new page. For different page headers of both reports what you can do is In the main report don’t put anything in PageHeader or Footer create a blank group that create page header for main report and in group footer create main report page footer data and on group select option repeat on each page. Maybe this will help to solve your problem if I understand what you are looking for.

85. Why is Excel Report preferred over crystal reports?

Ans:

As every Windows OS has Microsoft Excel reports and as it is simple, people are familiar with it. It has a formula field in it to do calculations.

86.To ensure that all of the data from a field is displayed in a report text object you should do which of the following?

Ans:

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

f. select the can grow option for the text object

87. Explain reporter footer contents are moved depending on the page footer values?

Ans:

Yes we can change the value of report footer depending on the page number contents. Create a formula ‘@formula’ towards(page number,0. place it in RF which will show the last page number in words.suppose the total number of pages is 24 then ‘Twenty Four’. if total pages are 5 then ‘Five’.

88. How to use 5 crystal report or subreport on Ddifferent conditions in one VB program?

Ans:

Different 5 condition is a=1,2,3,4,5

We write :

if a=1 then

Dim report as new cr_1

cr_1.show

else

Dim report as new cr_2

cr_2.show

else

Dim report as new cr_3

cr_3.show

else

Dim report as new cr_4

cr_4.show

else

Dim report as new cr_5

cr_5.show end

89. Where can we find the log file generated when we run a crystal report?

Ans:

When the reports run, a log file is created and each report’s output will placed the specified output directory with the output file name specified. If only a prefix is specified, the output name will also have a date and time stamp making it easy to archive reports for later viewing.

90. Can we call or add subreport within subreport?

Ans:

If you create a report with a subreport and save it. Create another report and add the first report as a subreport. If you try to create a subreport after it’s inserted it’s difficult. I think the limit on all subreports is 256.

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

Ans:

yes, we can achieve that using shared variables as mentioned already. however, should also make sure that the subreport values should come to the primary report before the section you have records on.

92. When looking at the join types in Crystal – what does it mean when you choose Enforce and Inforce To or Enforce From?

Ans:

Version 10 introduced the capability to enforce links created in the report. Enforcing a link between two tables ensures that the report’s respective SQL uses this link, regardless of whether fields are required from one or both the involved tables : –

1. The default setting is unenforced links, meaning that Crystal Reports uses the link only if the report’s respective SELECT statement requires it.

2. You can access the different enforcement options by right-clicking on a link and selecting the link Options menu item.

93. 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 a local disk so that it can be viewed at Runtime in Crystal reports?

Ans:

1. write the column of Byte array Type

2. And pass The byte data into this column

3. And drag the column to the crystal report.

94. Reports can be optimized for web viewing using which of the

Ans:

Following strategies :

a. Using subreports instead of linking tables

b. Avoiding maps

c. Using the Page N of M special field to help users understand how many pages are in the report

d. Saving reports as version 10

e. we can have on-demand sub report and load data as per user selection instead of bring all the records every time with table linking.

95. Where is the image located, after you’ve placed it on the report?

Ans:

1. actually it depends on the type of ole implementation Your doing i.e. static , embedded or linked

2. An OLE object is a presentation of data that was created in another application and that maintains a relationship with the application that was used to create it. A bitmap created in Paint, an Excel spreadsheet, or a graph from MS Graph may all be OLE objects if they are inserted in the receiving document as OLE objects. If they are not inserted as OLE objects, they retain no relationship with the original application.

3. Static object: A static OLE object is a picture of an object that can be displayed and printed, but not edited in place. It does not have a connection to a server application. There are two kinds of static objects: static bitmaps and static metafiles.

4. Embedded object :An embedded object contains a representation of the object, as well as information that defines the content. It does not have a connection to the original object in the server document. As a general rule, use embedded objects when you need to edit the object independently of the original server document. .

5. Linked object : A linked object contains a representation of the data and alink to the file where it originated. As a general rule, use linked objects when the data in the server document is changing and you want the object in your report to be updated when you open the report.

96. How to open a subreport in the New IE window using the hyperlink button. I used target=new; in the formula field. But it overrides the main window and shows the report?

Ans:

I use window.open (javascript. to open my report in a new window. What I prefer to do now is to export the report right away and open it in portable document format.

97. What are field expressions and what are the diff types? (I looked this up on the internet and never found anything with regards to types of field expressions.?

Ans:

This was to confuse you further.There are formula fields,database fields,sql expression fields,parameter fields etc and nothing like expression fields.

98. Is there a way to be able to change an image(company logo. dynamically in a report? Example if you have 100 reports, and with the market uncertainty if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all the reports at run time?

Ans:

Yes,there is a way.User may create a word document,embed the required image as a picture object in it and then embed this word document inturn into Crystal reports(as a linked OLE object..Any change in the word document would reflect in all he reports using this word doc.

99. How To Run Multiple Hybris Instances In One Machine?

Ans:

Basically hybrid runs on a tomcat instance. Hybris is shipped with a bundled tomcat. So the question here is actually, how to run multiple tomcat in one machine.

We can run as many hybrids we want, till our machine memory permits. To do so, we need to make each instance of tomcat to have it’s own ports to use. Make below ports unique for each instance. We should add below properties in the local property file of each instance with unique values.

tomcat.http.port=7001
tomcat.ssl.port=7002
tomcat.ajp.port=7009
tomcat.jmx.port=7003.

Crystal Reports Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download

100. Why Order Is Important In Items.xml?

Ans:

We need to follow an order in items.xml, when we declare item types in items.xml. Below are the reasons for it.Each items.xml is parsed in a single pass. This means, more specific types are dependent on general types. In such cases they should have been defined before we use them. For example.

Here we see that item type products are using other item types, like catalog. To make this file successful, it is mandatory that the catalog exists before the product is declared. We must define types in order of inheritance.

30+ REAL-TIME Crystal Reports Interview Questions and Answers

Subscribe For Free Demo

Learn Advanced Crystal Ball Certification Training Course to Build Your Skills

Get JOB Oriented Crystal Ball Training for Beginners By MNC Experts

Related Articles

Popular Courses

Latest Articles

Get Training Quote for Free

Corporate Training

Online | Classroom Training

Student | Trainer Support

ACTE Velachery

ACTE Tambaram

ACTE OMR

ACTE Porur

ACTE Anna Nagar

ACTE T. Nagar

ACTE Adyar

ACTE Thiruvanmiyur

ACTE Siruseri

ACTE Maraimalai Nagar

ACTE BTM Layout

ACTE Marathahalli

ACTE Rajaji Nagar

ACTE Jaya Nagar

ACTE Kalyan Nagar

ACTE Electronic City

ACTE Indira Nagar

ACTE HSR Layout

ACTE Bagh Lingampally

ACTE Madhapur

ACTE Magarpatta City

ACTE Kothrud

ACTE Coimbatore

ACTE Trichy

ACTE Salem

ACTE Puducherry