To manage your data crystal report have several options while SSRS does not have any.Export to Excel in SSRS is easy than Crystal Report.SSRS has table base design pattern while in CR you can place objects anywhere.In SAP Crystal, you have following featuresħ) Mention what are the data source that SAP business one supports for Crystal reports?įor crystal reports the data-source that SAP business one supports areĨ) List out some of the key difference between SSRS and Crystal Report? Avoid using sub-reports as it hampers the performanceĦ) Mention what all new features available in SAP Crystal?.To improve the performance of Crystal Reports No, it is not possible to edit SQL made by crystal reports, however you can view the SQL.ĥ) Explain how can you enhance the performance of Crystal Reports? 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.Ĥ) Is it possible to edit SQL made by Crystal Reports? For that from insert menu item choose “Formula Field”.
Yes, it is possible to create your own formulas in Crystal reports.