Crystal Enterprise - Linking of reports

Posted on 2014-08-28
Last Modified: 2015-03-05
Hi All,
I have a question on linking the Crystal Reports to Crystal Reports through OpenDocument function.
These two reports are developed by using Crystal Enterprise product.

On click of the Product_ID on the main report, I need to open a new crystal report which provides the detail information of that particular product id.

Please let me know procedure for linking the reports.

Question by:reachsoma
    LVL 34

    Assisted Solution

    I haven't used Crystal Enterprise, so there may be another way to handle this, but in a regular report, you could use an on-demand subreport.  Create a subreport that produces the detail that you're looking for and link the Product_ID in the main report to the subreport.  Put the subreport where the Product_ID field is and go into the subreport format options and check the on-demand subreport option.  Then if someone clicks on the Product_ID field, which also clicks on the subreport, the subreport will open in a new window.

    LVL 100

    Accepted Solution

    We use our own portal and use Report Launcher, but I believe the method of calling OpenDocument is similar.

                + '&Param1=' + {SomeField},"#")&Param2={SomeField}&Start_Date=Date(ToText({@DateOverdue-OpenStart},"yyyy,MM,dd")

    Open in new window

    More parameters can be added by starting with &ParameterName=Value/Field

    You put this in the formula for the hyperlink on the format screen for the linking field.

    If you need help for a specific parameter type just ask

    Author Comment

    Thanks for all your response.

    There is a slight change in the Crystal version, at present we use Crystal Reports 2011 with BEx queries as a data source.

    We would like to call detailed Crystal Report which is resides in the same BO Repository. Based on the click on selected field (GL_Account) from this main report, a new window with detail report needs to open by passing parameters like (GL_Account, Business_Area) etc.

    Please let me know if you have any suggestions for this.

    LVL 100

    Expert Comment

    Have you considered using an ONDEMAND subreport?


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    729 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