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

Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities

2 Answers  


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

2 Answers  


hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button.

0 Answers  


How to Filter the Crystal reports?

12 Answers   CCIL, Mammut Building Systems,


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,






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

2 Answers   MPS Techologies, Target,


How to refresh the crystal report from the application ?

6 Answers   Satyam,


How many sub-reports can report can have?

4 Answers   IBM,


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 the data expert of flash object(after inserting flash object_right click-data expert) is useful in crt?

0 Answers  


I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,


Can we use our own SQL for creating a report?

5 Answers  


Categories