Creation of link form one report to other report in LBI

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)

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.