Crystal Enterprise Suite Interview Preparation Guide
Enhance your Crystal Enterprise Suite interview preparation with our set of 27 carefully chosen questions. Each question is designed to test and expand your Crystal Enterprise Suite expertise. Suitable for all experience levels, these questions will help you prepare thoroughly. Access the free PDF to get all 27 questions and give yourself the best chance of acing your Crystal Enterprise Suite interview. This resource is perfect for thorough preparation and confidence building.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.
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
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.
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
Balance
The balance us sub 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
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.
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
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.
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.
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.
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.