Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
218
Members:
0
Total:
218
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
Performance Management
Forum:
Lawson Business Intelligence/Reporting/Crystal
Search this forum:
136 Subscribed to this forum
Page 8 of 34
<<
<
6
7
8
9
10
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
URL/link to AP150 Output
Started by
Bill Corriveau
Anyone have a way to add a URL/link or button to Lawson report output&160;We are looking to provide the ability for payment reviewers to run AP150 in non-update and then view the actual&160;invoice images from our images server, while looking through the AP150 output online. Does it require generating the report in a different output format in order for a URL to work The standard text outputs allow for drill around, but we're trying to figure out how to do something similar only point to a U...
3
4261
1
by
Giulia
6/23/2014 5:58 PM
Table for Report Schedule Names
Started by
clb393
&91;IMAGE:651&93; Hello! I would like to know what table in LBI i can query that lists Report Schedule Names. Please see above for a screen print of what i am referring to. Thanks, Chris
16
4752
3
by
Greg Moeller
7/2/2014 2:16 PM
Name Change Report
Started by
thummel1
Does anyone have a Crystal report that is designed to show an employees 'Old' name, and 'New' name, side by side My goal is to be able to design the report so I can see my current last name and in another column, my prior last name. I already have a report that shows old name and new name, but old name is in a group and new name is in it's own group. Would love if you are willing to share the SQL of a report designed this way. Thank you!
8
3519
0
by
thummel1
7/23/2014 6:57 PM
Infor Lawson BI - Add new dashboard
Started by
Robby
Am I missing something in this new setup Infor Lawson BI 10.2.0.0.126 This is a new setup and the install included quickstart items, Now, I have to add a new dashboard and I can't find the little icon that is supposed to be to the right of all the dashboard tabs. Is there something I'm missing in this new setup or do you think there is a security setting that has been missed which is hiding this from me I have 'LBIAdmin' authority... Help! Robby.........
9
6345
1
by
Greg Moeller
5/9/2014 5:25 PM
Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?
Started by
mlarson
I'm trying to figure out how to link the data in the ENBATREE table of the EFS schema to the report data found in the ERS schema via a SQL query. After analyzing the database tables I have not seen anything from the EFS schema that can be linked to the REPORTID field which is used by the majority of the tables in the ERS schema. Any help would be appreciated, thanks!
8
4039
2
by
JeffCozzag
5/15/2014 8:20 PM
Report Not Bursting As Expected
Started by
Elizabeth Ardito
I have been using LBI to published back office reports for years. We recently purchased the full version and I am attempting to setup and burst a crystal report with department data and vice president summaries (the summaries are subreports). We are on LBI version 9.0.4.2. The problem is, it seems to burst almost correctly. I only have access to the departments I am assigned to in the maintain rights but I have access to the vice president summaries who are responsible for the departments....
1
3277
1
by
thummel1
7/23/2014 11:07 AM
Convert LBI Reports to Business Objects
Started by
Donna
We have LBI, BOE and an assortment of other distribution tools for our organization. We would like to consolidate to one distribution tool. Currently we use LBI for Lawson Reporting and BOE for EPIC. We are considering using BOE for Lawson, EPIC/ Clarity, Midas and Kronos reporting. However, we have over 600 reports published in LBI and would like to make contact with other Lawson users who are using BOE for Lawson Reports to discuss their satisfaction level with BOE. Thank you. Donna...
3
3666
2
by
Donna
5/12/2014 9:04 PM
Emailing LBI reports
Started by
Law123
We are converting from Crystal Enterprise to LBI for reporting. Crystal Enterprise allows reports to be emailed to an outlook distribution group (i.e. Accounting). This reduces report maintenance because I don't have to do anything when new accounting personnel are hired. The outlook groups are maintained by others. Can LBI reports be emailed to an outlook group If so, how I've assigned email addresses to individual users, but I don't know how to get LBI to email to an outlook group. ...
10
4564
1
by
Greg Moeller
5/15/2014 2:04 PM
Printing multiple parameter descriiption value fields
Started by
Donna
I have a formula that will print the values in my parameter that accepts multiple parameter values. My user would like to see the parameter descripton field instead. Does anyone have a suggestion for accessing the parameter description value field Thank you. Donna
2
2811
0
by
Donna
5/12/2014 8:58 PM
Upgrade to RAS 2011
Started by
Greg Moeller
So, the other evening we upgraded our production LBI Reporting Services instance to 10.3.1.0.68. The next morning we had some issues with specifically parameter containing drillable reports. I opened a call with Infor and was basically told that this was a known issue with SAP, and we (Infor) are waiting for the next SP to see if that will fix the issue(s). Has anyone else took the leap yet to RAS 2011 Are you experiencing the same symptoms I find it hard to believe that we are the only...
1
3074
0
by
Greg Moeller
5/15/2014 2:02 PM
Listing the bursting rights by user
Started by
Donna
I can create a number of reports from Lawson FS and RS but I can't find a table that has the rights for a user. Does a table that has this information exist Example User Department Rights Me 1000 2000 3000
3
3103
0
by
Donna
5/23/2014 7:13 PM
LBI Pricing
Started by
Ruma Malhotra
Our organization is planning to buy LBI and before we take the leap forward wanted to find out some information about pricing. Is anyone out there who has recently bought LBI and is willing to share the prices quoted by Infor. I want to compare prices and was looking for any users on LBI who are looking to buy or who have recently purchased itn and are willing to share the price quotes. Thanks in advance, Ruma
0
3285
1
6/3/2014 12:51 PM
Crystal Reports Will Not Refresh in Report Services
Started by
Jordan
(
1
2
)
I've been asked to get reports and documents setup on an existing dashboard for our supply chain team. I don't have a true IT background and am essentially wondering if I need to get our Lawson IT group involved in this problem. I have reports created in Crystal and they refresh with no problem in there. I've published them to the reporting services but when I click to either View Latest Instance or View with Data Refresh, I get the following error: Error Failed to open the connection. F...
27
6842
1
by
redanker
7/24/2014 1:44 PM
LBI Report Owner change
Started by
Mary Porter
Is there a way to do a mass update for LBI report ownership change I only found an article on mass updates for Smart Notifications.
4
3451
0
by
Mary Porter
6/20/2014 5:08 PM
Incorporate GL Data in the MM280
Started by
Whitney Johnson
Is there a way to incorporate GL in the Department Expense Distribution Report so that it ties back to the Operating Expense Currently we are having to run two reports to provide this information. The MM280 and GL290 for the account needed. This report would have all the same field headings as the current MM280 report, but include entity, department, and whether the transaction was an accrual or not. Also, the main difference being year to date instead of just that month.
0
3156
0
6/19/2014 1:11 PM
LBI report returns to Crystal parameter page
Started by
Adam K
I am having some issues with a few reports using url's to access subreports. The reports have a URL link to sub report. When the sub report is closed the crystal parameter page opens instead of going back to the base report. I am on LBI 9.0.4.2 and CRAS 12. Has anyone seen this behavior before And did you find a workaround or solution Lawson was unable to replicate the issue.
1
3039
0
by
mikeP
7/15/2014 5:06 PM
Bursting LBI report that has 5 subreports
Started by
thummel1
Has anyone been successful in bursting an LBI report that contains subreports I have isolated the issue to when I add the bursting feature to the scheduled LBI report, I receive a prompt to enter the UserID and Password. I know this issue is isolated to bursting because when I shut the bursting off, the report opens just fine. The field the report is burst on (the manager's User ID) is in the 'main' report. I reviewed this report with Lawson support yesterday and they suggested I add the User I...
0
3401
0
7/23/2014 11:27 AM
Export report & append date to filename?
Started by
Jimmy Chiu
Is there a way to export a report with a filename.date format Where the date is grabbed from the system time
0
3654
0
8/1/2014 2:02 PM
Date Stamp in PERSACTION table
Started by
thummel1
Hi, I'm wondering what would be the equaivalent to the Date Stampof PA Actions in the PERSACTION table There are several date fields in there but none of them seem to reference the date that the transaction was entered. Logically, it seems that there would be one data field that contained the same date (since we run a PA100 on a nightly basis), but all the date field have a variety of dates or no date. Does this data field exist
5
3660
0
by
Matt
8/15/2014 2:24 PM
LBI - Schedule a report with a parameter
Started by
thummel1
Hi, Is it possible to schedule an LBI report that requires the end-user to enter a parameter My objective is to allow a manager to view only the records he or she needs to see by entering their User ID as the parameter to view their data on the report. This needs to be scheduled in LBI because we cannot bump up against Production. Furthermore, bursting this report by manager (which was my first approach) is not working for reasons that Lawson Support hasn't been able to diagnose yet. (The ...
13
4702
1
by
Randy
8/14/2014 1:13 PM
Scheduling limitations
Started by
thummel1
Hi, We have many LBI reports that are scheduled. Is it possible to limit the number of saved instances in the HISTORY section of the LBI report For example, Customer A want an LBI report scheduled to run every Monday. They only want to have the last 6 scheduled reports saved. Is there a way to 'purge' reports older than this without going in and manually deleting them I ask because an issue recently came up where server space is almost at max capacity and the thought is that these save...
3
3090
0
by
Matthew Nye
8/20/2014 5:14 PM
LT101 Supervisor Errors to LBI missing data
Started by
clb393
Hello! We have the LT101 Supervisor Errors report upload to Crystal via OLEDB connection. The report runs fine in portal but in LBI it does not include those errors where the supervisor field is missing. Is this a case of missing XML tags If so how would i get the tags added Thanks for your help, Chris
0
3567
0
8/21/2014 7:04 PM
Crystal Reports and OLEDB
Started by
Layne
We have had numerous occasions when Crystal Reports inside LRS have all of a sudden started prompting for an OLEDB username and password. We can input the porper username and password into the report and it will work just fine for that one time, but will keeep asking for the username and password each and every time that it's run. We even had some report instances that were run overnight in our history today that would prompt for the OLEDB username and pasword. Does anyone know how LRS uses th...
2
3488
0
by
mikeP
8/22/2014 7:09 PM
LBI RS table where report runtime is stored
Started by
Jey
Hi, We are using LBI version 10.3 and I am looking for RS table where the report runtime is stored.
1
3339
0
by
Greg Moeller
8/30/2014 2:11 PM
LBI and Dynamic Parameters
Started by
thummel1
Hi, I am using Crystal reports 2008. My Crystal report has 3 dynamic parameters. This allows the end user to select 3 separate critera (Job Class, Payroll Year, and Provider Comp Plan). In Crystal, the end-user can choose one or many job classes, one or many years, and one or of many Provider Comp Plans. When I publish this report to LBI, my parameters do not display the 'left' 'right' boxes that allow you move data from the left to the right that you want to include. My question is, why are...
5
4928
0
by
thummel1
9/9/2014 3:45 PM
To join the discussion you need to
register
first. (Registration is free!) If you are already a registered user please
login
to join the discussion.
Page 8 of 34
<<
<
6
7
8
9
10
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
----S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
----Lawson Design Studio
--Lawson Smart Office
----Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft O...
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PS...
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operat...
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/R...
----Smart Notification
--Lawson M3 Business Performance...
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support
Forums
Performance Management
Group: Performance Management
Forums
Topics
Replies
Subscribers
Last Post
Smart Notification
189
635
71
RE: SQL Help
by
Greg Moeller
11/9/2023 2:49 PM