How can we performance tune reports?
- 1 Answers
- 9475 Views
- I also Faced
- E-Mail Answers
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 many types of subreport are there?
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 know the time taken for particular report execution?
6.What are the sections that we have in Crystal reports?
1.What is caching? What are the different types of caching? 2.Is there any feature like summing total in crystal report?
How can we create diff. types of templates?
What is the section expert? Why we use it?
How many different types of reports we can create in Crystal reports?
6 Answers eDynamic LLC, Jump Games,
How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema ?
11.How do we format field? 12.How do we connect to the database?
In one subreport how many subreport we can insert?
5.Can we add any database field once we have chosen ?Close? button?
Teradata 
