Linking one report to another

Posted on 2006-03-21
Last Modified: 2012-08-14
I work for a police department. We use several different Crystal Reports. Most are pretty basic. I need to 'link' these reports to each other, if that is the correct terminology

Here's what the Captains want: Say they run a Burglary report. The report lists the case number of the burglary and some other info. They want to be able to click on the case number in the Burglary report and have another report open that gives more details about that case. Both of these reports are already written.

 I just need to find a way to get the Captains from one to another without them having to 'manually' open two reports.

Question by:bgbissell
    LVL 28

    Expert Comment

    You can do this through On Demand Subreports.

    Open the Burglary report.
    Go to the Insert menu, choose Subreport.
    Choose an exiting report and navigate to the report that you have and click OK.
    Click the link tab and make choose the Case Number from the main report and link it to the case number in the subreport.
    Drop the subreport next to the existing Case Number for a bit.
    Right click the subreport, and choose Format Subreport from the popup.
    Click the Subreport tab.
    Click the property "On Demand Subreport"
    Click the X+2 button to the right of "On Demand Subreport Caption"
    Add the Case Number field to the editor.  You may have to convert it to a string using the ToText function: ToText({table.casenumber},0,"")
    Save and Close.
    Resize the subreport and modify the fonr and color as necessary.
    You can now delete the original Case number field is you want.
    When you run the report, the subreport will display as a hyperlink with the case number value, which when clicked will open up the subreport for just that case.
    LVL 6

    Accepted Solution


    You can make in your Burglary Report the case number field as a hyperlink to Case Report.
    In CR Desigder rightclick on the field, select Format Field, and open Hyperlink tab.

    Thank you,
    LVL 100

    Expert Comment

    Sounds like a good idea.


    Author Comment



    It does create a hyperlink, and it does bring up the more detailed report, but the report doesn't populate fully. Most of the information does not appear.

    The report I'm linking to is the more complex of the two and contains a ton of subreports itself, if that matters.

    Any suggestions?


    LVL 28

    Expert Comment

    You will have a problem doing this then.
    Crystal does not allow you to have a subreport within a subreport.
    You might explore the Hyperlink suggestion by PWinter and see if that is a possibility.

    Author Comment


    what do you do after you open the Hyperlink tab?


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    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 …
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    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…

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now