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:
Wayne
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5121
People Online:
Visitors:
330
Members:
0
Total:
330
Online Now:
New Topics
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
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
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
1354
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 33 of 34
<<
<
30
31
32
33
34
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Repository Database
Started by
Deleted User
Does anyone have a recommendation for the setup of the Repository Database used with LBI. Our Lawson databases exist on a remote Sun Solaris box seperate from the Lawson application box. Do we have to use Oracle as our repository database Does it have to be on the same box as the Lawson database Or, could we use SQL Server as the repository database and the OLAP Analysis and place it on the LBI box
3
12132
1
by
Chris Martin
9/19/2007 6:44 PM
Possible Join Query Prob.
Started by
Deleted User
Thanks in advance... I have this query below, which was working fine till I added 'DEPTCODE.DEPARTMENT, DEPTCODE.NAME' and included 'DEPTCODE' in the FROM clause... this was to pick up the department name associated with the employee... I'm guessing I need an additional JOIN clause (nested) SELECT EMPLOYEE.EMPLOYEE, EMPLOYEE.LAST_NAME, EMPLOYEE.DEPARTMENT, EMPLOYEE.POSITION, EMPLOYEE.FIRST_NAME, DEPTCODE.DEPARTMENT, DEPTCODE.NAME, PAYDEDUCTN.EMPLOYEE, PAYDEDUCTN.CHECK_ID, PAYDEDUCTN.WAGE...
1
11830
1
by
Chris Martin
9/19/2007 12:45 PM
Query syntax error
Started by
Deleted User
Thanks in advance... I have a manually written query I'm testing to join 3 name fields into one field. Here's what I have which needs to output in a format like 'Doe, John M.': SELECT EMPLOYEE.EMPLOYEE, (&91EMPLOYEE.LAST_NAME&93 & ', ' & &91EMPLOYEE.FIRST_NAME&93 & &91EMPLOYEE.MIDDLE_INIT&93 &'.') AS FULLNAME, FROM EMPLOYEE I get an Oracle 936 'missing operation' message. Any clues
4
12216
2
by
Chris Martin
9/14/2007 3:13 PM
ODBC Connection problem.
Started by
jjcyeshua
Hello.. I need help. I am having problem creating sql expression). When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. Also when I use sql command to pull all the data that I need, the report runs very..very..very slow…. Please help… Thanks Error in compiling SQL Expression: Database Connector Error: '42000:&91Microsoft&93&91ODBC SQL Server Driver&93&91SQL Server&93Incorrect syntax near the keyword ...
3
14216
1
by
John Henley
9/13/2007 11:40 PM
Crystal parameters - defaulting
Started by
Phil Simon
Hello I was wondering if anyone figured out how to do this. I have a parameter at the command level for PRTIME that will limit the records pulled, since that table gets to be big. TR-DATE = To compare paychecks, I have another command set to PRTIME with the same parameters: TR-DATE = Ideally, someone can put in parameter 1 = 7/1/07 and parameter s 7/15/07 so you can compare both paychecks. However, OLEDB's command builder isn't liking adding the...
4
13987
1
by
Phil Simon
8/14/2007 6:54 PM
New tool I want to share....
Started by
Shane Jones
Report Bursting..... I have a bunch of Crystal Reports that I wanted to be able to group by manager and send automatically (by email) to 200 different managers. However, I have always needed to print the report and interoffice mail it. I found a tool called PDF-eXplode that allows me put a simple tag in the header and it will send the report to the managers by email... all from one report I have done a couple simple tests and they worked - tomorrow I am sending my first produc...
5
14564
1
by
Chris Martin
8/14/2007 6:47 PM
ODBC views and OLEDB commands in same rpt?
Started by
Phil Simon
Hello CRXI OLEDB 9.0.3 I doubt that the answer is 'yes', but can you create views in SQL Server 2005 and link them on the same report to OLEDB commands If you do this, then are there any visibility issues with the data Thanks. ps
1
12346
2
by
John Henley
8/13/2007 6:32 PM
Crystal Parameters for QB 9.0.3
Started by
Phil Simon
Hello I saw the KB article on Crystal Parameters called: Passing parameters from Crystal to OLE DB Object Services Description: How do I pass a Crystal Parameter to an OLE DB Object Services DME query **** A few things here: Note: Date fields and certain conditional fields cannot be used. *** I was able to add a date prompt and it worked like a charm. Is this simply a matter of Lawson's documentation not being updated ...
4
13262
1
by
Phil Simon
8/7/2007 11:29 AM
Implement LBI
Started by
Deleted User
We would like to know how much is involved in implementing the LBI module. We would do this minus the process flow for starters. Can anyone offer insight on the complexity involved Did you utilize outside consultants or Lawson for the implementation
3
13729
1
by
Chris Martin
8/6/2007 6:34 PM
PA26 - REVIEW table
Started by
Deleted User
We are Lawson 8.03, Oracle. Recently we applied CTP 45859, and program PA702 - Updates Next Review dates, and Scheduled dates. However, I have a lot of 01/01/1700 dates showing up in the Next Review, and Last Review date fields. Obviously this impacts the several Joint Commision reports that I have, so I am wondering is ther a way in Crystal that I can get the best sequenced record fromt hat REVIEW table Ex: Employee 359323 has 3 records on the table. First one is blank on N...
4
13901
3
by
Phil Simon
8/6/2007 10:46 AM
changing data sources
Started by
Phil Simon
Hello All It doesn't appear that Lawson will let you do this easily. I have a CRXI rpt via an OLEDB command in Query Builder linked to a TEST product line. I want to switch it to an ODBC connection to a different product line, obviously without the command. Changing the data source in CR doesn't seem to let me do this. It's not a big deal but I'm curious to see if any of you have been able to figure that one out. Thanks.
1
12813
1
by
John Henley
7/27/2007 2:06 PM
Query Builder vs. Oracle/SQL Server views
Started by
Phil Simon
Hello I was wondering if anyone cared to share his/her thoughts on using Query Builder vs. Views. I know that QB has the built-in Lawson security but am wondering if reporting performance will suffer as more than a handful of tables are added for Crystal Reports (deployed via LBI). In some cases, the way that the data is stored in different tables (PRSAGDTL, for example) isn't ideal for the way that 'normal' end-users look at it. Using SQL server to create a view in the dB wouldn't by ...
2
13426
1
by
Phil Simon
7/27/2007 11:45 AM
Crystal and Lawson's OLE DB
Started by
Bob Beverley
I'm able to generate reports in Crystal using the Lawson Connector (not by choice, but it's the way the client wants me to connect). Couple of issues: 1. When I first run the report I am prompted that the table isn't recognized and I have to respond 'No' to 'do you want to remove the table from the report'. However, the report runs successfully. Why is it that Crystal doesn't think it's a valid table 2. When I view the SQL (Database/Show SQL Query) I get just a list of the tables w...
12
17096
2
by
John Henley
7/26/2007 8:17 PM
general publishing tips
Started by
Phil Simon
Hello Can anyone provide experiences with publishing (in LBI) using ODBC vs. OLEDB I am finding that I'm getting some different results based on the type of conenction used in CRXI developing the report. Part of me thinks that this shouldn't matter but I've seen some discrepancies even in CR using ODBC vs. OLEB. Is LBI agnostic or pro-OLEDB Thanks. ps
0
13330
1
7/19/2007 3:42 PM
Can't see all tables
Started by
Fernando Labrada
Crystal XI using Oracle ODBC driver. When I create a new ODBC connection to a Lawson environment and I select a data area within that environment, only the tables that start from AC to MM (including all the L_) show up. Anything past MM does not. If I use the same ODBC connection and use Access instead of Crystal, I can see all the tables beyond those that start with MM. Has anyone else had this issue
8
13756
2
by
Phil Simon
7/19/2007 3:37 PM
two Crystal/Add-in questions
Started by
Phil Simon
Hello I seem to recall that you can point previously-created .dme's to different product lines so you don't have to recreate them. Any idea about how to do this Also, I also vaguely recall that you can create a .dme and use that as the basis for a Crystal report. We're running Crystal XI off of LSF on SQL Server 2005. For some reason, I thought that you could cut and paste it but can't for the life of me remember how to do that. Thanks.
2
12328
1
by
Phil Simon
7/18/2007 1:36 PM
Using ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI???
Started by
Shane Jones
I use ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI
1
13131
0
by
John Henley
7/17/2007 11:09 AM
general reporting question
Started by
Phil Simon
I really enjoyed the series on reporting. Let me make sure that I understand XI's limitations with Lawson's OLEDB connector. While you get the benefit of security, you have the disadvantage of reporting on only 'Lawson-approved' relationships). As a result, more complex reports aren't possible without some creativity. You wrote about the benefits of doing Crystal Reports based on SQL queries. For this to work through Crystal Enterprise for light users (i.e., not hard core developers on t...
5
13166
2
by
Phil Simon
7/12/2007 6:36 PM
Crystal and Lawson
Started by
Deleted User
We are currently using version 8.0.3 Applications, 8.0.29 Environment and Crystal Enterprise 8.5. We will be upgrading soon and I am trying to find out if anyone knows what versons of Crystal are compatible with the Lawson 8.0.3 Environment. We will be moving to the Lawson 8.0.3 environment later this summer, with a move to 9.0.0 sometime next year. So that is two Environment upgrades and I am only looking to make one upgrade of Crystal to the highest version available that is compatible with...
3
12855
0
by
John Henley
5/24/2007 4:18 PM
Framework and LRS Validation Problems
Started by
Larry Taylor
I installed Framework Services 1.2 and the install validator passes all tests with flying colors. Next, I installed Reporting Services, ran the install validation process and again, every passes with flying colors. I've Registered Reporting Services/Framework Services, and again, no problems. I can publish any type of report that I want and during the publication process, the report loads and displays just fine. The problem that I am experiencing is that when I mount a published report on a dash...
0
13154
1
5/11/2007 5:07 PM
Mandatory Education Reports
Started by
Deleted User
Lawson 8.03 I wrote a report using PATRNHIST, EMPLOYEE to capture the Employee Training/Course history. There are a few Mandatory Courses that encompass several Course Numbers - For example: BLS Course is select {PATRNHIST.COURSE} case '2C00000001': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') Case '2C00000002': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') case'2C00000003': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/y...
0
13062
1
3/21/2007 3:13 PM
LBI/LRS and Crystal Report using ODBC Driver
Started by
Kate Liamero
We have crystal reports designed using data direct ODBC driver to oracle database 10G. The datasource that we are using to design the reports are also setup on our LBI/LRS servers exactly the same way. We have PROD TEST and DEV environments. PROD and TEST are remote installs with the db, apps and lbi/lrs residing on 3 different servers. DEV is all on one box. DB and APP boxes are Unix/Sun. LBI/LRS Windows Version 9 for everything. We are saving the login information with the ...
7
14890
2
by
John Henley
3/12/2007 11:53 PM
Limit access to reports
Started by
Deleted User
Is there a way to control access to reports I create. People use them and throw off my formatting. I would also like to limit access to certain acct groups. Thanks Nigel
1
12645
1
by
John Henley
3/1/2007 5:40 PM
Repository in LBI/LRS Version9
Started by
Kate Liamero
I know there was no repository in LRS1.3 is there one in the 9.0 version. We want to have a central place to store formulas, logos etc. I know it exists in Crystal Enterprise but is there such a thing in the new LBI/LRS 9.0 or are the still only using RAS Thanks Kate Liamero kliameroedisonschools.com
2
13056
1
by
John Henley
2/12/2007 1:34 AM
Looking for Seurity Tables
Started by
Deleted User
I need to write a report against the security tables, but I can't seem to find the names/locations of the security tables. I am very new to Lawson (and Crystal), so I hope that this isn't a stupid question. Specifically, I need to compare security class against the employee's RD30 record, which I've found on DBLOWUR. We're running an I-Series/AS400 on the back-end if that makes any difference. Thanks in advance for your help.
1
13907
0
by
John Henley
2/8/2007 9:37 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 33 of 34
<<
<
30
31
32
33
34
>
>>
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