Crystal Enterprise Suite Interview Preparation Guide
Download PDF

Crystal Enterprise Suite frequently Asked Questions in various Crystal Enterprise Suite job Interviews by interviewer. Get preparation of Crystal Enterprise Suite job interview

27 Crystal Enterprise Suite Questions and Answers:

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

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.

2 :: How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema?

Crystal Dictionaries are simply Database Views. All we can
suggest is you open the Cr Dictionaries in the Dictionary
Designer to get the info out and then you'll have to create
a new report. There is no way to convert a report that used
a Dictionary to hit the database directly.

1) As dc5 files were never meant to be used in any
development at all, I would be surprised is this worked
without issues

2) As CR 8.5 and dc5 have been out of support for close to
7 years, it will be quite hard to find anyone that has any
expertise in this

3) You are using the Report Designer Component
(craxdrt.dll) in .NET. The RDC has not been tested in .NET
and as such is not supported in .NET of any version

3 :: How to performance tune reports?

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.

4 :: What is the difference between running total and sub-total?

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
The balance us sub total

5 :: How to know the time taken for particular report execution?

menu - performance information. it gives all the details

6 :: How to create diff. types of templates?

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.

7 :: Can we stop the database null values? How?

1. Go to Record!Selection formula.
2. Record!In the formula workshop.
isnull({Customer.Address2}) = false // Customer.Address is
the field

8 :: What is the section expert? Why we use it?

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.

9 :: How can we change the Hierarchi of group? and for parameter also?

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.

10 :: How many types of subreport are there?

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.