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

Answers were Sorted based on User's Feedback



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

Answer / pratiba

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.......

Is This Answer Correct ?    13 Yes 4 No

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

Answer / ravi kumar noneria

Yes, Create a main Report, and insert sub report in main
report or you can create subreport seperately.
Click on Insert menu, select subreport
option, and select an existing report or create as well,
and click on link tab to link comon parameter which is
required to run report.
Now Export the report to Excel format.......

Is This Answer Correct ?    3 Yes 1 No

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

Answer / akshaya

Create a main Report, and insert sub report in main
report or you can create subreport seperately.
Click on Insert menu, select subreport
option, and select an existing report or create as well,
and click on link tab to link comon parameter which is
required to run report.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / rocky

yes it is possible.

You can add one parameter for excelexport. set the
parameter values as '0' = true and '1' = false. when run
the report select the parameter value 0

Is This Answer Correct ?    0 Yes 18 No

Post New Answer

More Crystal Reports Interview Questions

Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers

3 Answers   Wipro,


What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?

3 Answers  


One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita

5 Answers   Barclays,


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

0 Answers  


Kindly Help for this Below Scenario, I am going to implement Power BI into our internal software. I’m familiar with the fact that each user can pay $9.99 a month to build and view reports but what I need to know is how can we embed Power BI into our application so that any users that log into our application can see the reports without the monthly fee. I’ve researched enough that it can be done. What I am not familiar with is how to do it or the pricing of embedding it into an application. I think they do pricing on how many renders you do or something. Would you be able to look into how we could embed it into our software and the cost?

0 Answers   Cognizant,


how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!

0 Answers  


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

9 Answers   CSC, ERS, Jupiter,


How many .rpt files are be there in a main report having 2 sub reports?

17 Answers   Accenture, Cap Gemini, CTS,


Is there a way to export a report definition without writing code?

2 Answers  


Can we call or add subreport within subreport?

10 Answers  


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

0 Answers  


reporter footer contents are move depend the page footer values...........

2 Answers  


Categories