ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Crystal Enterprise Suite
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
How can we performance tune reports?
 Question Submitted By :: Kolli
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can we performance tune reports?
Answer
# 1
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 ?    5 Yes 1 No
Sourabh Gosain
 

 
 
 
Other Crystal Enterprise Suite Interview Questions
 
  Question Asked @ Answers
 
How can we create diff. types of templates? eDynamic-LLC1
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? Bhawan-Cybertek1
How can we know the time taken for particular report execution? eDynamic-LLC2
In one subreport how many subreport we can insert? eDynamic-LLC2
3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle? Bhawan-Cybertek1
Is it possible to design report layout in crystal reports without Database info?  1
What is subreport? In one report maximum how many subreport we can insert? eDynamic-LLC1
What is the difference between running total and sub-total?  3
11.How do we format field? 12.How do we connect to the database? Bhawan-Cybertek1
Can we stop the database null values?How? eDynamic-LLC3
6.What are the sections that we have in Crystal reports? Bhawan-Cybertek1
What is OLAP grid? Where it is used? eDynamic-LLC1
5.Can we add any database field once we have chosen ?Close? button? Bhawan Cybertek 1
How can we performance tune reports?  1
How many different types of reports we can create in Crystal reports? eDynamic-LLC3
1.What is caching? What are the different types of caching? 2.Is there any feature like summing total in crystal report? Bhawan-Cybertek2
What is the section expert? Why we use it? eDynamic-LLC1
13.Can we use Crystal report as a stand-alone application? Bhawan-Cybertek2
7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report? Bhawan-Cybertek1
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? Bhawan-Cybertek2
 
For more Crystal Enterprise Suite Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com