Question 1. Explain What Is Crystal Reports?
Crystal file is a window based record creator that allows the programmer to make reports from extraordinary facts resources with not less than written code. Crystal file can get admission to records from diverse facts-bases and may synchronize information from more than one databases right into a single report.
Question 2. Explain How Can You Connect Crystal Report To The Databases?
To join crystal report to the databases, there are ways
Use crystal report built in question.
Use the device “Crystal SQL Designer” given by using crystal document.
SAP BI Interview Questions
Question three. Explain Whether It Is Possible To Create Our Own Formulas In Crystal Reports?
Yes, it is feasible to create your personal formulas in Crystal reviews. For that from insert menu object pick out “Formula Field”. Write the method in “Formula Editor”, right here you will see “Function Tree” , “Field Tree” , “Operator Tree” which will show the report fields, functions supported by means of crystal reviews, operators and so on.
Question four. Is It Possible To Edit Sql Made By Crystal Reports?
No, it isn't feasible to edit SQL made through crystal reports, however you could view the SQL.
SAP BI Tutorial
Question 5. Explain How Can You Enhance The Performance Of Crystal Reports?
To improve the performance of Crystal Reports :
Avoid using sub-reports because it hampers the performance.
Use record bursting indexes.
SAP BO Interview Questions
Question 6. Where Is The “keep Data With Report” Option?
You can find File menu
Question 7. Can We Create Report Using More Than One Database?
We can create record the usage 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 restriction is if you use databases then you definately cannot see the SQL generated by crystal reviews.
SAP BO Tutorial SAP Crystal Reports Interview Questions
Question eight. 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 enforce link created in file. Enforcing a link among tables ensure that the report’s respective SQL makes use of this hyperlink, regardless of whether or not fields are required from one or each the worried tables. The default characteristic is unenforced links, which means that that the crystal record makes use of the link simplest if the report’s respective SELECT statement wishes it.
Question 9. Mention Whether We Can Use Our Own Sql For Creating A Report?
You can create your very own query by using tool “Crystal SQL Designer”. You can insert your own SQL assertion, it'll shop your report as “.Qry”. Also, even as creating a file rather than using “Database” button use “Crystal SQL Statement” button.
SAP BPC Interview Questions
Question 10. Explain How Can You Burst Crystal Reports By E-mail?
There are historically three strategies to burst crystal reports by way of e mail :
Using a PDF device.
Using Crystal Reports Scheduler together with CRD.
Data pushed publishing technique.
SAP Crystal Reports Tutorial
Question 11. Mention If There Are Any Limitation Of Crystal Report?
Limitation of crystal report includes :
If database is having subject whose length is greater than 255 characters then you cannot make system using that area.
Formatting is misplaced while exporting records.
By proper clicking on the sphere you can browse statistics that is inside the database and now not the information decided on through the question.
IReport Interview Questions
Question 12. Mention How Many Sub-reports Can Be Added In The Mainreport?
In the MainReport, you may upload 255 sub reviews, and you can't upload sub-record under a sub-record.
SAP BI Interview Questions
Question 13. Explain How Can You Export Crystal Report With Linked Sub-reports Into One Excel Sheet?
First create a prime file and sub report discretely.
Now open the principle file and in the insert menu, select sub-report choice.
In sub-record choice, “choose an current document”.
Choose the sub-record this is already created.
Place the link between the Main file and Sub record with the fields required.
Now, export the document to Excel Format.
SAP BPC Tutorial
Question 14. Explain How Can You Create A Bar-code In Crystal Reports?
To create a bar-code in crystal reviews, you need to observe the subsequent steps :
In crystal record, from the primary menu -> Click on View -> Design -> Field Explorer.
Choose formula area and click on New icon on the top of the menu bar.
Enter the name for the brand new method like MYUPCEANBarcode and click on OK.
Now enter the name and argument into the editor UPCA (items.Item_barcode). The item_barcode is the table name and area call from records supply. Click on Save and Close. The feature names can be indexed underneath someone of the locations, either 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 use it drag/drop it onto the document.
Drag the sphere onto the file and configure its font homes.
Report is ready, click on at the preview to look or print.
Question 15. Can We Use Crystal Report As A Standalone Application?
Generally we use Crystal Reports with VB6. However we will make crystal document standalone application also. But for that trouble is for viewing the record consumer ought to have crystal reports mounted on his/her PC.
SAP ABAP Report Developer Interview Questions
Question 16. How Do We Format Field?
For formatting any area just right click on on it and you'll get many options like ‘Format Field.’ ‘Browse discipline information’ and many others. Click on ‘Format Field.’ You can align statistics, suppress, make it multiline, trade the font length, fashion, and kind, make it link and many others.
If it is an quantity field then you may display currency symbol additionally. Right click on the field pick out ‘Format Field’.
Question 17. Can We Give Parameters To The Report?
We can very well give parameters to the file. For creating parameters choose ‘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 textual content and datatype. Now when you run the report it's going to prompt for these parameters.
SAP ABAP ALV Reports Interview Questions
Question 18. Can We Export Data Of Reports Into Other Format Like In Word Doc Etc?
Generated statistics may be exported to word document, or in rich text layout. Just click on ‘Export’ icon within the menu. Export conversation box may be popped up. It will ask for the ‘Format’ like commaseparated fee (csv) and so on and the ‘Destination’ like disk, software and so forth. After that it's going to ask for the file call and store the statistics.
Only restrict is formatting of information may be misplaced, but crystal document will attempt to hold as tons formatting as it may.
SAP BO Interview Questions
Question 19. Can We Suppress Printing In Crystal Reports If 0 Records Are Fetched?
Yes, we will suppress printing if no records are fetched. Select ‘Report Options’ in File menu object. ‘Report Options’ conversation field will pop up. In that there's one alternative ‘ Suppress printing if no facts’ Check this option. If no statistics are observed then nothing will be imprinted on the record.
Question 20. What Are The Sections That We Have In Crystal Reports?
Report has got wellknown sections like ‘Page Header’, ‘Page Footer’, ‘Report Header’, ‘Report Footer’, and ‘Details’.
However you could upload other sections also. Select ‘Sections’ in the Insert menu item. You can insert organization sections also.
If you don’t want to expose any section just right click on that section and suppress that.
Sap Business One Interview Questions
Question 21. Can We Add Any Database Field Once We Have Chosen ‘near’ Button?
Yes, we will upload any database discipline afterwards also. Select ‘Database Field’ in Insert menu item.
If you are the use of crystal document constructed in query then it's going to display the tables which you have decided on. And you could select whichever field you need to show at the file.
But in case you are using ‘.Qry’ document then it's going to show Query and you could choose handiest those discipline, which might be there in the question.
Question 22. Does Crystal Report Support All The Functions That We Have In Oracle?
No, Crystal report does now not aid all the functions. Like Decode feature is there in SQL however now not there is crystal report. You want to convert that in crystal document layout (in if and else and many others.). However in case you use ‘.Qry’ documents then it take the SQL as such. There is not any want of changing any syntax.
Question 23. Can We Use Stored Procedure For Creating The Report?
Yes, we are able to use stored system.
Question 24. Is There Any Feature Like Summing Total In Crystal Report?
Crystal reviews provide functions like grand overall, subgeneral, jogging total etc. You can select any of those functions in Insert menu object. You can sum up facts on the idea of each document or on trade of organization the use of ‘Running Total ‘ alternative in Insert menu object.
SAP Crystal Reports Interview Questions
Question 25. What Are Crystal Reports And Crystal Reports Explorer?
With Crystal reports explorer it is easy to speedy create and alter reviews on the net, and for the reason that its built at the depended on Business object employer platform, it can without difficulty manage massive consumer masses, man or woman access, and application customization.
Question 26. How To “print” In Crystal Reports While Using Asp Dot Net Platform?
Using Crystal Decisions :
SharedCrystalReport1 cr= new CrystalReport1;here crystalreport1 is crystal report which we design.
CrystalViewer1.ReportSource = cr;
we will immediately print the record with out showing reportCrystalReport1
cr= new CrystalReport1;cr.PrintToPrinter(1,False,1,1);
Question 27. What Are The Advantages Or Disadvantages Of Using Crystal?
Reports in a Windows Forms software as adversarial to say rolling our personal reports as HTML and showing them in the Internet Explorer control.
Secure as End consumer can not alter the statistics that is seem inside the record if we use crystal report to reveal the file however in HTML, user can modify the file statistics.
Report layout isn't transparent, in order that cease user will not know about how we layout the document. But in HTML, absolutely everyone can have a look at the file format and might reproduction the generation.
Can export into different layout like PDF, HTML, XML, etc, and many more.
End person want to have the crystal document viewer in his PC in order to see the crystal document output. But this will be triumph over in case you export the record as PDF/HTML.
You want to buy Crystal Report license for each laptop you're used to design the crystal report.
Must buy the model which lets in you to install run time components in give up person PC.
Crystal Report is gradual as compare to Active Reports.
If we've got a hundred pages record then crystal will need to method all pages after which it suggests the output. And many greater.
SAP BPC Interview Questions
Question 28. Is There A Way To Export A Report Definition Without Writing Code?
Yes. The following steps work assuming you have got Crystal Reports on the system and the proper export dlls loaded.
Open the document.
Click the EXPORT envelope.
Select REPORT DEFINITION for the format.
Select DISK FILE.
Enter a record call or accept the default.
Click SAVE. The file is a textual content file and may be considered with NOTEPAD.
Question 29. What Is The “refresh” Button Suppose To Do On The Crystal Report Viewer?
When you operate Refresh Button in crystal record viewer, it refreshes the document statistics.
When you refresh records from the Preview tab, the Refresh Report Data conversation box seems Select the “Use current parameter values” option to use the contemporary parameter cost, Select the “Prompt for brand spanking new parameter values” choice to input a brand new parameter fee.When you select this selection and click OK, the Enter Prompt Values conversation field seems. The application now runs the report the use of the new value(s) you specified.
Question 30. How To Pass Stored Procedure Parameters To The Report?
Choose File–>Options menu.
In the Options conversation field :
Click the Database tab and ensure that Stored Procedures is selected. Selecting “”Stored Procedures”” routinely shows any to be had saved procedures when you log on to an SQL database.
Click OK to go out the Options conversation container.
On the Start Page, click on Blank Report.
Locate and select the SQL Server facts supply that incorporates the saved manner you want to use.
Click Next to go to the Connection Information conversation field–>Enter the specified facts to log in.
Highlight an SQL stored procedure in the Stored Procedures folder, and click the–>arrow to feature it to the Selected Tables listing.
The Enter Parameter Values dialog box appears.
Highlight a parameter inside the Parameter Fields listing.
Assign a cost by typing into the Discrete Value field and then click OK.
You are lower back to the Database Expert.
Click OK and create your record the use of the fields in the stored system.