Interested to Buy Any Domain ? << Click Here >> for more details...
How can we performance tune reports?
- 1 Answers
- 9909 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 |
11.How do we format field? 12.How do we connect to the database?
How many different types of reports we can create in Crystal reports?
6 Answers eDynamic LLC, Jump Games,
How can we change the Hierarchi of group? and for parameter also?
1 Answers eDynamic LLC, ZoneTech,
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?
7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report?
2 Answers Bhawan Cybertek, ICICI,
How can we know the time taken for particular report execution?
What is the difference between running total and sub-total?
"how much experience you have in crystal report ?"
Is it possible to design report layout in crystal reports without Database info?
How can we create diff. types of templates?
6.What are the sections that we have in Crystal reports?
3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?
Teradata 
