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:
Saef
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5226
People Online:
Visitors:
374
Members:
0
Total:
374
Online Now:
New Topics
User Group Announcements
Carolina User Group Meeting
12/20/2024 3:15 PM
Date & Time: February 6, 2025, 8:30am - 4:00pm
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
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 S3 HR/Payroll/Benefits
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
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
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
1372
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
Forums
Performance Management
Forum:
Lawson Business Intelligence/Reporting/Crystal
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.
Search this forum:
137
Subscribed to this forum
Page 24 of 34
<<
<
22
23
24
25
26
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
How to create unapplied cash report for Lawson M3 database
Started By
Naresh
i have experience with crystal but not with M3 database. I have LBI, M3 database(Oracle) and crystal. I also have smart office client installed to access M3 and its programs. User wants to see the Unapplied cash report of customers which doesn't include deposits by the customers. What tables, fields, and conditions i should use to get this report Any help would be appreciated... And , I have been reading lot about Lawson Apllication reports and Lawson Back office reports what are these...
3
4911
1
by
Rob Conrad
1/8/2010 7:18 AM
Tools to monitor LBI health
Started By
Xin Li
Anybody out there ever implement any tools to montior LBI health We had some issues at one point scheduled reports did not run due to LBI failed to connect to backend SQL Server database. It would be nice to catch this kind of error before my users do.
2
3304
0
by
Kirk Compton
1/4/2010 12:31 PM
LBI rollout to Power Designers
Started By
mark.cook
We are in the process of completing our LBI dev server with the intent of allowing a small group of power designers to build reports, SN, Dashboards in DEV. If you have rolled this out to a group like this, other than a standard promotion process, what are the big gotcha's that you can share.
1
3129
1
by
Milo Tsukroff
1/26/2010 3:33 PM
Drop Menu options
Started By
ram32bo
Can the drop menu on the top right hand corner that enables users to 'Refresh' or 'Log Out 'UserID'' be changed Is it possible to remove the 'Log Out' function from this menu I don't know why, but when a user attempts to log out from there, nothing happens. I need to figure out a way to either make this work or remove the option. Please advise.
2
3085
0
by
Arvin Ojales
1/6/2010 3:02 PM
LBI Monitoring
Started By
Jan
HI - this question kind of piggy-backs on the recent LBI monitoring question. I publish a series of Lawson Back Office reports that I burst at view time on company/cost center. Most users have rights to a single company/cost center - but a handful have rights to all company/cost centers. When these users try to view the report, the bursting success is sporadic. This Monday, we attempted to view one of these reports (with the user who can view all company/cost centers). When the user attempt...
11
3829
3
by
Chris Martin
1/5/2010 7:31 PM
How to schedule crystal reports in LBI?
Started By
Ada
Hi, I'm having problem with my scheduling. Have no instance on server whatsoever. My crystal report contains subreports. In crystal designer, I can preview the report including both main report and subreport content. I can also view the latest instance or with data refresh after report published.But when I create a schedule with parameter value assigned and bursting option structure defined. There isn't any instance bursted on my server. Did I missing anything when schedule Any ideas Than...
3
3418
1
by
Ruma Malhotra
1/7/2010 10:05 PM
LBI and device import
Started By
Greg Moeller
Say, does anyone have any (recent) experience uploading/importing devices to LBI reporting services The reason I ask, is that I'm trying to conform my csv file to what we initially uploaded years ago, and it won't import. Have the file specs now changed We are on LBI v 9.0.3.2.116 and originally when the files I have were successfully uploaded we were on maybe v 8.0.1 Lawson's documentation leaves a little to be desired in this subject. Any help would be appreciated, -Greg
2
4611
1
by
Greg Moeller
1/26/2010 5:56 PM
Error on Published Crystal Report
Started By
BradF
I was wondering if anyone has run into the below error. The person is using the URL from a published report. Thanks, Brad Error Failed to retrieve data from ...
6
3614
0
by
BradF
2/1/2010 8:53 PM
I want to install my own Crystal server on top of LBI
Started By
Mike Schlenk
We're currently using LBI for Lawson report distribution only (e-broadcasting replacement). We did not buy enterprise reporting or any Crystal from Lawson. I have non-Lawson needs for Crystal server. I'd like to install it in a way that LBI still knows it's there and can publish an rpt. This is an effort to provide one reporting portal (use LBI) for Lawson and non-Lawson reports. Has anyone done this Lawson is very 'stand-offish' unless we buy the whole reporting suite. It doesn't seem t...
8
3017
2
by
Char
1/13/2010 7:59 PM
Crystal 2008 and Oracle Stored Procedures performance.
Started By
Charlotte Chase
Crystal 2008 and Oracle Stored Procedures performance. I am benchmarking a report that uses the native Oracle driver and an Oracle stored procedure with a ref_cursor on a Crystal 2008 report. The performance is horrible when compared to using a SQL command directly in the report. Anyone have experience with this Is there a way to use a bulk collect rather than the ref_cursor to improve performance
2
2987
0
by
Charlotte Chase
1/13/2010 7:57 PM
Scorecard
Started By
jellis
Hi All, I have had LBI 9.0.3.2 implemented for awhile now and need to finish up with Scorecard. I have installed the application, setup analysis services and the data loader, but I am either not understanding or not finding Cubebuilder v9.x or is this functionality located in IA150 Any pointers would be much appreciated. James
1
3648
1
by
Ruma Malhotra
1/12/2010 9:18 PM
Upgrade From 9.0.3.1 to 9.0.4 LBI Issue
Started By
Ruma Malhotra
We upgraded just recently on one of our test system from LBI 9031 to 904 and found that framework services did not keep the permissions for each of the dashboards and modules after the upgrade. Has anybody run into this issue What was your solution
4
3430
0
by
Ruma Malhotra
1/26/2010 6:12 PM
LBI report information in a report
Started By
Greg Moeller
All: I have been tasked with creating a report containing the LBI report number, LBI Report name, LBI report owner, LBI report schedule, and LBI Report Users. I can pull the first three out of the ERS_REPORT table, but where would I find the schedule and report users Thinking a Y/N flag would suffice for the schedule, but the users may want Weekly, Daily, time it runs, etc. The report users- Where do I go for those, and how do I link the tables appropriately Thanks for any help given,...
4
3669
2
by
Greg Moeller
1/26/2010 8:36 PM
Module Colors in a single dashboard
Started By
Ruma Malhotra
We have one dashboard that is being shared by 2 different responsible parties. They would like all of their reports on the same dashboard but want to visually differentaite one module from another with the use of different module colors. When you choose modules and edit dashboard there is a dropdown for the color and this color applies to all of the modules within that dashboard. But how can I change 2 modules to be of 2 different colors on the same dashboard has anyone been able to acheive th...
1
2622
0
by
Chris Martin
1/27/2010 3:51 PM
Scheduling Crystal outside of LBI
Started By
Joe O'Toole
Due to limitations with the LBI scheduler we're looking for an alternative. We need the ability to run a given Crystal report with multiple parameters and publish pdf output to a static location. It could either be one large reprt that is bursted or multiple invocations as long as the end result has each report going to it's desired location on disk. Is anyone scheduling their reports outside of LBI with a product that can do this I've heard this functionality may exist in Business Objects Ente...
1
2832
0
by
Char
1/28/2010 4:19 PM
Scheduled Reports and Report Filters
Started By
Charlotte Chase
Is there any way to have a dynamic Report Filter on a scheduled report, i.e. such that the scheduled report runs for a large dataset, but the user is prompted to supply an additional record filter parameter It looks like the schedule requires a value to be supplied for the record filter, as well as the Crystal parameters. I'm trying to avoid having to create more complex bursting rights for some of our scheduled reports/or publish a million different iterations of the same report. Thx!
2
2714
2
by
mark.cook
2/2/2010 12:45 AM
AR Payment Tracking
Started By
Ruth
I am developing a crystal report that recognizes income when the funds are received. We have AR payments that we received and applied. How can I track each of these payments down to the individual invoice distribution lines they have paid
0
3782
2
1/29/2010 9:12 PM
Portal report as Data Source for LBI Crystal report
Started By
Illvatar
We have some users who have access to LBI but not to Portal, so we have several Portal reports that we read into Crystal and output in LBI, usually in Excel format. One report that I am trying to do this with is the Payment Voucher Interface Error Report (YP520). This report has two logical sections to is, depending on the types of errors encountered. The report populates 0, 1, or both sections, depending on the errors encountered, if any. My problem is that I need to be able to report this ...
4
2956
1
by
Illvatar
2/5/2010 7:27 PM
Scorecard Combine/Totals
Started By
mark.cook
I am fairly new to scorecard. I have a Employee Turnover data cube that I produce views for Managers. I have a request to combine several AU's turnover and get a total. These AU's don't have any other combination (manager, au heirarchy, etc) that I can use the select all to get a grand total. Basically I am trying to combine these AU's turnover on 1 view in scorecard and get a grand total. It seems like this is an easy fix just need some direction. Thank you
0
3370
0
2/4/2010 5:55 PM
Linking GLTrans table with APDISTRIB
Started By
JL Cabrera
Can anyone help me with the relationship between the gltrans table and the apdistrib I need to join both tables for reporting purposes. Thanks in advance for the help.
2
4475
1
by
John Costa
2/5/2010 1:13 PM
Pass parameters into LBI report
Started By
Deleted User
I wanted to see if it's possible to pass parameters from a lawson screen into an LBI report Users would like the PO Print report integrated into the PO20 screen in Lawson. I was thinking that I could write a script with Design Studio and get the PO Number, Revision, etc off the screen and pass them into the LBI report, and open the report in a seperate window. Does anyone know if this is possible I'm not that familiar with LBI but have done something similar with Oracle reports.
0
3876
0
2/19/2010 3:13 AM
LBI Dashboard and Smart Office
Started By
North1
Has anyone run LBI Dasboards from SmartOffice
0
3416
1
2/23/2010 2:28 PM
Reporting LBI Statistics
Started By
jellis
Hi, I am looking for some thoughts or input on tracking user info in LBI. Specifically I am looking for a way to keep track of userid, IP, and report ran information from users who go out to LBI from Portal or come straight into LBI. SSO is enabled and LBI is version 9.0.3.2.116/117. Thanks, James
3
4005
1
by
Matthew Nye
2/25/2010 1:41 AM
Smart Notes install.
Started By
Deleted User
I would like to move our development Smart Notes install to another server and during the install I have gotten the following error. Has anyone seen this type of error before I googled it and it seems like I am pulling in two different defitions for the Formatter. JSPG0049E: /admin/installvalidator.jsp failed to compile : JSPG0091E: An error occurred at line: 894 in the file: /admin/installvalidator.jsp JSPG0093E: Generated servlet error from file: /admin/installvalidator.jsp d:\IBM\We...
5
4503
2
by
Deleted User
2/26/2010 2:11 PM
Crystal Report for Actual vs. Budget by Quarter
Started By
JeanneS
I have created a crystal report for actual vs. budget using an union command with the FBDETAIL and GLAMOUNTS tables. I am able to calculate the quarter totals for both actual and budgets by Accounting Unit. The quarter totals are listed on the same line. I want to combine all of the quarters into one amount column by quarter with seperate columns for the actual and budget so I can create a graph by quarter showing both actual and budget. Any suggestions on how to do this
0
4196
1
3/5/2010 12:08 AM
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 24 of 34
<<
<
22
23
24
25
26
>
>>
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 Office
--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 (PSA/SA)
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operations
--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/Reporting/Crystal
Smart Notification
--Lawson M3 Business Performance Warehouse
--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
14
RE: SQL Help
by
Greg Moeller
11/9/2023 2:49 PM