Creation of link form one report to other report in LBI

Sort:
You are not authorized to post a reply.
Author
Messages
Naresh
Basic Member
Posts: 7
Basic Member
    hello All,

    I have two crystal reports published in LBI. One is summary level report another is detail level report. Client is asking for link from summary level report to detail level report.
    I made attempts to use options 'Report part drill down' and 'Another report object' in Hyperlinks tab of formt editor in crystal reports 2008 and not succeeded.

    Any help would be appreciated.

    Char
    Veteran Member
    Posts: 62
    Veteran Member
      This is one of my links: "https://lbi.insertyourownservername/efs/FSRemote?fsid=RS:RS-Reporting Services:80&Dobeforeevent=false&Year=" & cstr({?Year},0,'')& "&Month=" & cstr({?Month},0)
      mikeP
      Veteran Member
      Posts: 151
      Veteran Member
        Here's what I found works on our LBI server. This example has two reports, similar to what you’ve described. RPTA is a list of employees, its parameter is a last name or portion thereof, so if the user entered a parm value of “JOHNS”, it would list all emps with last names beginning with those letters. Each name listed on the report is a hyperlink that calls the detail report RPTB.

        The hyperlink passes the employee number of the employee whose name was clicked to RPTB.

        It also passes the report ID of the RPTA, so a link can be created on RPTB that lets the user return to RPTA. This is only needed if RPTB can be called from more than one report.

        Finally, it passes the parm value from RPTA, e.g. “JOHNS”. When the user clicks the link on RPTB to return to RPTA, that parm value is passed back to RPTA, so that when it refreshes, it will display the same list (names beginning with JOHNS) that was displayed when the user originally clicked the link that took them to RPTB. Hope that makes sense.

        First, create a formula with the server particulars. Our provider tends to change servers on us from time to time, and if there is more that on one link on a report, you only need to change the formula:
        formula="http://your.server.name:port#/efs/FSRemote?fsid=RS:RS-LBILERS:"

        For the hyperlink, the hyperlink type is: A Website on the Internet

        I use formulas for the link for readability, e.g.:


        ' Call RPTB passing employee number
        formula={@ServerName} & "59&Dobeforeevent=false" & _
        "&_E=" & cstr({Command.EMPLOYEE},"#") & _
        "&_S=" & {?_S} & _
        "&_R=" & {?_R}

        In this example:
        @servername is the formula above

        "59" is the report ID from LBI. Haven't found a way to use the actual report file, which would be a lot nicer; if the report is ever published from scratch it will get a new ID. This happened when we moved to a new LBI server, all our reports had to be published again (for the first time) and got all new IDs. If anyone knows if this is possible, I’d love to know how.

        _E , _S, and _R are parameter names /value pairs such as you’d normally see on a hyperlink

        _E: is the employee number, filter criteria for the called RPTB
        _S: search criteria from RPTA, e.g. “JOHNS”
        _R: the LBI report ID for RPTA, so a hyperlink can be created ob RPTB that returns to RPTA.


        The reason for the cryptically short parm names (_E, _S, _R) in the hyperlink is that I found that CR, or more likely LRS, which we used when these reports were written, truncated the hyperlink, so that the practical limit is the server, port, and virtual directory names, plus about 80 chars worth of parameters, which includes both parameter names and values. The only work around I found was to use very short parameter names. I have not gone back and tested this since we started with LBI.
        You are not authorized to post a reply.