Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Deliver LBI report to Email
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Raju
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5205
People Online:
Visitors:
327
Members:
0
Total:
327
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Lawson S3 Procurement
ED501 Error: Map 850 not supported by /law/c15vda/lawson/test10/edi/bin/laws_out_91
11/12/2024 3:47 PM
Tried runnning ED501 and getting the atathced erro
Lawson Smart Office
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
Infor CloudSuite
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:39 PM
Hi, I need help with an error on syteline while us
Infor ERP (Syteline)
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:24 PM
Hi, I need help with an error on syteline while us
Dealing with Lawson / Infor
Implementing Lawson v10 with Cerner Surginet, Case Cart Picking, and Quick Adds for the OR
10/29/2024 4:20 PM
Hi Everyone, I am wondering if there is any org
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1369
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Deliver LBI report to Email
Please
login
to post a reply.
4 Replies
3
Subscribed to this topic
22 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
thummel1
Veteran Member
Posts: 121
5/30/2018 6:24 PM
I am exploring various delivery options of LBI reports to customers. One option I am exploring is the ability to deliver a scheduled LBI report to an email delivery device. We currently have that functionality in place for Smart Notes; however, this is not an option for this particular need. I am wondering if similar functionality exists within Reporting Services? If yes, are there resources to learn about configuration?
We are on version 10.6.13.0.326 for reporting services.
Thank you!
NatalieD
Veteran Member
Posts: 53
5/30/2018 6:32 PM
I put a ticket in with Infor once and they provided me some steps - we don't have it set up. We were v10.6 at the time.
To create or maintain an e-mail device type:
1.) Open the Tools dashboard and select Report Administration to open the Reporting Services Administration screen.
2.) Select Server Administration > E-mail and Printer Settings to open the Delivery Administration screen.
3.) Click Device Type Tools > Manage Device Types to open the Device Types screen.
4.) If you are creating a new e-mail device, click the New E-mail button to open the New E-mail Device screen.
If you are modifying an existing e-mail device, click the name of the e-mail device that you want to edit. The Device screen appears.
5.) Enter or modify the device's parameters as follows:
Name Type the name of the device (for example, printer).
(Optional) Type a description for the device you are setting up. This description displays in the device list, only.
6.) Save
This information is also provided in the Reporting Services User/Admin Guide.
To create or maintain a network drive device type:
1. Open the Tools dashboard and select Report Administration to open the Reporting ServicesAdministration screen.
2. Select Server Administration > E-mail and Printer Settings to open the Delivery Administrationscreen.
3. Click Device Type Tools > Manage Device Types to open the Device Types screen.
4. If you are creating a new network drive device, click the New Network Drive button to open the NewNetwork Drive Device screen.
If you are modifying an existing network drive device, click the name of the network drive devicethat you want to edit. The Device screen appears.
5. Enter or modify the device's parameters as follows:
Name - Type the name of the device (for example, network drive).
Description - (Optional) Type a description for the device you are setting up. This description displays in the device list, only.
Medium - Reporting Services defaults network drive into this field. You cannot modify this field.
6. Click Save.
For it to work across the network, The Websphere Windows Service will need to be running as a named user that has access to that shared drive.
thummel1
Veteran Member
Posts: 121
5/30/2018 6:47 PM
Thank you, does the last sentence: "For it to work across the network, The Websphere Windows Service will need to be running as a named user that has access to that shared drive" apply to both set of instructions or just to create or maintain a network drive device type?
I also found these instructions, but can't seem to be able to view the user/email devices that I just set up when I am in the scheduler for the report. although I did add the email devices directly versus doing an import, so perhaps that's part of the issue...
Yes, you can set up a schedule and have the report run and be delivered from LBI . You would first need to add a delivery device for the person/email that you want it to go to. Then you create the schedule and add the user/delivery device to the report user setup in the schedule and have the schedule deliver via email to all users set within the report or schedule.
If you have access to (or can work with someone that has access to) the LBI Admin tools, you will need to add delivery devices under the reporting services delivery. To add a device that is not attached to your own user id, you will need to import the devices using the import devices function.
After you add the delivery devices, you can add the delivery device like any other user.
NatalieD
Veteran Member
Posts: 53
5/30/2018 6:53 PM
I believe it's only referring to the shared drive instructions.
Dave Curtis
Veteran Member
Posts: 136
5/30/2018 7:00 PM
There are different device setup items needed
1. Device types - you need to have at least one E-mail type setup. This is what Natalie provided "To create or maintain an e-mail device type: " . This will not actually be used to assign to a report - but it is needed to set up the actual devices themselves. For this you will need to know your email host, which you should be able to use the same setup as you have for your Smart Notes since the host should be at the reporting services server level.
2. The devices themselves.
There are two (make that three) different types of devices
A. My Devices. These are just assigned to you and they are the ONLY type you can actually add using the application directly. Anything you add within the application level directly will be assigned to you
B. User Devices. These are devices that other uses have set up for themselves. So if you have other LBI users - they can set up deliver devices that are associated with their user.
C. Delivery Devices. These are devices you can use to associate with any email address you want and then you attache the delivery device to a report or report schedule and you can send the report as an attachment to the email assigned to the device. These are very handy if you want to deliver report out to individuals that do not have access to LBI (or to vendors or external resources etc.)
C is very useful. It is also a small pain to set up since you must upload them using the Import Devices tool and you must get the upload formatted just right...
There are 5 items to build
Name
Owner
Description
Address
Device Type
You just build a csv like the following (NO headers - I just included them so you can see in what order)
Name,Owner,Address,Device Type,Description
HROPS,UMMSDD-HROPS-1,email@yahoo.com,E-mail Device Type,UMMS-HROPS
Once you upload them, then you can go into All Devices in the admin tool and maintain them. We have 100's of devices and we use them a lot.
Usually when I add a new device, I create a group and upload a bunch that I can later edit in the admin tool, that way I do not need to do an upload every time I need a new one.
Please
login
to post a reply.