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   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Data-Warehouse >> Crystal-Enterprise-Suite
 
 


 

Back to Questions Page
 
Question
Is it possible to design report layout in crystal reports 
without Database info?
Rank Answer Posted By  
 Question Submitted By :: Krishnaburi123
I also faced this Question!!   © ALL Interview .com
Answer
Yes, It is possible design report layout in crystal reports 
without Database info. There will be no database connection 
and only the template will be there. We can add date, text 
field etc. in the report.
 
0
Prashant
 
 
Question
How can we performance tune reports?
Rank Answer Posted By  
 Question Submitted By :: Kolli
I also faced this Question!!   © ALL Interview .com
Answer
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)
 
0
Sourabh Gosain
 
 
Question
What is the difference between running total and sub-total?
Rank Answer Posted By  
 Question Submitted By :: Kolli
I also faced this Question!!   © ALL Interview .com
Answer
running total is line by line total 
Ex : Debit credit Balance

the balance is the running total

sub total is after last record 
exp : Debit Credit
Balance 
The balance us sub total
 
0
Syed Shafeeq Ahamed
 
 
 
Answer
running total gives total of value at the end of Page.
 if you have 5 pages of data. Each page contain 10 row of 
data with each column's value as 1. Then running total will 
give you value as 10 on1st page 20 on 2nd page 50 on last 
page. 
Where as Sub Total will give you value 50 only.
 
0
Sourabh Gosain
 
 
Answer
A subtotal is a summary that totals or sums numeric values 
in a group.

Running totals are a flexible and powerful way to create 
specialized summaries and continually incrementing totals.
 
0
Pandian
 
 
Question
How can we know the time taken for particular report execution?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
go menu - performance information. it gives all the details
 
0
Kavitha Kondapally
 
 
Answer
I think the navigation is:
Report>Performance Information
 
0
Naresh
 
 
Question
How can we create diff. types of templates?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
Basically, what is a template.....a set of object frames 
placed in a way that suits most of the requirements of day 
to day office work.

To create a template, u can either develop a variation from 
the existing templates of the Crystal reports Suite or open 
a saved report, , in the new report u r creating, click on 
the template expert and choose template from existing file.
the template, that is the object frames and not the data 
will be copied to the new report u r developing.
even , now u have the liberty to make changes, and save 
them for future use as template!
So u can literally create as many differnt types of 
templates as u like through all the templates already 
available or the reports u created from teh scratch.
 
1
Rana
 
 
Question
Can we stop the database null values?How?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
Yes, we can by selecting suppress if null option.
 
0
Anamika
 
 
Answer
1. Go to Record!Selection formula.
2. Record!In the formula workshop.
isnull({Customer.Address2}) = false  // Customer.Address is 
the field
 
0
Ravi Shanker
 
 
Answer
From my point of view one should never check the option 
supress null values from file>report option. Coz it can 
supress a complete group if you have grouping on a column 
having some null values.  
instead of it if you should go to section expert>detail 
part> supress and writ a formula there 
is null(column)
that make that row supressed if a particular column value 
is null.
 
0
Sourabh Gosain
 
 
Question
What is the section expert? Why we use it?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
A section expert is used for the entire section, it could 
be the details section or the header section. Once you 
change the settings in the section expert it can be seen 
through out the section. if we want to make sure that a 
specific data has to be displayed in the entire setion , 
then you can write a formula for that in the section expert 
which will work good for all the sections.
 
0
Vj
 
 
Question
How can we change the Hierarchi of group? and for parameter
also?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC , Zonetech Solutions
I also faced this Question!!   © ALL Interview .com
Answer
Group: To change the group using chang group option. or 
goto the group expert we can change the group.

Parameter: To set the parameter order. To change the 
parameter value goto edit menu.
 
0
Ravi
 
 
Question
How many types of subreport are there?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
There are two types of subreports
 a.Unlinked Subreport
       ie the subreport doesn't depend on the main report 
at all.
 
 b.Linked subreport

  A linked subreport is handy when we need to display 
related data elements from more than one database table on  
a report.
 
0
Ajish M B
 
 
Answer
There are three types of subreports
a.Unlinked Subreport
       ie the subreport doesn't depend on the main report 
at all.
 
b.Linked subreport

  A linked subreport is handy when we need to display 
related data elements from more than one database table on  
a report
 
c.On-Demand Subreport

If your report has a section that handles a large number of 
records, you can put that section into an on-demand 
subreport. An on-demand subreport appears as a hyperlink in 
the primary report. When you open the primary report, no 
data is retrieved for the on-demand subreport until you 
drill down on the hyperlink.
 
0
Swapna
 
 
Answer
agreed with answer of Swapna.
Just a bit more information. 
You can not schedule an On-Demand Subreport on Crystal 
Enterprise, as you can give server info only to main report.

if it as linked or unlinked report it will run along with 
the main report, where as if report is schedulled, you get 
a copy of it, at that time you will have to click on hyper 
link to get the report run. that time it will ask for 
server info which you cant give.
give it a try if you are not getting it fully......
 
0
Sourabh Gosain
 
 
Question
In one subreport how many subreport we can insert?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
You cannot insert any subreport in a subreport
 
0
Kavita
 
 
Answer
No. in Sub Report we cann't insert subReport.
 
0
Ravi
 
 
Question
What is subreport? In one report maximum how many subreport
we can insert?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC , Eds, Cognizant
I also faced this Question!!   © ALL Interview .com
Answer
Subreport is like the main report however the values from 
the subreport can be passsed to the main report. If we wish 
to link the subreport to the main rport then it is called 
as a 'Linked Sub report' else it is a 'Un linked Sub 
report'. Any number of sub reports ca be placed in a main 
report. However the maximum number being 256. In practise 
you would never have so many sub - reports in a main 
report.
 
4
Vj
 
 
Question
How many different types of reports we can create in Crystal
reports?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC , Jumpgames, If U Dont't Mind Last Year Appsc Group-1 Question Papper Is Available Now
I also faced this Question!!   © ALL Interview .com
Answer
You can create report types like

1.Form/Layout
2.Summary
3.Listing Reports

Moreover you can create your own report format and make it 
as template for your other reports in Crystal.
 
3
Shyam Prabhu
 
 
Answer
1.Form/Layout
2.Summary
3.Listing Reports
4.mail
5.drilldown
 
4
As
 
 
Answer
1 Graphical Report
2 Grid Report
3 Customised Formatted Report.
4 On demand Sub Report
5 Alert Report.
 
0
Sourabh Gosain
 
 
Question
What is OLAP grid? Where it is used?
Rank Answer Posted By  
 Question Submitted By :: Kalpesh
This Interview Question Asked @   eDynamic-LLC
I also faced this Question!!   © ALL Interview .com
Answer
Use the OLAP Grid command to insert an OLAP Grid into your
report. When you choose the OLAP Grid command, the OLAP
Expert appears. The term OLAP is used to refer to all common
forms of OLAP (Online Analytical Processing) and
multi-dimensional data storage and access systems.
Chandrasen
 
0
Chandrasen
 
 
 
Back to Questions Page
 
 
 
 
 
   
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