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

Posted on 2006-05-01
Last Modified: 2008-02-01
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?
Question by:chaverly
    LVL 42

    Accepted Solution

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

    Expert Comment

    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

    LVL 42

    Expert Comment

    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.


    Author Comment

    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.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now