Interview Questions.

Q1. Mention If There Are Any Limitation Of Crystal Report?

Limitation of crystal record consists of :

If database is having discipline whose period is greater than 255 characters you then cannot make components using that subject.

Formatting is misplaced while exporting facts.

By right clicking on the field you may browse records this is inside the database and not the information selected via the question.

Q2. Explain How Can You Export Crystal Report With Linked Sub-reports Into One Excel Sheet?

First create a prime report and sub document discretely.

Now open the primary file and in the insert menu, pick out sub-record option.

In sub-report choice, “pick an existing document”.

Choose the sub-document that is already created.

Place the hyperlink between the Main report and Sub document with the fields required.

Now, export the report to Excel Format.

Q3. Explain How Can You Enhance The Performance Of Crystal Reports?

To enhance the overall performance of Crystal Reports :

Avoid the use of sub-reports because it hampers the overall performance.

Use report bursting indexes.

Crystal_reports_hosting.

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

Reports in a Windows Forms application as antagonistic to say rolling our very own reviews as HTML and showing them in the Internet Explorer manage.

Advantages :

Secure as End user cannot modify the data which is seem in the report if we use crystal report to show the report however in HTML, user can modify the record records.

Report layout isn't trparent, so that cease consumer will now not understand about how we layout the record. But in HTML, every person can observe the file layout and might replica the technology.

Can export into distinct format like PDF, HTML, XML, and so forth, and many greater.

Disadvantages :

End person need to have the crystal record viewer in his PC in order to see the crystal record output. But this could be conquer in case you export the record as PDF/HTML.

You need to buy Crystal Report license for every laptop you are used to layout the crystal record.

Must purchase the version which lets in you to put in run time additives in end consumer PC.

Crystal Report is sluggish as compare to Active Reports.

If we have 100 pages file then crystal will want to manner all pages after which it shows the output. And lots of greater.

Q5. Explain What Is Crystal Reports?

Crystal document is a window based totally report author that enables the programmer to make reports from one-of-a-kind facts sources with at the very least written code. Crystal file can get right of entry to data from numerous statistics-bases and can synchronize information from multiple databases right into a unmarried file.

Q6. Explain What Does It Mean When You Choose Enforce To, Enforce And Or Enforce From In Crystal Report?

Enforce and, Enforce to or Enforce from in crystal reviews are chose to put into effect link created in document. Enforcing a link among tables make certain that the file’s respective SQL uses this hyperlink, no matter whether fields are required from one or each the worried tables.  The default function is unenforced hyperlinks, which me that the crystal document makes use of the hyperlink simplest if the document’s respective SELECT declaration desires it.

Q7. Mention Whether We Can Use Our Own Sql For Creating A Report?

You can create your own question by way of the usage of tool “Crystal SQL Designer”.  You can insert your own SQL declaration, it'll shop your file as “.Qry”.  Also, whilst growing a document instead of the use of “Database” button use “Crystal SQL Statement” button.

Q8. What Are Crystal Reports And Crystal Reports Explorer?

With Crystal reports explorer you will fast create and alter reports on the web, and due to the fact that its constructed on the trusted Business item organisation platform, it can effortlessly control large person masses, person get right of entry to, and application customization.

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

Yes, we can suppress printing if no records are fetched. Select ‘Report Options’ in File menu item. ‘Report Options’ conversation field will pop up. In that there is one alternative ‘ Suppress printing if no statistics’ Check this option. If no records are observed then nothing might be imprinted on the file.

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

Yes, it's miles possible to create your own formulation in Crystal reviews. For that from insert menu item pick “Formula Field”. Write the method in “Formula Editor”, here you will see “Function Tree” , “Field Tree” , “Operator Tree” so as to show the record fields, capabilities supported by way of crystal reports, operators and many others.

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

No, Crystal document does now not help all the capabilities. Like Decode characteristic is there in SQL however no longer there's crystal file. You want to transform that in crystal record layout (in if and else and so forth.). However in case you use ‘.Qry’ documents then it take the SQL as such. There is no want of converting any syntax.

Q12. Can We Give Parameters To The Report?

We can very well provide parameters to the document. For creating parameters select ‘Parameter Field’ in Insert menu item. ‘Create Parameter Field’ conversation field will popped up, it's going to ask for the call of parameter, prompting textual content and datatype. Now when you run the record it's going to spark off for those parameters.

Q13. Can We Use Crystal Report As A Standalone Application?

Generally we use Crystal Reports with VB@However we will make crystal report stand­on my own application also. But for that issue is for viewing the document user have to have crystal reports set up on his/her PC.

Q14. How Do We Format Field?

For formatting any area just right click on on it and you'll get many alternatives like ‘Format Field.’ ‘Browse discipline statistics’ and so forth. Click on ‘Format Field.’ You can align information, suppress, make it multiline, exchange the font size, style, and type, make it link and so on.

If it's miles an quantity area then you may display forex image also. Right click on the field pick out ‘Format Field’.

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

Crystal reviews provide functions like grand overall, sub­general, strolling general and many others. You can choose any of those features in Insert menu item. You can sum up facts on the idea of each document or on change of organization using ‘Running Total ‘ option in Insert menu object.

Q16. Is It Possible To Edit Sql Made By Crystal Reports?

No, it isn't viable to edit SQL made by way of crystal reviews, but you may view the SQL.

Q17. Mention How Many Sub-reviews Can Be Added In The Mainreport?

In the MainReport, you can upload 255 sub reviews, and you can't add sub-report underneath a sub-file.

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

Yes, we are able to use stored system.

Q19. Can We Create Report Using More Than One Database?

We can create file the use of a couple of database like Oracle, Access. Create information source call for each the databases. Select tables from them and create the record. Only restrict is if you use two databases then you definately can't see the SQL generated with the aid of crystal reports.

Q20. Explain How Can You Create A Bar-code In Crystal Reports?

To create a bar-code in crystal reports, you need to comply with the following steps :

In crystal record, from the primary menu -> Click on View -> Design -> Field Explorer.

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

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

Now enter the name and argument into the editor UPCA (objects.Item_barcode). The item_barcode is the desk call and discipline call from information source. Click on Save and Close. The function names can be listed under any person of the locations, both in “Functions>extra features> Visual simple UFLs (u2lcom.Dll)” or in “Functions>Additional Functions>COM and.NET UFLs (u212com.Dll)”.

The new function will appear in Field Explorer now, to apply it drag/drop it onto the record.

Drag the sector onto the record and configure its font houses.

Report is prepared, click on on the preview to peer or print.

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

Choose File–>Options menu.

In the Options dialog field :

Click the Database tab and ensure that Stored Procedures is selected. Selecting “”Stored Procedures”” routinely shows any available stored processes whilst you go browsing to an SQL database.

Click OK to exit the Options dialog container.

On the Start Page, click Blank Report.

Locate and choose the SQL Server information source that incorporates the saved method you need to apply.

Click Next to visit the Connection Information dialog box–>Enter the required statistics to log in.

Click Finish.

Highlight an SQL saved technique within the Stored Procedures folder, and click on the–>arrow to feature it to the Selected Tables list.

The Enter Parameter Values dialog field seems.

Highlight a parameter in the Parameter Fields listing.

Assign a value with the aid of typing into the Discrete Value container and then click on OK.

You are lower back to the Database Expert.

Click OK and create your report using the fields inside the stored technique.

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

Yes. The following steps work assuming you've got Crystal Reports on the machine and the ideal export dlls loaded.

Open the record.

Preview it.

Click the EXPORT envelope.

Select REPORT DEFINITION for the layout.

Select DISK FILE.

Click OK.

Enter a file call or receive the default.

Click SAVE. The file is a text record and may be regarded with NOTEPAD.

Q23. Can We Export Data Of Reports Into Other Format Like In Word Doc Etc?

Generated statistics can be exported to word doc, or in rich text format. Just click on on ‘Export’ icon within the menu. Export dialog box can be popped up. It will ask for the ‘Format’ like comma­separated value (csv) and so forth and the ‘Destination’ like disk, utility and so on. After that it'll ask for the record call and store the facts.

Only restrict is formatting of information can be misplaced, but crystal document will attempt to maintain as a whole lot formatting as it can.

Q24. Explain How Can You Connect Crystal Report To The Databases?

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 means of crystal document.

Q25. Explain How Can You Burst Crystal Reports By E-mail?

There are traditionally three techniques to burst crystal reviews by using electronic mail :

Using a PDF tool.

Using Crystal Reports Scheduler consisting of CRD.

Data driven publishing method.

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

Report has were given standard sections like ‘Page Header’, ‘Page Footer’, ‘Report Header’, ‘Report Footer’, and ‘Details’.

However you can upload other sections additionally. Select ‘Sections’ within the Insert menu item. You can insert organization sections also.

If you don’t want to show any section simply proper click on that phase and suppress that.