Linking two Crystal Reports

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Nick
Veteran Member
Posts: 50
Veteran Member

    We have two reports that are currently set up as a main report (listing employees) and a subreport (a form with detailed information for a specific employee) that is linked on the EMPLOYEE.EMPLOYEE field.  The issue is that while the main report needs to be in Landscape, the subreport form needs to be Portrait.  Apparently Crystal can't handle having the two reports in different orientations.

    I am trying to instead have them as two separate reports, linked together via the EMPLOYEE.EMPLOYEE field.  I am having trouble with the hyperlink syntax, and I've tried multiple variations.  I thought that it should be:

    server:port/ers/ersRequestHandler.j...E.EMPLOYEE})

    using a Parameter 'Employee' in the second report which is passed the value of the EMPLOYEE.EMPLOYEE field on the first report.  However, it is always prompting for the parameter when I try to use the link in LBI.

    Can anyone help with the syntax (or if there is a way for Crystal to have two separate orientations)?

    Thanks - Nick

     

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      Nick,

      Youre close. Anytime you call a resource within LBI with a URL, you will almost always have to use the FSRemote servlet. This helps persist the session token as well as other meta data. Here is an example of a linked report:

      "http://server:port/efs/FSRemote?fsid=FSRemote?fsid=RS:RS-Reporting Services:123"

      You can then using the other parameters like SelFormula, SelMode, parameters and others that are documented in the Reporting Services user guide.

      hth
      Matt

      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/