LBI Report link in Lawson Portal

It is possible to call LBI reports from a portal bookmark, and it's how we started out with LBI. We are currently on Lawson 8.0.3, and planning to move to v9 in the fall. We have been using portal bookmarks with LRS, and it seemed logical to continue to do so when we went to LBI. However, we ran into an issue with Lawson 8 and LBI, and now we're changing to have our users log into LBI to run their reports.

The issue (I may be fuzzy on the particulars, but I think the general idea is correct) is that LBI times out after 60 minutes, but there's no time out in Lawson 8 portal. What happens is that users are merrily running reports, then within a short time after their last report was run, just a couple minutes in some cases, they get an error on the next report:

Lawson Reporting Services Error:
Error in validating session.
Additional Information: None.
Error Number: 1000

Users do not get prompted to log back into LBI. They have tried logging out of portal and closing all their browser sessions, and they still get the error. After about an hour, it goes away, and they get an LBI logon form. I think (sheer speculation) what's happening is that LBI does not see repeated report runs from portal bookmarks as an event that should reset the time out timer, and the LBI session times out. Meanwhile, the same session key is still being attached the URLs that run the report from portal. I can generate that error manually by pasting an LBI report URL in the IE's address box, and changing the sessionkey.

It occurs to me that that clearing the IE cache might help, but since we decided to send users to LBI to select their reports, I haven't tried it.

This issue does not occur if users run their reports directly from LBI.

Our LBI admin says this should not be a problem with Lawson v9 as the various components play nicely together.

I have some reports that I just wrote where the client essentially wanted a sub report within a sub report which of course is not possible with Crystal so I created a hyperlink in report A to the URL for another report. In the same manner, you could create a hyperlink to your report. I can provide you the syntax I used if you need it.

kathryn,

Just to elaborate on what Mike has already stated, as long as your LBI instance is using DSSO for authentication, this should be simple. Some things to keep in mind:

-If your LBI server is in a different domain then Portal you will get errors and possibily authentication issues
-Use the same Portal Group to assign both the bookmark and the permissions in Reporting Services so the two are never out of synch
-See Chapter 8 Scripting Reports in the RS user guide for examples of the script youll want to use to link youre report

Thanks I would love to see the syntax
Kate

Well, Im only assuming here but if you wanted to link to a report and have the data updated it would look like:

http://lbiserver/efs/FSRe...e?fsid=RS:RS-Service RS:101

You can get this syntax by creating a link in Framework Services, doing a search for your report and saving. The value in the URL text box will be the FSRemote portion then just prepend the root of EFS. In this example that is http://lbiserver/efs.

Thanks everyone. This is what finally worked. 499 is of course the report ID#

Kate

http://lbiserver/efs/FSRe...fsid=RS:RS-Reporting Services:499