Report with Summary & Detail - Exporting to PDF in Crystal Report

[Former Member]

Hi,

I am using Crystal Reports XI (release 2). I am trying out a report with Summary and Detail sections.

Requirement:

1. Report should display both Summary and Detail Sections

2. Summary section should be displayed first followed by Detail Section

3. A field in summary section should have a hyperlink to Detail Section

4. On clicking the hyperlink the user should be navigated to the corresponding detail record

5. User should be able to download the whole report as a single PDF (i.e., both summary and detail together)

Implementation in Crystal Report:

This feature could be implemented using

a. Linked On Demand Sub report

b. Using Hide (Drill down ok) option

c. Hyperlinks

Issue Faced:

I used the on demand sub report option. When i clicked on the sub report (hyperlink), the details get displayed. But the details get displayed in separate viewer and hence when we export to PDF both summary and detail are not getting exported together. User has to select each detail report and export to PDF. Is this a limitation in CR XI? - proprietary Crystal Report features, such as drill-down and on-demand subreports, are supported only in the native Crystal Report format. These special features are ignored when exporting a report to a non-Crystal format like pdf.

Is there any workaround for exporting both the summary and detail (in subreport) as a single PDF file?

Any help will be greatly appreciated.

Thanks,

Viji.

[former_member207342 · Accepted solution]

If you are using Ondemand subreport. Crystal always opens it in new window/viewer. So Exporting it together is not possible.

Instead of On demand subreport you can try inserting normal subreport (No Hyperlink). But It will make you report very long if Detailed data is big.

Also, Drill Down in PDF is not possible as it's static data after exporting it in PDF format.

--Kuldeep

Edited by: Kuldeep Chitrakar on Dec 24, 2008 9:38 AM

[Former Member · Accepted solution]

Is it possible to create a hyperlink on a field from the main report to sub report? If yes, pls give the steps.

To be more precise, if i have all employee summary into in main report, by clicking on emp id, it should navigate to that emp id's detail present in the sub report. This sub report will be placed in report footer.

Thanks,

Viji,

[Former Member · Accepted solution]

Hi

Hyperlink would not be a solution to what you are asking for.

If you want to see the records related to a particular employee id by clicking on emp id, you can try the below:

- Apply a group on employee id on the main report.

- Insert a subreport with the required fields and place it on the Employee id Group header. You can put a name of the subreport as "Check Employee details" or something else as per requirement and make it a on demand subreport.

- Link the subreport on Employee id.

Hope this helps!!!

Regards

Sourashree