Interview Questions.

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

Generated records can be exported to word doc, or in wealthy text layout. Just click on ‘Export’ icon inside the menu. Export dialog container could be popped up. It will ask for the ‘Format’ like comma-separated price (csv) and many others and the ‘Destination’ like disk, utility and so on. After that it's going to ask for the report call and save the records.

Only restriction is formatting of information may be misplaced, but crystal file will try to maintain as an awful lot formatting as it could.

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

Yeah we can try this the usage of crystal document.

Q3. Mention What Are The Data Source That Sap Business One Supports For Crystal Reports?

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

SAP Business One

OLE DB (ADO)

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

Generally we use Crystal Reports with VB@However we can make crystal report stand-by myself utility additionally. But for that problem is for viewing the document user have to have crystal reviews hooked up on his/her PC.

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

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

Q6. How Do We Format Field?

For formatting any area simply right click on it and you may get many options like ‘Format Field.’ ‘Browse discipline statistics’ etc. Click on ‘Format Field.’ You can align information, suppress, make it multiline, exchange the font length, style, and sort, make it link etc.

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

Q7. Can We Give Parameters To The Report?

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

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

In SAP Crystal, you have got following capabilities:

Streamlines report design

Improvement to records assets

Mobile and viewer guide

OEM and developer capabilities

Q9. What Is Crystal Report?

Crystal record is a document era device. Generally have interface with VB@Crystal record essentially generates dynamic facts. You can format the information in whichever way you experience like.

Q10. What Are Crystal Reports And Crystal Reports Explorer?

With Crystal reports explorer you possibly can fast create and modify reviews on the web, and since its built at the depended on Business object company platform, it is able to easily control huge consumer masses, individual get admission to, and application customization.

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

To create SAP enterprise token the general syntax includes

<Parameter Name>@ SELECT….FROM…..WHERE, the SELECT command is not necessary for all tables.

Q12. Can We Create Our Own Formulas In Reports?

We can create our own formulas in reports. Select ‘Formula Field’ in Insert menu item. Write the method in ‘Formula Editor’. Here you'll get ‘Field Tree’, ‘Function Tree’, and ‘Operator Tree’, on the way to display the document fields, functions which are supported through crystal reviews (like CDATE () etc.), operators (arithmetic, strings and so forth.) respectively.

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

We can create document the use of more than one database like Oracle, Access. Create facts source name for both the databases. Select tables from them and create the file.

Only restriction is in case you use  databases then you definately can not see the SQL generated by way of crystal reports.

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

No, Crystal file does no longer help all the capabilities. Like Decode function is there in SQL but now not there may be crystal file. You want to transform that during crystal document format (in if and else and many others.). However if you use ‘.Qry’ files then it take the SQL as such. There is not any want of converting any syntax.

Q15. Are There Any Limitations In Crystal Reports?

There are sure limitations in crystal reviews. They are: –

If database is having discipline whose duration is more than 255 characters, then you definitely cannot make formula the usage of that area.

While exporting statistics formatting is misplaced.

When you browse facts just with the aid of proper clicking on the sector then it shows this is there within the database not the data decided on by the query.

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

Yes, we will suppress printing if no data are fetched. Select ‘Report Options’ in File menu object. ‘Report Options’ conversation container will pop up. In that there may be one choice ‘ Suppress printing if no data’ Check this selection. If no facts are observed then nothing may be printed on the document.

Q17. How Many Sub-reports Can Report Can Have?

0-256

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

Yes. The following steps paintings assuming you've got Crystal Reports on the gadget and the proper export dlls loaded.

Open the document

Preview it

Click the EXPORT envelope

Select REPORT DEFINITION for the layout

Select DISK FILE

Click OK

Enter a file name or receive the default

Click SAVE. The document is a text record and may be considered with NOTEPAD.

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

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

However you could add other sections also. Select ‘Sections’ within the Insert menu item. You can insert group sections additionally.

If you don’t want to expose any segment simply right click on on that section and suppress that.

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

Select the sphere

Click FORMAT

Click FORMAT FIELD

Select the FONT tab

Click the FORMULA BUTTON to the proper of FONTif (YourField = Value) then “Arial”else “Times New Roman

Click SAVE Icon

Close the components editor

Click OK at the FORMAT screen

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

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

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

To edit crystal reviews layout inside the SAP commercial enterprise one

Go to the primary menu of the SAP commercial enterprise one -> pick administration ->installation -> General -> Report & Layout Manager

In Report & Layout Manager window, inside the navigation panel on the left, scroll all the way down to the file form of the layout you need to edit

In the work space on the proper, select the crystal reviews format you want to edit and pick out edit.

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

Yes, it's miles feasible to create your very own formulation in Crystal reviews. For that from insert menu object pick “Formula Field”. Write the formulation in “Formula Editor”, here you may see “Function Tree” , “Field Tree” , “Operator Tree” in order to display the report fields, functions supported by means of crystal reviews, operators and so on.

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

To join crystal report to the databases, there are two approaches

1) Use crystal report constructed in question

2) Use the tool “Crystal SQL Designer” given via crystal report

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

Choose File–>Options menu.

In the Options dialog box –>Click the Database tab and make sure that Stored Procedures is selected. Selecting “”Stored Procedures”” robotically displays any available stored methods when you go online to an SQL database.–>Click OK to go out the Options dialog box. –>On the Start Page, click on Blank Report.–>Locate and select the SQL Server information supply that includes the stored manner you need to apply.–>Click Next to visit the Connection Information conversation box–>Enter the required information to log in.–>Click Finish–>Highlight an SQL stored process in the Stored Procedures folder, and click on the–>arrow to feature it to the Selected Tables listing.–>The Enter Parameter Values conversation container appears.–>Highlight a parameter inside the Parameter Fields list–>Assign a fee by typing into the Discrete Value container and then click OK–>You are returned to the Database Expert–>Click OK and create your file the usage of the fields in the stored system.

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

Reports in a Windows Forms software as opposed to mention rolling our personal reviews as HTML and displaying them within the Internet Explorer control

Advantages

(1) Secure as End person cannot alter the records that is appear inside the record if we use crystal document to show the report but in HTML, consumer can regulate the document statistics

(2) Report layout is not obvious, in order that quit consumer will not realize about how we design the file. But in HTML, anyone can take a look at the file layout and may reproduction the technology

(three) Can export into unique layout like PDF, HTML, XML, and many others, and plenty of more.

Disadvantages :

(1) End consumer need to have the crystal file viewer in his PC as a way to see the crystal document output. But this could be overcome in case you export the file as PDF/HTML

(2) You need to shop for Crystal Report license for each pc you're used to layout the crystal document.

(3) Must buy the version which allows you to put in run time components in quit consumer PC

(four) Crystal Report is gradual as compare to Active Reports

(five) If we have 100 pages report then crystal will want to manner all pages and then it suggests the output. And lots of extra.

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

We also can make our own query using ‘Crystal SQL Designer’ tool provided with the aid of SQL. Here you may insert your SQL declaration as such. It will save this record as ‘.Qry’ . And while you create a file as opposed to using ‘Database’ button use ‘Crystal SQL Statement’ button.

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

SSRS has desk base design pattern even as in CR you could place items everywhere

Export to Excel in SSRS is easy than Crystal Report

To manage your information crystal document have several alternatives while SSRS does not have any

Crystal file has customer aspect record introduction API, that lets in the consumer to regulate and create new reports

SSRS uses expressions while Crystal Report makes use of system in C and primary

SSRS is like minded with Share-factor listing and might generate reports based on lists

Both of them aid OLAP connections

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

Yes, we will use stored technique.

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

Crystal reviews offer features like grand overall, sub-total, running general and many others. You can select any of those functions in Insert menu item.

You can sum up statistics on the premise of each document or on exchange of organization using ‘Running Total ‘ choice in Insert menu object.

Q31. Can We Edit Sql Made By Crystal Reports?

We cannot edit the SQL made with the aid of crystal reviews. However we will view the SQL. For that choose ‘Show SQL Query’ in Database menu item. Limitation is if you are the use of best one database. If you use  databases then you may’t even view the SQL prepared via crystal file.