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:
313
Members:
0
Total:
313
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 19 of 34
<<
<
17
18
19
20
21
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Crystal 2008
Started By
Deleted User
Has anyone got Crystal 2008 and the Lawson OLEDB to work together
11
7982
2
by
Donna
1/14/2011 11:51 PM
LBI with Crystal Reports 2008
Started By
TracyO
I understand that Lawson is currently not supporting Crystal 2008 wiht LBI. Is anyone running that combination currently IF so have there been any issues Or does anyone one know where to find the differences between Crystal XI & Crystal 2008 We are currently on Crystal 8.5 and will be starting to install LBI in Q2, so I would like ot have my Crystal updated and ready prior to that. Thanks for any suggestion. Tracy
8
5175
3
by
Cincy
10/22/2010 12:54 PM
Override DSSO log-ins?
Started By
Nick
We have a Crystal Report with Drill-Arounds built in along with a few Smart Notifications on a manager level dashboard. However, most of the managers that access the dashboard do not have a user ID with true access to Lawson applications (they are self-service IDs for ESS). Our management is concerned with licensing issues and costs, and do not want to build individual application/authentication users, and instead want to use a generic user that has already been set-up. LBI is set-up for DSSO...
5
4415
2
by
Matthew Nye
1/21/2011 1:53 AM
Scheduled report with no data.. prevent from emailing?
Started By
Jeroen
Thanks for taking the time to read this we're pretty new at Lawson in general (pre go-live stage), and I am appointed as the 'LBI man', so far so good, but I'm facing a constant challenge: We have several Crystal Reports now, and some of them are scheduled in LRS to be delivered through email. The nag is: when there is no data on the report (either because of bursting, or because the underlying query just turns up empty) there will still be an email, containing a .pdf file with...wel...
4
3266
0
by
vishcom
11/3/2010 11:19 PM
Security Reports In Lawson
Started By
Ruma Malhotra
Is there a way to get by systemcode , the ids attached, their security class and the actions for every form in Lawson under the system code as a report. Has anyone been able to write or get a custom report and are willing to share
7
8765
3
by
Adam Goldstein
11/11/2010 8:10 PM
WAS 7 and LBI
Started By
Greg Moeller
When installing WAS 7 from scratch for LBI install, is there a need to install a separate JDK, or is the one that comes with WAS7 enough I can't seem to find out.
9
3629
1
by
Jimmy Chiu
10/25/2010 2:30 PM
Crystal and LBI Drill Around
Started By
Katfra
I have a crystal report i loaded on my dashboard in LBI. I'm trying to test it before moving into production and think i may have missed something. I want my user to be able to see the report and drill around on it. Is there something that needs to be done to allow for this function
3
3281
1
by
Greg Moeller
12/15/2010 6:15 PM
Figuring out fields that join tables
Started By
Zeke
Does a magic bullet exist for figuring out the fields that join tables together in Lawson I am familiar with the ERDs available on this site, dbdoc, and derfldrpt, but what about the actual fields that need to be related together to retrieve unique results I assume the answer is just to figure it out yourself or learn how to read the output from dbdoc better, but I wanted to make sure we weren't missing something obvious.
2
3248
0
by
mark.cook
11/8/2010 12:07 PM
There are not any Rights on File for the requested User. (LBI bursting)
Started By
Quantitalyst
Trying to get started with Bursting of an RW100. Carefully set up Elements, Structure, and Rights; but get above error. Things to note: 1) Just trying to set up with 'users', not groups or roles 2) Users are 'officers' 3) Checked off all permissions 4) Lawson KnowledgeBase Intellisenses my error, but there are no articles for it. That seems stupid Thanks, Mark
3
4819
1
by
Quantitalyst
11/16/2010 1:37 PM
LBI CRASHES
Started By
sharona
I have a Lawson LBI portal that users run crystal reports in. The only thing on that server is the LBI. intermittently the users will run a report and then the LBI doesnt work. check the server we have a VISUAL C RUNTIME ERROR VISUAL DEBUG STUDIO. We then have to reboot the server. any ideas what would be causing this, or a fix
0
3133
0
11/11/2010 1:09 PM
CR REPORT IN LBI DOES NOT STOP PROCESSING
Started By
sharona
We run CR2008 in the LBI. I have a report which is time consuming, when the user gets impatient and shuts the report down via the parameters page X in upper right hand corner or they ctrl alt del to terminate the program. our reports run from an ISERIES ACCESS ODBC DRIVER to and AS400 SYSTEM. when the report is terminated the process on the server keeps running. something isnt terminating between the ODBC and the AS400. Has anyone experienced this prior any fixes, any proper way to termina...
0
3316
0
11/11/2010 4:14 PM
LBI, Crystal & subreport
Started By
RoxanneS
Using Crystal 2008 and have a report with a subreport. When I open it up in Crystal, looks fine. I publish the report to LBI (9.0.4.0.192) and enter the parameters, then I get an error message back 'Failed to retrieve data from the database'. I tried deleting the subreport and publishing that to LBI and it works fine. Does LBI have some kind of issues with Crystal subreports The strange thing is, the users approved the report/subreport in LBI in October; so it worked then when it was pointed...
3
4588
3
by
RoxanneS
11/17/2010 8:49 PM
ClassDefNotFoundError
Started By
Greg Moeller
I am getting the following in my systemout.log file for LBI after switching the authentication source to DSSO on a new server install for LBI. webapp E com.ibm.ws.webcontainer.webapp.WebApp logError SRVE0293E: [Servlet Error]-[com/lawson/lawsec/authen/LawsonAuthentication]: java.lang.NoClassDefFoundError: com/lawson/lawsec/authen/LawsonAuthentication at com.lawson.efs.security.authenticationprovider.SSOAuthenticationProvider.getUserContext(SSOAuthenticationProvider.java:46) Anyon...
3
3523
1
by
Greg Moeller
11/18/2010 3:05 PM
Crystal Report issues
Started By
dipu
Hi all, I have a crystal report with two commands and it returns the correct data. Now I need to add one more filed to the report to show the displayed employee is a manager or not. Employee number is there in Employee table and Supervisor table. If the emoployee number is there in Supervisor.employee filed then it has to display as Yes(Manager) or No for the employee.employee in the report. Could you please help me on this
5
3017
2
by
JonA
12/28/2010 2:40 PM
OS support LBI
Started By
Greg Moeller
I know a while back, the LBI install doc used to say VM instances supported for development only. Does anyone here know if that has changed since I cannot find any reference to yes or no for VM support in production. Thanks in advance, -Greg
3
2831
0
by
Chris Martin
11/24/2010 5:47 PM
Cascading Parameters do not return all values
Started By
Carl Gifford
I have create a Activity Summary report in Crystal which goes against a large amount of data. I am trying to use dynamic cascading parameters in LBI but I am not getting all the data values for the firs parameter (Company). In Crystal reports, all the data values are displayed; however when the report is published in LBI Reporting Services, not all of the values for the first parameter are being displayed. We changed the registry setting, MaxRowsetRecords, on the LBI server to be 1,000,000...
1
4194
0
by
S Eckerson
12/15/2010 8:47 PM
Missing Data in Burst Crystal Report on Multi-RAS server.
Started By
Charlotte Chase
We have a report that returns 350K rows. The report is published as both a burst and non-burst report. For users who have wide-open bursting rights, the burst report returns an incomplete data set in our production environment, even though the bursting tree is correct and all companies and accounting units display (random detail lines for various accounts are missing, not a field we burst on). The report works fine in our test environment as both a burst and non-burst report. Our test box...
0
3407
0
11/24/2010 6:23 PM
Figuring out table joins
Started By
dukeslater
Trying to replicate Crystal report that uses Object Services but using a command object instead. Here's the ado code: dmeROD=WEBUSER.PRODLINE&FILE=PORECLINE&FIELD=DESCRIPTION;ENT-REC-QTY;ENT-REC-UOM;ITEM;MANUF-ID;MANUF-NBR;MMDIST.ACCOUNT;MMDIST.ACCT-UNIT;POLINE.ENT-UNIT-CST;POLINE.EXTENDED-AMT;POLINE.VEN-ITEM;REC-DATE;VENDOR;VENDOR.VENDOR-VNAME;VEN-ITEM;POLINE.QUANTITY&SELECT=MMDIST.ACCT-UNIT3E3D441000026MMDIST.ACCT-UNIT3C3D441999926REC-DATE3E3D012f012f08&OTM=1&OTMMAX=639&_CMDTYPE=C...
1
3551
0
by
Ruma Malhotra
11/29/2010 8:01 PM
Calculating a Time in Crystal Reports
Started By
JeanneS
How do you calculate a time when the value is stored as a number For example, I want to calculate the time difference between WHSHLDTL.UPDATE_TIME and WHSHIPLINE.UPDATE_TIME. Both fields are stored as a number. Thanks in advance!
5
4611
1
by
JeanneS
12/7/2010 6:55 PM
Dept Analysis Reporting
Started By
mark.cook
I am looking to replace an Access Database solution with LBI to provide departmental reports for Finance. I can easily replicate the income statement style reports being pulled from the database. I was wondering if anyone has a good way to add vaiance analysis back from Managers. For instance if I am 20 over budget in salaries, I want managers to respond as to why. How are others doing this process Thanks for you assistance
0
3240
1
12/6/2010 4:28 PM
Crystal GLAMOUNTS and GLTRANS
Started By
Deleted User
I'm writing a Crystal ODBC report that represents data available on GL90 (ex Co, AU, Acct, FY, Period, beg bal, posted, and ending balance). The report also shows JE detail. Has anyone had sucess writing a Crystal report with both GLAMOUNTS and GLTRANS Let me know if I can pick your brain. Did you use a main report for GLAMOUNTS and a subreport for GLTRANS My db is humoungous so I need to pass the selection parameters into the select statment. Did you write a monster SQL statement link...
6
4756
2
by
John Henley
1/3/2011 8:24 PM
Why is LBI Bursting empty Crystal Reports
Started By
David V
We have reports that are being bursted with only header information. When you open the report there is a zero record count. How do we keep them from bursting Note: The report data source is an Oracle Stored Procedure that runs for an Acct-Unit Range. The rport is then bursted by Acct-Unit. But I also include one extra record in the file that has a statistic that is used in the calculations. But the users do not have access to that record in the bursting rights. Any ideas
5
3627
2
by
JeanneS
1/10/2011 9:24 PM
Convert apdistrib_date to fiscal year and period
Started By
Deleted User
Any Gurus with a handy Crystal formula to convert an apdistrib_date to fiscal year and period
0
3582
1
1/6/2011 5:18 PM
LBI Dashboard
Started By
Donna
I just added a tab to our dashboard. I then set up specific users in the set access utility. I can see the users in set access but the user who was going to test the dashboard, contents and reports cannot see the tab. I am sure I overlooked something simple.
2
6277
0
by
Donna
1/17/2011 11:50 PM
Reporting Service for 3rd party database
Started By
wintergreen
We have reporting services on the framework. We want to be able to publish other database(not Lawson) crystal reports through LBI. Do I need to create another reporting sevices on the framework Or I can use the same one but how to separate these 2 database reports
2
2799
0
by
mark.cook
1/20/2011 12:10 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 19 of 34
<<
<
17
18
19
20
21
>
>>
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