| 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.  |
| 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)  |
| 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  |
| 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.  |
| 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.  |
| 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  |
| Kavitha Kondapally |
| |
| |
| Answer | I think the navigation is:
Report>Performance Information  |
| 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.  |
| 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.  |
| Anamika |
| |
| |
| Answer | 1. Go to Record!Selection formula.
2. Record!In the formula workshop.
isnull({Customer.Address2}) = false // Customer.Address is
the field  |
| 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.  |
| 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.  |
| 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.  |
| 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.  |
| 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.  |
| 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......  |
| 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  |
| Kavita |
| |
| |
| Answer | No. in Sub Report we cann't insert subReport.  |
| 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.  |
| 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.  |
| Shyam Prabhu |
| |
| |
| Answer | 1.Form/Layout
2.Summary
3.Listing Reports
4.mail
5.drilldown  |
| As |
| |
| |
| Answer | 1 Graphical Report
2 Grid Report
3 Customised Formatted Report.
4 On demand Sub Report
5 Alert Report.  |
| 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  |
| Chandrasen |
| |
| |
|
| |
|
Back to Questions Page |