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.
137 Subscribed to this forum
Page 15 of 34 << < 1314151617 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

LBI Synchronizing User and Groups    

Started By  Vito Amatulli
Does any one know if it is possible to automate the Synchronize User and Roles fuinction from LBI  We re trying to automate adding of Lawson users to security and want to be able to sync the user to LBI.
4 4582 1
by  Massimo EmilioneJump to last post
10/9/2011 3:33 AM

MM280    

Started By  Chris Martin
(Topic has multiple pages1 2 )
Has anybody had any success reverse engineering MM280 (ie using sql/crystal)
34 16336 7
by  SPJump to last post
2/24/2012 4:20 PM

FS page goes off line with Portal integration (efsrole.xml)    

Started By  Deleted User
I have a single server LBI test system running on WebSphere 6.1.13 Win 2003 Sever SP2 and LBI902.  I integrated Portal a while back with dsso and a PortalRole efsrole.xml file.  My FS page goes off line sometimes when I log into my Portal Test system profile.  The page seems to stay up if I access FS outside of Portal using dsso security.  I'm working a case with Lawson but I thought I would post in the LBI forum to see if anyone else has encountered this behavior.  There are no errors in the WA...
8 4125 1
by  Massimo EmilioneJump to last post
11/15/2011 9:16 PM

Importing Rights with multiple users: Is is possible?    

Started By  ric9d
I have successfullt imported a right file into LBI. However I wanted to assign a right to several users. Of course you could do this manually, however, Im trying to find out if anyone out there has uploaded an imports file with several users. Thanks and any ideas will be appreciated.
5 3570 1
by  Greg MoellerJump to last post
9/28/2011 7:49 PM

Crystal Slow Loading in LBI    

Started By  jeff-lbi
We've been using LBI for almost a year. We have crystal 2008, and we develop front ends using .NET. Never had any problems. However, suddenly with a few new employees we have seen .rpt files take MUCH longer to upload during the re-publish process......and then furthermore take MUCH longer to load the .aspx front end called from the report Events in LBI. I have already ruled out EVERYTHING, and isolated the problem to the .rpt files themselves....but there has to be a LBI component here, b...
3 4479 2
by  MHRoyJump to last post
1/25/2012 5:25 PM

Oracle odbc drivers for RS ODBC on LBI 904 Win 2008 64bit    

Started By  Deleted User
We are doing a fresh LBI 904 install on a Windows 2008 64bit server. We will need a Reporting Services ODBC data source for Crystal ODBC reports pointing to an Oracle 11g database (Lawson app server running on AIX 6.1 Oracle 11g). Anyone know what Oracle client we should run on the Win 2008 64 bit server; example Oracle 11g client for 32bit or 64bit
6 4951 3
by  RobbyJump to last post
12/19/2011 5:31 PM

Scheduled LBI report to a constant server location    

Started By  Deleted User
We would like to be able to have scheduled LBI reports go to a constant server location so that they can be picked up by a later scheduled process (a ProcessFlow). The LBI analyst tells me that when the report runs it is written to a unique folder for every date with a unique instance number. That will make it difficult for the Process Flow to FTP 'get' the reports. Has anyone found a way to write the report to the same location each time
5 4063 1
by  Greg MoellerJump to last post
10/7/2011 3:22 PM

Scheduled report to be emailed to a directory instead of an email device ?    

Started By  Ruma Malhotra
I would like to find out whetherwe can email a report to a directory instead of an email device Can this be done in LBI We have a report that is scheduled manually every day to refresh. This report needs to be imported to a tool used for budgeting. Can I set a report to refresh on a schedule and then email the scheduled report to go to a directory instead of an email device
11 4461 2
by  Ben CoonfieldJump to last post
10/7/2011 6:23 PM

LBI report users    

Started By  Jan
I haven't found this issue in this forum so I'll post it now. I apologize if this was addressed earlier and I missed it. As employees terminate or transfer, I need to determine if I need to adjust LBI report distributions. Which LBI tables do I need to access to see which reports (or smartnotes) an employee has been a recipient for I have quite a few reports built up, so doing this by hand is getting to be unworkable. thanks in advance for any help you can throw my way
10 5421 3
by  Greg MoellerJump to last post
11/15/2011 9:34 PM

No recipients to whom to send the content    

Started By  Greg Moeller
In my SystemOut.log file for LBI, I get a failed delivery 'No recipients to whom to send the content.' message when there is no delivery device set up for a particular report user. Is there a way to associate to which report this user belongs from the rather lengthy error in the log file For example: [11/11/11 8:30:21:879 CST] 0000005a SystemOut O Email Delivery Status: com.lawson.efs.delivery.components.engine.DeliveryEngineImpl.deliver(DeliveryEngineImpl.java:74)com.lawson.efs.deli...
4 3496 1
by  Greg MoellerJump to last post
1/27/2012 7:33 PM

Crystal and .csv table linking    

Started By  Katfra
I've linked a .csv file as my table in crystal. I have a debit, credit, and difference colum in the file which shows in the crystal report, except where anything has a negative value. I've tried creating calculted fields to produce the credit balance in crystal, which worked in my credit column. However, if I create a formula Debit-Credit where my debit might be a zero balance, my result is blank in the difference column. Anyone have any ideas I've tried a running total as well with no luck...
2
4039 1
by  KatfraJump to last post
12/5/2011 7:40 PM

Fields restricted? Excel pull of Lawson data through OLEDB    

Started By  BertNeu...
So, built a DME using Lawson Query builder (LQB), (Employee table, fields = Employee, Pay-rate); execute gives expected fields. Pasted the LQB DME text into the Excel Data -other sources routine results: only the employee field was returned. Hmmm, went back to LQB, and specified the entire employee table, copied the DME, and in Excel all fields came back except anything to do with pay. Same thing when pulling from Timerecord table - only non-pay fileds returned to Excel, despite all fields sh...
13 5750 3
by  BertNeu...Jump to last post
1/11/2012 8:17 PM

Crystal Reports How to determine frequency of RUNS    

Started By  Layne
Does anyone know the tables in the LawsonRS database that would tell me when the last time a report was run, how often its being run, and who is running it. I see a started and finished field in the ERS_REPORTSTATUS Database, but it does not appear to be correct based on reports I have run.
6 6122 0
by  LayneJump to last post
1/9/2012 8:19 PM

Printing Lawson Report Number on Report    

Started By  Layne
I'd like to print the Lawson Assigned Report Number on the report. In Crystal, I tried using the Special Field called File Path and Name, but apparently Lawson copies the rusults report over to a temp folder on the local PC running the report. There is no report number on the file name at this point. Any ideas on how I can do this without running another query to the GEN database.
1 3757 1
by  John HenleyJump to last post
1/25/2012 2:29 PM

Crystal Report Viewer Erroring out in 1 IE User Workstation    

Started By  jeff-lbi
First I will preface by saying I've already uninstalled and re-installed Internet Explorer 8 on this machine. It is the only machine we have this issue with. I have not seen this with any of our other users. Basically when a crystal report is run from the LBI interface the window opens but IE bombs out with errors such as : (Related to crv.js) Message: 'Image' is undefined Line: 271 Char: 13 Code: 0 (Related to crv.js) Message: Object doesn't support this property or method Lin...
7 6979 1
by  jeff-lbiJump to last post
1/25/2012 4:25 PM

Link to Webinar?    

Started By  Greg Moeller
Does anyone have the link to the LBI version 10 Webinar handy The Webinar started 15 minutes ago, and I can't locate the link.
3 5849 2
by  SPJump to last post
1/27/2012 8:40 PM

GEN Database Programs and Screens    

Started By  Layne
I am running the following query on GEN. I wanted to see what fields are being used by a certain Program and Screen. SELECT * FROM dbo.PGMFLD WHERE PROGRAMCODE = 'HR11' AND SCRNBR = 1 AND PRODUCTLINE = 'LAWPROD' What is the prefix field used for. Is there a list of the defintions of these fields Let's say I was in the Lawson Portal on Screen HR11.1. I want to know what tables and fields that this form uses, so I can write a report. I am not worried about how to connect back to o...
2 4656 1
by  Greg MoellerJump to last post
1/31/2012 1:44 PM

Portal Field Descriptions    

Started By  Layne
In the Portal on say Screen HR11.1, there is a field desciption called 'Social Number.' Does anyone know where this field description can be found in the GEN database. I was looking at Docfld and DocScrFld, but they do not seem to contain of them.
4 5089 1
by  Jim Van ZummerenJump to last post
2/1/2012 1:03 PM

Max export to excel ?    

Started By  jeff-lbi
I recently ran a report where the result set was close to 200,000. I know this would require excel to have 4 sheets. Instead of finishing it prompted for a login information and asked for a refreshed data set Does LBI start to have a problem exporting to excel after so many records
3 4091 0
by  Matthew NyeJump to last post
2/8/2012 8:10 PM

Open Crystal Report Hyperlink using updateModule in LBI    

Started By  Daksha Desai
I have a Crystal Report open in a module on the dashboard. It has a hyperlink which opens in a new window but I want it to open in the same module. I tried adding updateModule to the link but a url appears before the updateModule and it does not work. Can anyone help please
5 4667 0
by  Matthew NyeJump to last post
2/7/2012 8:11 PM

Is there a way to get the user_id name to print on a Crystal rpt?    

Started By  Deleted User
I'm looking to create a report that would show the date and name of the user who added or changed PA59 records within a 24hr window. Is there any way to use the User_ID from the PAGRDI file to get the employees name who add/changed the records
0 3194 0
2/8/2012 3:50 PM

Crystal/Xcelsius and LBI Bursting    

Started By  Dave Curtis
We are currently working on rolling out LBI for our leadership team. One of the things I would like to do is utilize the functionality of Crystal Reports and Xcelsius to develop some interactive charts of employee reviews, certifications, turnover etc. I am not having very good luck with it at this point and before I spend money and time trying to learn more about Xcelsius I wanted to ask the group here if anyone has been succesful at publishing a Crystal Report with an embeded Xcelsius .S...
2 4731 1
by  Dave CurtisJump to last post
2/9/2012 3:32 PM

What's New in LBI 10 document published on Mylawson.com    

Started By  Ruma Malhotra
I just found the what's now for LBI 10 document present on mylawson.com. Looks like all the auditing related to reporing services and smart notifications have been added to this version. This will be a huge plus for all customers wanting to find out security,render times etc on LBI for a long time.
1 4212 1
by  mark.cookJump to last post
2/16/2012 4:22 PM

LBI Crystal Reports behavior with Adobe    

Started By  MHRoy
We have recently installed LBI. We have been able to publish 'home-grown' crystal reports and they run fine. When selecting print in the Crystal Reports 2008 viewer a 'Print to PDF' box appears with a Page Range section and information that the viewer must export to PDF to print. If we click on the Export button a File Download box appears. Choosing Open will bring up the local PCs version of Adobe and one can either print or export. Is this the correct behavior for LBI/Crystal Reports ...
4 5211 0
by  MHRoyJump to last post
2/16/2012 6:32 PM

Updated to 9.0.4.2.98 on Thursday in PROD    

Started By  Greg Moeller
Updated on Thursday and now gettting repetitive errors in the log about ReportEngine not compatible with CrystalEngine. Lawson has a JT opened for it, JT-293938, but we are wondering what we can do in the meantime. Can I downgrade LBI by applying a 'Update' Hesitant to upgrade to v 10.0.0.0 because of all of the zeros. Error involves the scheduling and emailing of reports.. coming out corrupt, or prompting for an Oracle database id/password which MANY users do not have. Any though...
4 3218 0
by  ElenaJump to last post
3/1/2012 4:21 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 15 of 34 << < 1314151617 > >>


RSS Feed Available
Forums Performance Management

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post
189 635 14 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM