Viewing Reports from Portal - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

jellis

Veteran Member

Posts: 54

3/9/2009 6:19 PM

Hi,

We use bookmarks in Portal to view reports on our old LRS server. They use a link like-

http://server.com:18001/e...te?fsid=RS:RS-Lawson LRS/LBI Server:806

Is the the fsid the SID etc? I have tried a similar link to the new LBI box and also used a link like-

http://newserver.com:9080...25&INSTANCEID=LATEST with different permutations, and still no luck.

What am I missing? I have been sifting through Lawsons KB and came across older information for the early versions of RS, but nothing for the new.

Thanks.

Ben Coonfield

Veteran Member

Posts: 146

3/9/2009 7:02 PM

To get from portal to LBI I have been using is a bookmark like http://server:9081/efs/go. But this doesn't take them to a particular report if that was your intent.

Matthew Nye

Veteran Member

Posts: 514

3/9/2009 7:34 PM

To see the proper URL string do the following:
>Create a dashboard
>Create a module with in the dashboard
>Add a Link to the module
>Do a search for a report
>Select the radio box next to any report
>Click Save

In the URL text box you will see somthing similar to FSRemote?fsid=RS:RS-Lawson LRS/LBI Server:806

You can also see the fsid from the Tools dashboard under Mange Services but its not as self explanitory as the above method.

jellis

Veteran Member

Posts: 54

3/9/2009 8:23 PM

Thanks Matthew, I go the following for a link-FSRemote?fsid=RS:RS-Reporting Services:25.
When I click to goto this link I go nowhere, and get a blank page.

Instead what I have found is the following link which works...I just change the report ID for different reports-

http://servername:9080/er...25&InstanceID=Latest

Why would your solution not work? That is much easier to deal with than my long link.

Matthew Nye

Veteran Member

Posts: 514

3/9/2009 8:27 PM

maybe because you need the full URL if you are putting it in a bookmark. Try:

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

jellis

Veteran Member

Posts: 54

3/9/2009 9:02 PM

Hmm...still a dead link. I put in http://xxx.domain.xxx:9080/efsblahblah
and it still pulls a blank.

|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/09/2009 02:37 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|RE: Viewing Reports from Portal [00005959:00006661] |
>--------------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic22966.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|---------------+---------------------------------------------------------|
|Matthew Nye |Subject: RE: Viewing Reports from Portal |
|Posted:03/09/20| |
|09 05:27 PM |maybe because you need the full URL if you are putting it|
| |in a bookmark. Try: |
| | |
| |http://lbiserver/efs/FSRe...fsid=RS:RS-Reporting |
| |Services:25. |
|---------------+---------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6661/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com

Matthew Nye

Veteran Member

Posts: 514

3/9/2009 11:53 PM

right click in the white space and select properties. What URL is it showing?

Matthew Nye

Veteran Member

Posts: 514

3/10/2009 12:14 AM

also, log directly into LBI

http://lbiserver:9080/efs

then put in that url

http://lbiserver:9080/efs...fsid=RS:RS-Reporting Services:25

Does it bring the report up?

jellis

Veteran Member

Posts: 54

3/10/2009 2:32 PM

It goes to
http://lbiserver.com:9080...aMIqBfDkQjPJrxK739mu

It appears to be missing the reporting stuff compared to the other URL that
is working used.

|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/09/2009 06:20 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|RE: Viewing Reports from Portal [00005959:00006665] |
>--------------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic20338.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|---------------+---------------------------------------------------------|
|Matthew Nye |Subject: RE: Viewing Reports from Portal |
|Posted:03/09/20| |
|09 08:53 PM |right click in the white space and select properties. |
| |What URL is it showing? |
|---------------+---------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6665/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com

jellis

Veteran Member

Posts: 54

3/10/2009 2:32 PM

Are you meaning that I should ass this link as a service or register it
within EFS?

|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/09/2009 06:20 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|RE: Viewing Reports from Portal [00005959:00006666] |
>--------------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic02054.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|----------------+--------------------------------------------------------|
|Matthew Nye |Subject: RE: Viewing Reports from Portal |
|Posted:03/09/200| |
|9 09:14 PM |also, log directly into LBI |
| | |
| |http://lbiserver:9080/efs |
| | |
| |then put in that url |
| | |
| |http://lbiserver:9080/efs...fsid=RS:RS-Reporting |
| |Services:25 |
| | |
| | |
| |Does it bring the report up? |
|----------------+--------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6666/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com

Matthew Nye

Veteran Member

Posts: 514

3/10/2009 3:15 PM

Looks like there is a problem with your Reporting Services registered service in Framework Services. I would re-register if I were you.

jellis

Veteran Member

Posts: 54

3/10/2009 3:47 PM

Alright, will give that a try a little later.

|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/10/2009 09:19 AM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|RE: Viewing Reports from Portal [00005959:00006674] |
>--------------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic16645.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|---------+---------------------------------------------------------------|
|Matthew |Subject: RE: Viewing Reports from Portal |
|Nye | |
|Posted:03|Looks like there is a problem with your Reporting Services |
|/10/2009 |registered service in Framework Services. I would re-register |
|12:15 PM |if I were you. |
|---------+---------------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6674/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com

John Henley

Posts: 3353

3/10/2009 8:32 PM

From what you're showing here, it does look like the service name isn't matching the fsid parameter...it needs to match the service name for Reporting services as defined during the install of the services into LBI/EFS.

John Henley

Posts: 3353

3/10/2009 8:36 PM

In LBI, go to Tools, then Services, then click on one of the Reporting Services icons in the dashboard.
In the 'Register Service' panel, you will see the 'Provider Id' listed for that service.

jellis

Veteran Member

Posts: 54

3/10/2009 9:02 PM

Thanks John, I went out and checked and the providerid is RS-Reporting
Services.

My exact link for the report is-
http://lbiserver.com:9080...fsid=RS:RS-Reporting Services:25.

The above link though pulls up a blank page with-
http://lbiserver.com:9080...U0A0TIzQ362pG1TfEEcE

The report is valid and does run if I use this link-

http://lbiserver.com:9080...25&InstanceID=Latest

Matthew Nye

Veteran Member

Posts: 514

3/10/2009 9:21 PM

Do the following:

>Go to Tools dashboard
>Click on the Services link under System Administration
>Click on Display XXXXX RS Report link under the XXXX RS module

What URL do you have? It should be something like:

http://lbiserver:9080/ers...eport=true&REPORTID=

If not I would recommend Removing the RS Module and re-Registering Reporting Services with FS.

John Henley

Posts: 3353

3/10/2009 9:32 PM

Well, that should work. What LBI version are you running? I tested on 9.0.2.2.

jellis

Veteran Member

Posts: 54

3/10/2009 9:48 PM

Thanks Matt. That appears to have done the trick.

jellis

Veteran Member

Posts: 54

3/10/2009 9:48 PM

Thanks to you as well John. It is working now...I am on version 9.0.3.122.

|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/10/2009 03:38 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: Viewing Reports from Portal [00005959:00006686] |
>--------------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic26289.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|---------------+---------------------------------------------------------|
|John Henley |Subject: Re: Viewing Reports from Portal |
|Posted:03/10/20| |
|09 06:32 PM |Well, that should work. What LBI version are you running?|
| |I tested on 9.0.2.2. |
|---------------+---------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6686/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com