Interview Questions.

Question 1. What Is Crystal Report?

Answer :

Crystal record is a report generation device. Generally have interface with VB6. Crystal record essentially generates dynamic records. You can format the facts in whichever manner you experience like.

Question 2. Can We Use Crystal Report As A Stand-on my own Application?

Answer :Generally we use Crystal Reports with VB6. However we can make crystal record stand-by myself software also. But for that issue is for viewing the record user ought to have crystal reviews set up on his/her PC.

SAP CRM Interview Questions
Question 3. How Do We Connect To The Database?

Answer :There are  ways of creating the document: – Use crystal record built in query. Use the tool ‘ Crystal SQL Designer’ furnished through crystal report. When you create file the use of crystal document built in query then it asks for the records supply call that you have created. When you run the report, then for the primary time it'll ask for the user identity and password. After that it's going to shop the same. When you create ‘.Qry’ the usage of ‘Crystal SQL’ Designer then at that time it'll ask for the consumer identification and password. When you run the document for the first time rather than requesting the person identity and password it will ask for the ‘.Qry’ report area. You can change the question location also. For that open the document, pick out ‘Set Location’ alternative in Database menu item, and set the place.

Question four. How Do We Format Field?

Answer :

For formatting any subject simply right click on it and you will get many alternatives like ‘Format Field.’ ‘Browse discipline facts’ etc. Click on ‘Format Field.’ You can align records, suppress, make it multiline, alternate the font length, fashion, and type, make it link and so on.
If it's far an amount discipline then you could display currency symbol also. Right click on on the sphere pick out ‘Format Field’.

SAP CRM Tutorial
Question 5. Can We Give Parameters To The Report?

Answer :

We can thoroughly deliver parameters to the record. For growing parameters pick out ‘Parameter Field’ in Insert menu object. ‘Create Parameter Field’ conversation container will popped up, it's going to ask for the call of parameter, prompting text and datatype. Now whilst you run the report it's going to spark off for these parameters.

SAP BI Interview Questions
Question 6. Can We Create Our Own Formulas In Reports?

Answer :

We can create our very own formulas in reviews. Select ‘Formula Field’ in Insert menu object. Write the formulation in ‘Formula Editor’. Here you will get ‘Field Tree’, ‘Function Tree’, and ‘Operator Tree’, to be able to display the file fields, functions which might be supported by crystal reviews (like CDATE () and so forth.), operators (arithmetic, strings and many others.) respectively.

Question 7. Can We Create Report Using More Than One Database?

Answer :

We can create file the usage of a couple of database like Oracle, Access. Create information supply call for both the databases. Select tables from them and create the report.
Only restriction is if you use two databases then you definitely can't see the SQL generated via crystal reports.

SAP BI Tutorial SAP MM Interview Questions
Question 8. Can We Export Data Of Reports Into Other Format Like In World Doc Etc?

Answer :

Generated statistics may be exported to word doc, or in wealthy textual content layout. Just click on on ‘Export’ icon in the menu. Export dialog box can be popped up. It will ask for the ‘Format’ like comma-separated price (csv) and so on and the ‘Destination’ like disk, application and so forth. After that it's going to ask for the report call and store the information.
Only restriction is formatting of statistics can be misplaced, however crystal report will try to maintain as a great deal formatting as it could.

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

Answer :

We can also make our personal query the use of ‘Crystal SQL Designer’ device furnished by means of SQL. Here you can insert your SQL announcement as such. It will shop this file as ‘.Qry’ . And while you create a document in place of the usage of ‘Database’ button use ‘Crystal SQL Statement’ button.

SAP BASIS Interview Questions
Question 10. Can We Edit Sql Made By Crystal Reports?

Answer :

We cannot edit the SQL made through crystal reviews. However we can view the SQL. For that select ‘Show SQL Query’ in Database menu object. Limitation is in case you are using handiest one database. If you operate two databases then you could’t even view the SQL organized via crystal document.

SAP MM Tutorial
Question 11. Are There Any Limitations In Crystal Reports?

Answer :

There are positive limitations in crystal reports. They are: –
If database is having discipline whose length is greater than 255 characters, you then cannot make components the usage of that discipline.
While exporting information formatting is lost.
When you browse records simply by right clicking on the field then it shows this is there in the database no longer the records decided on by way of the question.

SAP ABAP Web Dynpro Interview Questions
Question 12. Can We Suppress Printing In Crystal Reports If zero Records Are Fetched?

Answer :

Yes, we are able to suppress printing if no statistics are fetched. Select ‘Report Options’ in File menu object. ‘Report Options’ conversation field will pop up. In that there may be one option ‘ Suppress printing if no data’ Check this feature. If no statistics are discovered then nothing may be imprinted on the file.

SAP CRM Interview Questions
Question 13. What Are The Sections That We Have In Crystal Reports?

Answer :

Report has got wellknown sections like ‘Page Header’, ‘Page Footer’, ‘Report Header’, ‘Report Footer’, and ‘Details’.

However you can add different sections also. Select ‘Sections’ inside the Insert menu object. You can insert institution sections additionally.

If you don’t want to reveal any phase just right click on that segment and suppress that.

SAP BASIS Tutorial
Question 14. Can We Add Any Database Field Once We Have Chosen ‘near’ Button?

Answer :

Yes, we will add any database discipline afterwards additionally. Select ‘Database Field’ in Insert menu object.

If you are using crystal document built in query then it'll display the tables that you have decided on. And you could choose whichever subject you want to display on the report.

But in case you are the use of ‘.Qry’ record then it will display Query and you could pick out only those discipline, which can be there inside the query.

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

Answer :

No, Crystal record does now not guide all the capabilities. Like Decode feature is there in SQL but not there may be crystal document. You need to transform that in crystal file layout (in if and else and so on.). However in case you use ‘.Qry’ documents then it take the SQL as such. There is not any need of converting any syntax.

Business Objects-Crystal Reports Interview Questions
Question 16. Can We Use Stored Procedure For Creating The Report?

Answer :

Yes, we are able to use saved procedure.

SAP ABAP Web Dynpro Tutorial
Question 17. Is There Any Feature Like Summing Total In Crystal Report?

Answer :

Crystal reports offer capabilities like grand general, sub-total, strolling total and so forth. You can select any of those capabilities in Insert menu object.
You can sum up facts on the premise of every report or on change of organization using ‘Running Total ‘ alternative in Insert menu object.

SAP Workflow Interview Questions
Question 18. I Am Using Two Tables One Is Of Access Database And Other Is Of Oracle Database, I Am Getting An Error Saying That ‘sq. Odbc Error’ What Should I Do?

Answer :

If you have become such an errors then click on the icon for ‘Report Expert’. It will deliver a caution announcing that formatting could be lost. Ignore this you will get ‘Standard Report Expert’ conversation container. Reverse the links of get entry to database desk and it'll work.

SAP BI Interview Questions
Question 19. What Are The Advantages Or Disadvantages Of Using Crystal?

Answer :

Reports in a Windows Forms utility as adversarial to say rolling our own reviews as HTML and displaying them within the Internet Explorer manipulate

Advantages

(1) Secure as End consumer can't alter the statistics that is appear inside the file if we use crystal file to reveal the record however in HTML, person can modify the report information
(2) Report layout isn't transparent, in order that quit consumer will now not recognise about how we layout the file. But in HTML, all people can observe the record format and might reproduction the technology
(3) Can export into distinctive layout like PDF, HTML, XML, and so on, and plenty of more.

Disadvantages :

(1) End user want to have the crystal file viewer in his PC that allows you to see the crystal document output. But this will be overcome in case you export the report as PDF/HTML
(2) You want to shop for Crystal Report license for every laptop you are used to layout the crystal document.
(three) Must buy the model which lets in you to put in run time components in end user PC
(4) Crystal Report is sluggish as compare to Active Reports
(five) If we have one hundred pages file then crystal will need to manner all pages after which it suggests the output. And many extra.

JasperReports Tutorial
Question 20. How To “print” In Crystal Reports While Using Asp Dot Net Platform?

Answer :

Using Crystal Decisions. SharedCrystalReport1 cr= new CrystalReport1;’right here crystalreport1 is crystal report which we design.CrystalViewer1.ReportSource = cr; OR we will without delay print the document without showing reportCrystalReport1 cr= new CrystalReport1;cr.PrintToPrinter(1,False,1,1);

JasperReports Interview Questions
Question 21. What Are Crystal Reports And Crystal Reports Explorer?

Answer :

With Crystal reports explorer you will fast create and adjust reports at the web, and given that its built at the relied on Business item agency platform, it could without difficulty manipulate big person masses, person get admission to, and alertness customization.

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

Answer :

Select the sector –>Click FORMAT–>Click FORMAT FIELD–>Select the COMMON tab–>Click the FORMULA BUTTON to the proper of SUPPRESS (Don’t click on the suppress take a look at field)To suppress a field on unusual numbered pages PageNumber MOD 2 = 1To suppress a discipline on even numebred pages PageNumber MOD 2 = zero –>Click SAVE Icon–>Close the formulation editor–>Click OK on the FORMAT display screen

Question 23. How To Pass Stored Procedure Parameters To The Report?

Answer :

Choose File–>Options menu.

In the Options conversation field –>Click the Database tab and ensure that Stored Procedures is selected. Selecting “”Stored Procedures”” robotically presentations any to be had stored methods while you log on to an SQL database.–>Click OK to go out the Options conversation box. –>On the Start Page, click Blank Report.–>Locate and select the SQL Server records source that contains the saved technique you want to apply.–>Click Next to visit the Connection Information conversation box–>Enter the required data to log in.–>Click Finish–>Highlight an SQL saved procedure within the Stored Procedures folder, and click the–>arrow to add it to the Selected Tables listing.–>The Enter Parameter Values dialog field seems.–>Highlight a parameter inside the Parameter Fields listing–>Assign a price via typing into the Discrete Value box and then click on OK–>You are back to the Database Expert–>Click OK and create your document the use of the fields within the stored procedure.

Sap Abap Hr Interview Questions
Question 24. What Is The “refresh” Button Suppose To Do On The Crystal Report Viewer?

Answer :

(1). When you use Refresh Button in crystal file viewer, it refreshes the report data.
(2).When you refresh information from the Preview tab, the Refresh Report Data dialog field appears

Select the “Use present day parameter values” option to use the present day parameter cost,
Select the “Prompt for brand new parameter values” option to enter a new parameter fee.

When you choose this option and click OK, the Enter Prompt Values dialog field seems. The program now runs the file the use of the new price(s) you specified.

SAP MM Interview Questions
Question 25. Is There A Way To Export A Report Definition Without Writing Code?

Answer :

Yes. The following steps paintings assuming you have Crystal Reports on the device and the best export dlls loaded.

Open the record
Preview it
Click the EXPORT envelope
Select REPORT DEFINITION for the format
Select DISK FILE
Click OK
Enter a document call or receive the default
Click SAVE. The file is a text file and can be considered with NOTEPAD.
Question 26. Is There A Way To Export The Report Formulas, Like Totals To Excel?

Answer :

Yeah we can do this using crystal record.

SAP ABAP Report Developer Interview Questions
Question 27. What Does It Mean When We Get The Error Message “invalid Report Version” When Try To Open A Crystal Report?

Answer :

Crystal in its evolution has modified the file document format several times. In maximum instances the record format is FORWARD-well matched. By this I mean a report created in Crystal 6 can be opened in Crystal 6 or higher. When the record layout modifications have been main the layout isn't always BACKWARD compatible. By this I suggest a report created in CR 9 can't be opened in CR eight or earlier than. Crystal modified the report record format with CR 8 and CR nine. The CR 9 trade became because of the advent of Unicode support. CR eight has the capability to shop a record in CR 7 layout. Because of the aid for Unicode CR 9, 10, and XI can not shop the report in preceding formats.

SAP BASIS Interview Questions
Question 28. How To Write A Formula To Change A Font Based Upon Data?

Answer :

Select the sector
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 system editor
Click OK at the FORMAT display screen
Question 29. How To Refresh The Crystal Report From The Application?

Answer :

calling crystalreportcontrolname.Reset (by using deciding on Report menu under Refresh the record menu item at layout time) will refresh the file[crystalreport1.DiscardSavedData=True]

SAP ABAP ALV Reports Interview Questions
Question 30. How Many Sub-reviews Can Report Can Have?

Answer :

zero-256

Question 31. Where Is The “shop Data With Report” Option?

Answer :

You can discover File menu.

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

Answer :

To join crystal file to the databases, there are two methods
1) Use crystal report constructed in query
2) Use the device “Crystal SQL Designer” given through crystal record

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

Answer :

Yes, it is feasible to create your own formulation in Crystal reports. For that from insert menu item choose “Formula Field”. Write the components in “Formula Editor”, right here you'll see “Function Tree” , “Field Tree” , “Operator Tree” as a way to show the document fields, features supported with the aid of crystal reports, operators and so forth.

SAP ABAP Web Dynpro Interview Questions
Question 34. Mention What All New Features Available In Sap Crystal?

Answer :

In SAP Crystal, you've got following features:

Streamlines report design
Improvement to statistics resources
Mobile and viewer support
OEM and developer features
Question 35. Mention What Are The Data Source That Sap Business One Supports For Crystal Reports?

Answer :

For crystal reviews the records-supply that SAP commercial enterprise one helps are 

SAP Business One
OLE DB (ADO)
Question 36. List Out Some Of The Key Difference Between Ssrs And Crystal Report?

Answer :

SSRS has table base design sample while in CR you may place objects anywhere
Export to Excel in SSRS is easy than Crystal Report
To control your records crystal document have several options at the same time as SSRS does not have any
Crystal record has patron facet record introduction API, that allows the customer to modify and create new reviews
SSRS uses expressions while Crystal Report uses formulation in C and basic
SSRS is well suited with Share-factor listing and may generate reports primarily based on lists
Both of them help OLAP connections
Business Objects-Crystal Reports Interview Questions
Question 37. Mention What Is The General Syntax For Creating Sap Business One Token?

Answer :

To create SAP commercial enterprise token the general syntax includes
<Parameter Name>@ SELECT….FROM…..WHERE, the SELECT command isn't always necessary for all tables.

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

Answer :

To edit crystal reviews layout in the SAP business one

Go to the main menu of the SAP business one -> pick management ->installation -> General -> Report & Layout Manager

In Report & Layout Manager window, in the navigation panel at the left, scroll down to the file form of the layout you want to edit

In the paintings space at the right, pick out the crystal reports format you want to edit and choose edit.