1. Is it possible to export crystal report with linked subreports in one excel sheet? If yes,then how?

Yes, Create a main Report, and sub report seperately.
Open the Main Report and in Insert menu, select subreport
option, and in that "select an existing report",select the
sub report which is already created, and pt the link
between Main report and sub report with the required
fields. Now Export the report to Excel format.......

2. How many Sub Reports added in One MainReport?

The correct answer is,

At most you can add 255 sub reports in the main report. so
the total count is 256 reports are allowed for a standalone
report.

You can not add a sub report inside a sub report. This is
one of the important question as far as for interview point.

3. How to add Crystal Reports(Standalone) to my VB.NET project?

There are 2 versions of crystal reports available

1. standalone reports like Crystal Reports 10,XI,XI R2

2. Crystal Reports which comes with Visual Studio .Net like
Crystal Reports for Visual Studio-Embedded Reports

if want to add reports, then go to Add Existing Item (right
click on the project name in the solution explorer), browse
to the .rpt file and select it or Add New Item an select
Crystal Reports from the Templates.

if you want to display reports, you should use Crystal
Repors Viewer

coding:

private ReportDocument hierarchicalGroupingReport;

protected void Page_Init(object sender,eventargs e)
{
configurecrystalreports();
}
private void configurecrystalreports()
{
hierarchicalGroupingReport=new ReportDocument();
string reportPath=server.mappath("Hierarchical
Grouping.rpt");
hierarchicalGroupingReport.Load(reportPath);
CrystalReportViewer1.ReportSource=hierarchicalGroupingReport
;
}

4. How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)?

There are multiple ways to do that...


1. Using Report bursting indexes.
2. and Sub reports degrade the performance, So avoid using
sub reports

5. I am developing reports using crystal reports in VS2005 in windows application. I have two crystalreports name called "studentReport" and "familyReport". I have a form with a button. If I click the button I need to show up the two
reports in one report like page1, and page2. The page1 consists the "studentReport" and the page2 contains the "familyReport". The "familyReport" contains different header and footer.

How to show up the two crystal reports in single crystalreportviewer?

If I am not mistaken then this can be achieved by make
Student report as main report and your other report
familyreport as subreport of the main report opening in new
page.

For different page header of both report what you can do is
in main report dont put any thing in PageHeader or Footer
create a blank group in that create page header for main
report and in group footer create main report page footer
data and on group select option repeat on each page.

May be this will help to solve your problem if I have
understand what you are looking for.

6. Why is Excel Report preferred over crystal reports?

As every Windows OS has Microsoft Excel reports and as it is simple, people are familiar with it.
It has formula field in it to do calculations.

8. Explain reporter footer contents are move depend the page footer values?

Yes we can change the value of report footer depending on
the page number contents.

Create a formula '@formula'

towords(pagenumber,0)

plcae it in RF which will show the last page number in
words.

suppose total number of page is 24 then 'Twenty Four'.
if total pages are 5 then 'Five'.

9. HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM?

different 5 condition is a=1,2,3,4,5

in button click
we write

if a=1 then
Dim report as new cr_1
cr_1.show
else
Dim report as new cr_2
cr_2.show
else
Dim report as new cr_3
cr_3.show
else
Dim report as new cr_4
cr_4.show
else
Dim report as new cr_5
cr_5.show
end

10. Where can we find the log file generated when we run a crystal report?

When the reports run, a log file is created and each
report's output will placed the specified output directory
with the output file name specified. If only a prefix is
specified, the output name will also have a date and time
stamp making it easy to archive reports for later viewing.

Download Interview PDF