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)

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

1 Answers   Bhawan Cybertek,

---

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

2 Answers   Bhawan Cybertek,

---

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,

---

6.What are the sections that we have in Crystal reports?

2 Answers   Bhawan Cybertek,

---

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 change the Hierarchi of group? and for parameter also?

1 Answers   eDynamic LLC, ZoneTech,

---

How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?

0 Answers  

---

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

1 Answers  

---

What is an enterprise?

0 Answers   Mahatma Gandhi University,

---

How can we create diff. types of templates?

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,

---

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.

0 Answers   Atos Origin,

---