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)

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,

---

How can we create diff. types of templates?

1 Answers   eDynamic LLC,

---

Can we stop the database null values?How?

3 Answers   eDynamic LLC,

---

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,

---

How many types of subreport are there?

3 Answers   eDynamic LLC,

---

---

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

1 Answers  

---

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

2 Answers  

---

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

0 Answers  

---

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,

---

How many different types of reports we can create in Crystal reports?

6 Answers   eDynamic LLC, Jump Games,

---

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

2 Answers   Bhawan Cybertek,

---

What is the section expert? Why we use it?

2 Answers   eDynamic LLC,

---