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

Where is the image located, after youve placed it on the 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 to pass stored Procedure Parameters to the report?

2 Answers  


to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report

2 Answers  


how to create crystal reports in .net

2 Answers   CTS,






How to print two details fields at the bottom of the page

5 Answers  


Is there any feature like summing total in crystal report?

11 Answers   HCL, Sonata,


Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?

0 Answers  


How to access crystal reports in .net?

0 Answers  


Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.

0 Answers  


Does Crystal Report support all the functions that we have in Oracle?

2 Answers   MPS Techologies, Target,


How to open subreport in New IE window using hyperlink button. I used target=new; in the formula field. But it overrides the main window and show the report. Can anybody answer this please....... Regards Vimal.

1 Answers   GRV India, Patni,


Categories