When I export an On demand subreport to a pdf format, cannot open subreport

I am using Crystal Versions 9 and 11.  The problem applies to both versions, but  I use 11 for this example.  I am exporting a report to adobe.pdf.  When I export the report, I am not able to click on the On-demand subreport and get anything.

I tried creating a text box and formatting it on the Hyperlink tab to open a file that is the subreport.  But without the user parameters, I am not getting anything.  

Is there anything I can do to make this work?
chaverlyAsked:
Who is Participating?
 
frodomanCommented:
>>> Is there anything I can do to make this work?

No.  On-demand subreports aren't exported as part of a report.  You can of course open the subreport and export it separately but to the best of my knowledge it won't export with your main report.

As a workaround you could create a separate report that includes this as a normal subreport (not On-Demand).  Your application can show the current version to the user in the viewer but if they want to export you can export to version that has a normal subreport.  To accomplish this you'll need to create your own export button and handle the exporting behind the scenes - if you let the user click the viewer's export button then you can't change out the report being exported.
0
 
mlmccCommented:
Agree. On-Demand subreports are just that.  Since the export doesn't click on them.

Here is a walk through on how to get them exported through an application.  A separate version of the report is not required

http://support.businessobjects.com/library/kbase/articles/c2012680.asp

mlmcc
0
 
frodomanCommented:
Good point - a separate version of the report isn't necessarily required.  Keep in mind though that the walkthrough changes the status of the subreports before the report is loaded so the subreports won't be viewed as On Demand either with this approach.

If you want to keep them as On Demand for viewing probably a hybrid approach is best.  Display the report normally.  Use a seperate export button as I described earlier only instead of loading a different report to export just load the same report and follow the walkthrough to change the subreports to normal mode.

frodoman
0
 
chaverlyAuthor Commented:
Thanks to both of you.  I had already checked out the above hyperlink from a previous post.  I was hoping something had changed with version XI.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.