How can we performance tune reports?

Question Posted / kolli

1 Answers
9801 Views
I also Faced
E-Mail Answers

How can we performance tune reports?..

Answer / sourabh gosain

For tuning of reports we can use the following ways
1 Check the option Perform grouping on Server, Use indexes
or server for speeds.
File>Report Option>Perform grouping on Server.
File>Report Option>Use indexes or server for speeds.
2 Instead of joining DB tables on report , use add command
option. Put all the filters, Prompts in SQL command. This
way report will run faster.
3 Uncheck option save data with report.
File>Report Option>Save data with report.
4 If report contain Many Sub reports, use a prompt which
ask whether you want that particular data or not. If Use
chooses no, then that prompt’s data value should be in
Report selection criteria of report. based on that value do
coding to not to get data on report.
(With Best of my knowledge)

Is This Answer Correct ?

14 Yes

1 No

Post New Answer

More Crystal Enterprise Suite Interview Questions

"how much experience you have in crystal report ?"

1 Answers CTS, Infosys,

15.What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?

2 Answers Bhawan Cybertek, CTS,

5.Can we add any database field once we have chosen ?Close? button?

1 Answers

9.Can we export data of reports into other format like in world doc etc? 10.Can we create report using more than one database?

1 Answers Bhawan Cybertek,

Is it possible to design report layout in crystal reports without Database info?

2 Answers

How can we change the Hierarchi of group? and for parameter also?

1 Answers eDynamic LLC, ZoneTech,

3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?

1 Answers Bhawan Cybertek,

13.Can we use Crystal report as a stand-alone application?