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:
181
Members:
0
Total:
181
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 23 of 34
<<
<
21
22
23
24
25
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Report Access and Users that have left the organization
Started By
Ruma Malhotra
There are a number of reports published on LBI that have indiviual user-ids attached to the report when the report is published on reporting services.We are on version 9.0.3.1.Some of these users have left the organization and we have setup synchronization to be done every morning with the option of Remove Expired Users and Roles checked. What I am finding out is that this removes the users and roles for each report on the dashboard link but not when the report is originally published on repor...
4
2679
0
by
Ruma Malhotra
3/10/2010 3:21 PM
Exporting and importing Rights From Rights management
Started By
Ruma Malhotra
We are getting ready to do a setup of all rights in the production environment on our several testing environments to start various testing. In order for me to accomplish this I am planning to do an export or dump of all rights from production create a csv and then import it into the testing environments. in the reporting services manauals there are procesdures that explain the importing peice and the csv file that contains the rights but no information on how to extract all the rights from...
4
3203
2
by
Ruma Malhotra
3/10/2010 3:15 PM
LBI – Report usage tracking
Started By
Thomas Varughese
Can anyone suggest how to write reports on Reports usage tracking We have several reports published to LBI and would like to know who and when the reports were run…. Since LBI don’t store the user-id and the run date as variables, we are not able to update these to a table….Did any one of you ventured into this situation Thanks, Thomas.
3
4561
1
by
Matthew Nye
3/6/2010 3:25 AM
Smart Notes Install
Started By
Deleted User
I did get version 9.0.4 from Lawson. I am attempting to do a new install on Websphere 6.1. This is so we can get ride of an older server etc. The latest issue on the install is that I can get the installvalidator.jsp to work however in loging in I am getting this error: JSPG0036E: Failed to find resource /lsn/SmartNotifications.jsp
4
3089
1
by
Matthew Nye
3/8/2010 4:36 PM
Income Statement Account subtotal group table???
Started By
Gary
I need to create a report based on the GL293 Income Statement that is based on AC Activities rather GL Accounting Units. The GL293 subtotals Accounts by Income Statement groups/classes (i.e. Gross Sales, Net Sales, COGS, Gross Profit, etc.). Can anyone help me with what table has Income Statement Account subtotal types for this report THANKS!!!!!!
3
3842
0
by
Char
3/10/2010 3:29 PM
LBI data source related error
Started By
Gus Chan
I am new to LBI, and I am getting an LBI Data Source Related error in the sales tab. The error is ' Query (1, 31) The 'HIERARCHY' function cannot accept a null member as the argument.' Somebody please help. Thanks
9
3913
1
by
Gus Chan
3/5/2010 6:11 PM
Adam and LBI
Started By
Ruma Malhotra
We have created users in the sec admin tool that have been added to LBI. While using the synchronize tool on LBI I get an error which basically is asking us to increase the page size on ADAM. However when we do this we running into this error: ldap policy: show values *** Error: ldap_search of ldapAdminLimits failed with 0x20(32 (No Such Object). Ldap extended error message is 0000208D: NameErr: DSID-031521D2, problem 2001 (N O_OBJECT), data 0, best match of: 'CN=Configuration,CN={1EB8...
2
7076
0
by
Ruma Malhotra
3/10/2010 3:13 PM
Problem Publishing GL291
Started By
dcaiani
I had a request to publish GL291 (Trial Balance) onto an LBI dashboard. So when I went through the publishing steps, I selected back office reports, the product line, the job name, etc. I published the report and ran it a second time. When I try to view the report its shows up as a blank screen. Has anyone published a GL291 or other non-rw100 back office report Any suggestions, tips, pointers
7
3967
2
by
dcaiani
3/30/2010 3:46 PM
WinHttpRequest Error
Started By
David Williams
When trying to connect to Lawson as the datasource in a Crystal report using Lawson OLE-DB connector we're getting an error. ADO Error Code: 0x800072ee7 WinHttp.WinHttpRequest Server name or address could not be found. I thought I've seen this before but can't remember the fix to it.
5
5006
1
by
David Williams
3/10/2010 1:21 AM
Crystal Rounding Issue
Started By
David V
Sorry if this is dumb question. I have a report that captures the total of a group of accounts, It then groups the accounts together and reports the total. I am suppressing the decimals when showing the totals. When I display the Grand Total, the totals do not equal the previous Displayed totals. It shows the summary total which is different because of rounding. Any ideas how to get around this Example: Capturing Account totals for 500000 - 599999. Account 500000 - 503999 = 100.4 Displ...
11
3158
2
by
Chris Martin
3/11/2010 3:08 PM
OnDemand linked subreport in Crystal question
Started By
Jan
I have a design dilemma with my Crystal report. I have two subreports that I've put onto the detail line as on-demand reports. I like the way this looks but since the on-demand report doesn't run in LBI until the user clicks on the link, they are asked to enter their odbc userid/password to call the data up. Is there anyway to include this subreport as an on-demand item on the detail, but get around forcing the user to enter a userid/password
12
3783
2
by
Jan
3/16/2010 7:50 PM
Smart Notes/Frame Work Services Authentication
Started By
Deleted User
I started with just wanting to install Smart Notes but found out that in the newer addition of Smart Notes Framework service is now required. In looking through how to setup authentication in Framework services and I ran across this. '..DSSO is only required on application servers that do not run the Lawson Environment. For example, if you run LBI under the same WebSphere application server instance as the Lawson Environment and applications, you do not install DSSO. Instead, in the LBI you se...
8
3598
3
by
Deleted User
3/16/2010 7:26 PM
Reporting Service Upgrade from 9.0.1.10.154 to 9.0.2..0.464
Started By
Deleted User
I recently upgrade the LBI in my test environment from 9.0.1.10.154 to 9.0.2.0.464. Everything seems fine except when doing the Reporting Serivce upgrade. The old JNDI name for 9.0.1.10.154 was set to jdbc/LawsonRS901 and new JNDI was set to jdbc/LawsonRS. In Step 3 of the Reporting Service validation, I clicked the upgrade, and get the following error message: The proces of configurating the Reporing Services system settings was successful, but the process of upgrading the 9.0.2 instance from...
3
2992
0
by
Chris Martin
3/17/2010 2:37 PM
Crystal Group Tree Nbr Format
Started By
David V
On my crystal report Group Tree the Company number is 1000, but when I publish it in LBI the format changes to 1,000.
2
2679
0
by
John Henley
3/16/2010 7:08 PM
Crystal Formula Report
Started By
David V
Is there a way to print a list of the formula that you are using in your report. I need to show a user a list of my formulas as well as the formula itself. Thanks, David
2
2734
1
by
David V
3/19/2010 3:36 PM
New to Crystal
Started By
Katfra
Hello, I have some very basic questions so please bear with me. I had crystal training for Lawson in March of last year and after returning, I had learned a lot but my company was going through some changes which required me to direct my attention to other pressing issues. So, basically i have forgotten the core of what i need to know. First, I'm using Crystal Reports XI along with Lawson Query Builder. We discussed Lawson query builder breifly on the last day of training and so i'm not s...
4
3833
1
by
Katfra
3/31/2010 12:17 PM
Crystal to Object Services Association
Started By
dukeslater
My boss delivered a working Crystal report (created with v.10), and I can refresh it fine using the 4.1.14 version of Object Services (I don't know why we can't use the current version, but I know it doesn't work in our environment). On the boss's pc, whenyou right click on the command object in Crystal and select 'Edit Command', the query opens in the Object Services query builder. However, when I do the same on my pc (using v.11 of Crystal) it just opens the standard Crystal text box where t...
3
2739
1
by
Chris Martin
3/22/2010 4:06 PM
SmartNotes Outlook Appointments
Started By
Deleted User
Is there any way in Smart Notes to send Outlook appointments
1
2732
0
by
Matthew Nye
3/27/2010 2:50 AM
Multiple ODBC data sources on LBI server
Started By
Nick
I might be being a little naive, but can multiple ODBC datasource DNSs be loaded on the LBI server for Crystal We have four product lines, each set-up to accept ODBC (I can run reports from the designer) and would like to be able to run them through LBI as well. Nick
3
5453
2
by
mikeP
3/31/2010 1:04 PM
Group Tree - Hide Field
Started By
David V
I have an income statement type of report that runs by dept. But I have to use a stat from a different dept to do calculations. I am able to hide the values on the report, but it still shows up in the group tree. Is there a way to remove it or hide the value
2
2728
1
by
David V
4/13/2010 4:59 PM
Crystal Report Issue
Started By
JeanneS
I have a crystal report that uses an union query to pull the actual and budget amounts from the GLAMOUNTS and FBDETAIL. The query lists the amounts all on the same row as shown below (12 debit fields and 12 credit fields). FY AU Account debitperiod1 creditperiod1 debitperiod2 creditperiod2 debitperiod3 etc. I want to list my data as shown below where the net amount is the total of the debit and credit for each period and the period is 1, 2, 3 etc: FY AU Account Net Amount Period ...
6
3251
0
by
JeanneS
4/11/2010 12:14 AM
Copy to Test ???
Started By
Ken Carley
Okay, so we have been up and running on LBI for a little while now and things seem stable. Of course we don't want to just leave it that way, so we are looking into what needs to be done to make a Copy of PROD in TEST. We started looking at creating the backoffice jobs and republishing all the Crystal reports too and that just seems silly. Does anyone have a repeatable process that we should follow or did I miss something in the Lawson knowledgebase.. Thanks for your help/time, Ken
3
3096
1
by
Matthew Nye
4/14/2010 3:21 PM
MSCM signatures on report
Started By
mark.cook
I have a request for data from MSCM to show deliveries, show it was delivered to and also the signatures that were captured. I can gather all the needed data, I see the bitmap field for the signature but want to convert that to the signature to show on a report. Has anyone done this that can share some thoughts on how to code this
0
3445
0
4/14/2010 3:24 PM
Capture User ID
Started By
David V
Is there a way to capture the user name and display it on the report And does anyone know how to capture rules info for a user. So I need a report that lists the current user and the rules that exist for that user. Example: Current User - ABC Rule - Company Values - 1,2,3,4
4
3581
1
by
Jimmy Chiu
4/21/2010 4:18 AM
Crystal Report Issue
Started By
dipu
I have created a crystal report with two oledb commands. After refreshing the report lot of duplicate data is coming. How can I remove those duplicate data from the report please help.When used these commands in seperate reports I got correct data without duplicates. The join I have taken is left outer join.
2
2684
1
by
Matthew Nye
4/23/2010 6:12 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 23 of 34
<<
<
21
22
23
24
25
>
>>
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