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)

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,

---

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

1 Answers   eDynamic LLC, ZoneTech,

---

Can we stop the database null values?How?

3 Answers   eDynamic LLC,

---

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

2 Answers  

---

What is OLAP grid? Where it is used?

1 Answers   eDynamic LLC,

---

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,

---

14.How to "Print" in Crystal Reports while using ASP DOT NET Platform?

2 Answers   Bhawan Cybertek,

---

11.How do we format field? 12.How do we connect to the database?

1 Answers   Bhawan Cybertek,

---

How can we know the time taken for particular report execution?

2 Answers   eDynamic LLC,

---

What is the difference between running total and sub-total?

5 Answers  

---

what the mean of version error in crystal?

0 Answers   Symphony,

---

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

1 Answers  

---