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 |
How can we change the Hierarchi of group? and for parameter also?
1 Answers eDynamic LLC, ZoneTech,
What is subreport? In one report maximum how many subreport we can insert?
2 Answers Cognizant, EDS, eDynamic LLC,
Is it possible to design report layout in crystal reports without Database info?
How many types of subreport are there?
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?
How many different types of reports we can create in Crystal reports?
6 Answers eDynamic LLC, Jump Games,
13.Can we use Crystal report as a stand-alone application?
How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?
How can we create diff. types of templates?
What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.
How can we performance tune reports?
How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?