Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
Search this forum:
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 2 of 9 << < 12345 > >>
 Last Post
0 Replies and 1085 Views Wildcard in LBI report name  1085  0 Started by  Joan Herzfeldt I use the device type 'Network Drive' to export files and place them in the exact folder another system uses to import the file. My problem is several systems need the files named specifically with the current date in the name. I know the Report Name is what's used for the file name when it's exported, which I don't like but can live with. So far I've been able to work around it, but now I have a system that needs the Date FIRST, ugh. Does anyone have a solution for adding dates to the filen...
0 1085
09/04/2015 10:18 AM
6 Replies and 2649 Views Using Lawson Report as a data source in Crystal  2649  6 Started by  Kelly H We are trying to use a Lawson report as a data source in crystal. We have the URL and are able to publish that to LBI. But ultimately we would like to use the report to create a larger report in Crystal which we could then publish in LBI. Is there a way to tie this report to the tables in Lawson via Crystal to create the larger report Any thoughts or suggestions anyone has would be appreciated.
6 2649
by  Greg MoellerJump to last post
09/03/2015 1:47 PM
0 Replies and 1059 Views SCM Reporting - Cycle Count Variances  1059  0 Started by  Robby Since this is a reporting question pertaining to SCM, I posted in both places in hopes of finding someone who knows just what I need! I'll let you know up front, I'm new to reporting for Supply Chain, so if this is too easy of a question....don't hold that against me! The business wants me to create a report (custom, of course!) to highlight the cycle count variances. Apparently, Lawson only tells you 0 (zero) variance if your count is greater than the expected count. But, here's...
0 1059
07/31/2015 12:07 PM
2 Replies and 1796 Views Issue with PDF reporting  1796  2 Started by  Tony Scott Hi, We are using Lawson Portal 9.0.1 at our workplace and we always have issue with report not showing proper format in pdf. When we run report using RW100 and then go to view options PDF-landscape, it does not show all the columns in the report. I am attaching a file that shows example of this on page 1. To fix this, we use a cumbersome approach, where we open the print folder, locate the jobname, change the font type, orientation, scaling to display all the columns and format properl...
2 1796
by  Tony ScottJump to last post
07/20/2015 9:34 PM
8 Replies and 15122 Views How 2 Convert Quartz Scheduler date/times?  15122  8 Started by  Milo Tsukroff I'm writing some Crystal reports that hit the LBI table.&160; I want to know when reports are scheduled to run, and when they ran, etc.&160; I can build performance metrics against this once I can get this info.&160; Apparently the Quartz Scheduler stores date/time as a number using its own Java method.&160; The fields in question are in EJS_TRIGGERS -- NEXT_FIRE_TIME, PREV_FIRE_TIME, START_TIME, etc.&160; Does anyone know the algorithm to use to convert these times&160; I&160;see big m...
8 15122
by  Greg MoellerJump to last post
07/15/2015 9:36 AM
4 Replies and 1307 Views Crystal report reading a csv file  1307  4 Started by  DV I have a Crystal report that reads Lawson files and a .csv file. When I publish it to LBI it asks for User Id and password regardless of the options I choose in Data Settings. I have done this with .xls files and there is an option in Crystal under Verify Database for Secure Login and I make sure that is unchecked but I don't get that option in this report.
4 1307
by  DVJump to last post
07/14/2015 12:17 PM
0 Replies and 997 Views Crystal report reading a csv file  997  0 Started by  DV I have a Crystal report that reads Lawson files and a .csv file. When I publish it to LBI it asks for User Id and password regardless of the options I choose in Data Settings. I have done this with .xls files and there is an option in Crystal under Verify Database for Secure Login and I make sure that is unchecked but I don't get that option in this report.
0 997
07/14/2015 11:12 AM
4 Replies and 1134 Views Report Run Log  1134  4 Started by  Sue Knowlton I have a requirement to log each time a report is run. Does anyone know how this can be configured
4 1134
by  Sue KnowltonJump to last post
07/01/2015 2:00 PM
1 Replies and 1169 Views Dashboards and bursting  1169  1 Started by  thummel1 I am exploring the capabilities of the Dashboard in LBI. We leverage them regularly today. Several of the items on our dashboards are bursted LBI reports to managers. I'd like to be able to burst an Excel document to managers, and have that be available on a dashboard. I know I can have LBI read an Excel document, but Excel is not an approved data source for us, so the end-user only sees the most current refreshed version (which we are Ok with). We are just exlporing ways we can make acce...
1 1169
by  Dave CurtisJump to last post
06/23/2015 11:35 AM
0 Replies and 783 Views Summarizing totals in main rpt for arrays in sub rpt  783  0 Started by  Donna This report is combined Lawson and EPIC information. The sub report is by customer and summarizes the total charges for every department the customer (patient) uses. I have 3 shared arrays in a sub report that is grouped by customer (group1) and department(group2). Array 1 is the count of each department and amount value. Array 2 is the value of each department code. Array 3 is the value of each department’s total charges. There is an additional shared maximum value for the count of th...
0 783
06/22/2015 2:02 PM
0 Replies and 1002 Views Upgrade best practices?  1002  0 Started by  Greg Moeller When we upgrade to v10, we are moving from Oracle Solaris (Unix) and Oracle DB to Windows and MS-SQL. We have 700 reports. What is the best practice to get the reports converted to MS-SQL from Oracle Doing this all on go-live weekend is not acceptable. Do we spin up a new version of LBI and point it all to sql Or do we republish the reports in current version with just a new name Other options Other opinions
0 1002
06/17/2015 3:01 PM
2 Replies and 1794 Views oleDB Query Builder Error  1794  2 Started by  Srini Rao I'm using the query builder for oleDB object services to bring the Lawson print file and format it in crystal. I used the oleDB object builder for CU201, MM280 etc it worked. But when I use it for RW100 or HR170 I get following error... --------------------------- LawsonQueryBuilder --------------------------- An error was returned from the Lawson Application. The error code is &91;ERROR_GENERATING_XML&93; The error message is &91; An unknown error occurred. Please contact your sys...
2 1794
by  Srini RaoJump to last post
06/17/2015 6:52 AM
10 Replies and 2128 Views Default Report Permissions  2128  10 Started by  Greg Moeller Hi! Does anyone know which table holds the Default Permissions for reports We have been struggling with intermittent issues where the 'Ability to view with refresh data and view with saved parameters' gets unchecked. And we're really looking for a way to audit all of those default permissions. Thanks in advance, -Greg
10 2128
by  Greg MoellerJump to last post
06/16/2015 10:26 AM
2 Replies and 1295 Views Total Rewards Statement?  1295  2 Started by  thummel1 Greetings, I am doing some exploration on the creation of a Total Rewards Statement. I am looking to design something that would basically consist of an employees total compensation package that could be accessed, for example, in Employee Self Service. I'm wondering if Lawson can be used to provide this type of information and if any other organizations have tried it, and if so, 1. What can you share about how you prepared for this type of project 2. Did you have to purchase any ad...
2 1295
by  thummel1Jump to last post
06/08/2015 3:34 PM
1 Replies and 1426 Views Updating LBI to latest available version  1426  1 Started by  Chris Mackley We're currently running LBI version 10.1 (a little behind, I admit), and are wanting to get updated to the latest and greatest. Problem is there's some confusion with versions and licenses, specifically when talking about Infor BI (or Infor BI for Lawson)... It looks like 10.6 is the latest, but we're being told it's a separate product at that point and that there would be a change in our license terms. So ultimately my question is: what is the latest version that is still technically 'LBI'...
1 1426
by  Carl.SeayJump to last post
05/28/2015 7:59 PM
8 Replies and 1776 Views LBI Report Usage Statistics  1776  8 Started by  Donna We are cleaning up our dashboards and want to track the report usage. We are on LBI and have elected to allow dashboard audit. We want to prepare a report that can be run on demand to track the report usage. Does anyone have any suggestions Thank you. Donna Shelton
8 1776
by  Greg MoellerJump to last post
05/15/2015 1:46 PM
2 Replies and 1325 Views not All LBI users show up in LBI  1325  2 Started by  Xin Li We have more than 5000 LBI users configured in Lawson back office with LBIUser group. However, We only got around 5000 users propagated over to LBI. Any help how to resolve the issue is much appreciated.
2 1325
by  Xin LiJump to last post
05/07/2015 2:18 PM
1 Replies and 1235 Views Crystal-Financial Statements-Selecting the month  1235  1 Started by  dcaiani So I have a Crystal Report built where I am showing financial data Primarily from the GLAMOUNTS and FBDETAIL tables. The report basically looks like this: Company | Account | MTD Actual | MTD Budget Its subtotaled at the company group level. So for one month its working correctly.What I want to do is make it so that the end user is picking the month they want to see from a drop down list rather than creating a report per month or a report that lists all months. The problem I'm having...
1 1235
by  RandyJump to last post
04/29/2015 10:43 AM
0 Replies and 1283 Views LSR report not coming up  1283  0 Started by  Kenn We have DS code that funs a PO120 job and pops up the report in LSR format. It is working in our dev environment but not in our QA environment. Although, if I run it in PDF format (comment out the LSR line below and activate the PDF line), it brings it up in .PDF format fine. Below is the error in the log stating that the program is not enabled for report format. does anyone know how to enable the program for that format porpt='/servlet/Reportaction=LSR&file=/'hst'/law/print/'usr'...
0 1283
04/21/2015 4:35 PM
18 Replies and 5385 Views How do I report off of a derived field, specifically app.pmt-status?  5385  18 Started by  joycie I need to run a report on all 'OPEN' payment status.&160; When I view app.pmt-status, OPEN is a valid value, but the field is derived.&160; How do i find out what data they use to derive the field value&160; The field appayment.pmt-status is not available to choose in a report, i am assuming because it is derived.
18 5385
by  John HenleyJump to last post
03/26/2015 10:11 AM
4 Replies and 1289 Views ODBC work on LBI 10.5?  1289  4 Started by  ISO_Dan I heard that in LBI 10.5 that all Crystal reports have to be OLE DB. Can someone confirm this We have many reports using SQL and Views and to convert all of them would be very time consuming. Hoping ODBC will work with 10.5 Thank you, Dan
4 1289
by  ISO DanJump to last post
03/19/2015 12:09 PM
1 Replies and 975 Views HS15 data  975  1 Started by  Karen Ploof or is it generated on the fly
1 975
by  Karen PloofJump to last post
03/09/2015 12:58 PM
12 Replies and 2374 Views LBI to network share export  2374  12 Started by  TimB I am trying to publish a Crystal Report in LBI and schedule it to export in excel format to a network share. This seems like it would be a simple and popular request, but I don’t see the option to do this. Does anyone have any experience in this, or know if it’s possible Thanks
12 2374
by  Joan HerzfeldtJump to last post
03/09/2015 12:38 PM
6 Replies and 1323 Views API and JDBC  1323  6 Started by  Greg Moeller Is anyone out there using API and have upgraded to the Laborworx version (API .NET) We are trying to create a JDBC connection to the database, and cannot any longer. It used to work before we upgraded, but has something changed in the database config that is now preventing us from using a JDBC connection Thanks in advance, -Greg
6 1323
by  Matthew NyeJump to last post
03/09/2015 11:45 AM
2 Replies and 1612 Views Report is Blank  1612  2 Started by  Srini Rao When I open LARGE reports in IE, it opens the blank page. But other browsers like Firefox and google chrome open the report in pdf format. Any idea why IE is not supporting the large PDFs
2 1612
by  Srini RaoJump to last post
02/20/2015 9:58 AM
1 Replies and 1208 Views LBI SSL Errors  1208  1 Started by  reedry We just recently had our LBI SSL certificate expire and have had all kinds of issues updating it. We followed a user guide provided by Lawson but to no avail, then we hired consultants to help us out and they were unable to fix the problem. After several days of working with them, they were finally able to tell us that the issue lied with our certificate being 2048 bit instead of 1024. We switched the certificate out and are still unable to get the server to recognize the SSL certificate. ...
1 1208
by  Carl.SeayJump to last post
02/03/2015 1:07 PM
2 Replies and 1366 Views HR Department Name  1366  2 Started by  Alise Would anyone know from their experience what table contains the HR Department name
2 1366
by  AliseJump to last post
01/22/2015 9:45 AM
0 Replies and 1254 Views BackOffice Reports Not working  1254  0 Started by  Srini Rao Hello, We installed new LBI server and we are on 10-1-11-0-176 . My FTP settings are working and I validated the connection settings from cmd line. After publishing the report, when I click on the report I get following error. Message: K:\LawsonDocuments\29_Testing backOffice\Testing backOffice.lxr (The system cannot find the file specified.) Description: Report Request Failed For: Testing backOffice.lxr I checked the lawsondocument folder and I do not have .lxr file. Any...
0 1254
01/16/2015 9:46 AM
4 Replies and 1443 Views LBI back office reports do not work  1443  4 Started by  Xin Li After upgrade to LBI RS, none of our Lawson back office report work. Anyone has any idea
4 1443
by  Xin LiJump to last post
01/15/2015 9:26 AM
1 Replies and 1530 Views MA236  1530  1 Started by  Chesca I got a called from our purchase manager about the MA236 report not being put in the buyer's queue. He is the only person that's getting the report. The job is scheduled to run in RECDEF. How do I get the report to print in each of the buyer's queue Should I open an incident with Lawson
1 1530
by  mikePJump to last post
01/12/2015 10:17 AM
0 Replies and 1281 Views Crystal report hyperlink to detail crystal report  1281  0 Started by  Melissa I have a crystal report published in LBI that has a hyper link to open another crystal report to obtain detail. the detail report opens in excel and works fine, but when i go back to the main crystal report and try to click to the next page i get an error 'unable to process your request'. Does anyone know why I'm getting this or how to fix it the main report pages fine if i dont' click the hyperlink to the detail report, but one i open the detail report i get the error.
0 1281
01/10/2015 12:06 AM
0 Replies and 858 Views Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction  858  0 Started by  Vitas We are researching the possibility of Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction. For example, we have a Dashboard link content module that executes a process flow, which in turn executes a SQL Server SSIS package on another server. We're trying to see if we can just save time by configure the running of a script or command line transaction to run the SSIS package directly. Anyone encounter or put something together similar to this Th...
0 858
12/12/2014 7:16 AM
1 Replies and 1265 Views LBI issue when last folder in LBI list deleted  1265  1 Started by  Donna The crazy thing is that the correct reports reappeared in LBI some time later when I logged back in. The only thing I did int the interim was create space to back up my Lawson Documents and look for posts on the issue. I was concerned that there was an issue with a corrupt Lawson Documents file and created a back up copy of the file but now I don't see any thing out of the ordinary. The LBI folder that should have been deleted is gone and all the other reports are displayed again in my LBI...
1 1265
by  DonnaJump to last post
12/01/2014 12:13 PM
6 Replies and 5097 Views Data Mart  5097  6 Started by  Lisa Stewart Since Lawson no longer offers a Datamart solution what are most customers using
6 5097
by  ssarawgiJump to last post
11/25/2014 12:44 PM
2 Replies and 1353 Views Report opens very slow  1353  2 Started by  Jan Hello I have an employee roster report that is created on a schedule each everning and creates an Excel spreadsheet available as a link through our self service web page. Users have stopped using the report because it can take from 30 seconds to a minute to open the report - there are about 8,500 lines in the report. On my machine, I have a mapping to the server where this report resides. If I go directly to the server folder and open the spreadsheet, it opens in a couple of seconds. ...
2 1353
by  JanJump to last post
11/20/2014 2:56 PM
11 Replies and 1987 Views Published report does not run on a schedule  1987  11 Started by  Donna The KRONOS database is on a different server than the Lawson database but that is not an issue when I run the report from the dashboard. The error message from the scheduler is as follows: The system cannot find the file specified. ---- Error code:-2147467259 &91;CRSDK00000000&93; Error code name:failed Description: Report Request Failed For: REHAB SCHED KRONOS Employee Daily Summary for Rehab_16.rpt
11 1987
by  DonnaJump to last post
11/18/2014 11:04 PM
9 Replies and 1536 Views GLTRANS join to GLCHARTGTL - to obtain Account Description  1536  9 Started by  Alise General Ledger report designed and functioning, except for account description field. How to properly join GLCHARTDTL to GLTRANS to obtain Account Description Or is there a more appropriate way to obtain the Account Description
9 1536
by  AliseJump to last post
11/18/2014 12:39 PM
1 Replies and 1178 Views How to set the date parameter format to ddmmyyyy(UK format)?  1178  1 Started by  eve Hi, When viewing the report in Crystal, date parameter is correctly displayed as ddmmyyyy following the viewing locale setting as UK. However, when the report is published to LBI, the date format becomes mmddyyyy (US format). Both system and user locale in LBI have been set as UK but there is no change. Has anyone encountered the same Is there any way to resolve this Thank you!
1 1178
by  Matthew NyeJump to last post
11/10/2014 4:42 AM
3 Replies and 2989 Views Error when running report in LBI (dashboard)  2989  3 Started by  JonA I'm attempting to run a report an keep getting this error 'Max processing time or Max records limit reached' Is there a setting in LBI that I can change to avoid this error
3 2989
by  Beate Hughes-BrownJump to last post
11/06/2014 8:37 AM
5 Replies and 2112 Views Income statements using Crystal  2112  5 Started by  Sumit Varma We are evaluating publishing Income Statements in LBI that are drillable to lower levels. Has anyone tried this I am wondering if sourcing from RW would be better or going directly to the Lawson tables.. also, not sure how drilling would work.
5 2112
by  MelissaJump to last post
10/29/2014 2:16 PM
13 Replies and 4250 Views Financial statement performance – RW100 as data source vs. Crystal direct to tables  4250  13 Started by  Deleted User Should financial statements be built using RW100 and published to Crystal&160;or built from&160;scratch in&160;Crystal to ensure the best performance&160; Are there additional considerations when determining the best tool to build financial statements – security, Reporting Services, Drill Around, etc. &160; My experience is dated, but at one point building financial statements pointing directly to tables was not best practice.&160;I understand the limitations using the OLE DB connecti...
13 4250
by  MelissaJump to last post
10/29/2014 2:01 PM
1 Replies and 1500 Views RAS log on as account  1500  1 Started by  Skip123 Our RAS server, which resides on our LBI server, was configured so the 'LogOn As' setting was set to the LocalSystem account. All of our LBI cyrstal reports were running fine, but reports that were modified (even slightly) and redeployed were failing. Infor isolated the issue to the RAS server. Changing the 'LogOn As' setting to use the lawson AD account resolved the issue. I'd prefer not to use the lawson account, but I'm not sure what type, rights, etc. of an account I need to set up. ...
1 1500
by  Greg MoellerJump to last post
10/27/2014 3:25 PM
1 Replies and 1049 Views Securing Details report link from users  1049  1 Started by  clb393 Hello! Our users are able to clink on the Details link within a report. Where can i remove that access and allow them to only access the History link Thank you, Chris
1 1049
by  Matthew NyeJump to last post
10/13/2014 12:30 PM
0 Replies and 1667 Views windows authentication for LBI reports  1667  0 Started by  Donna We have a subsidiary that wants to use the ODBC Trusted Connection for their published reports. I can set up the ODBC with a SQL Server driver and successfully create a report. When I publish the report, I am not getting the datasource to work. I did not enter the default login information but used the option Prompt for UserID and Password Error message received: The viewer could not process an event. Failed to open the connection. Failed to open the connection. Elements {FC167323-25...
0 1667
09/25/2014 10:45 AM
0 Replies and 1251 Views LBI and Dynamic Parameters  1251  0 Started by  thummel1 Hi, My LBI report has one dynamic parameter. The parameter comes from the DEDCODE table. I also have the DEDCODE_DESCRIPTION included in the parameter. When I run this report in LBI, the parameter screen prompts, but the drop down that displays each deduction code is missing. I have set my 'Maintain Parameters' screen to 'Use Crystal Parameter Page'. Also, I have set my data settings to 'Use Report Data Source' as the Override DataSource and also put in the password. What could be causing ...
0 1251
09/24/2014 12:26 PM
1 Replies and 984 Views End User sees Parameters differently  984  1 Started by  thummel1 Hi, I published a report to LBI test with 3 dynamic parameters. When I open the report in LBI TEST, the parameters page pops up, and displyas the parameters as I would expect to see them...each one has a box on the left. You can click on the data field you want and bring them over the the box on the right. When my co-worker runs the report, the data fields do not appear in the left boxes, it's just blank. She can manually type in the options on the left and bring them to the right, but I don...
1 984
by  thummel1Jump to last post
09/24/2014 7:57 AM
0 Replies and 922 Views LBI - support Signatures ( picture )  922  0 Started by  AJP I currently run reports via Crystal XI - had initial issues with gathering the signature capture on the Crystal report - which is exported to PDF or Word documents. This is now all sorted - the issue was loading the drive to the printer within Citrix ( crystal ) However - my next issue with this is getting this report loaded onto LBI The report uploads via Crystal into LBI - but the OLE Object ( picture object ) which is where the signature file is located does not appear. Does LBI support ...
0 922
09/15/2014 5:00 AM
2 Replies and 2093 Views LBI Report Delivery Options  2093  2 Started by  thummel1 Hi, I have a few reports that open directly in Excel (Data Only) or PDF in LBI. The process to distribute these is to sava e copy, then they can be emailed as desired. My question is: Can the reports be set up not only to open directly in the chosen application (PDF, Excel, etc) but to also email them directly without having to save a copy first Wondering if there's just an option that needs to be selected in LBI
2 2093
by  thummel1Jump to last post
09/12/2014 2:33 PM
5 Replies and 1656 Views LBI and Dynamic Parameters  1656  5 Started by  thummel1 Hi, I am using Crystal reports 2008. My Crystal report has 3 dynamic parameters. This allows the end user to select 3 separate critera (Job Class, Payroll Year, and Provider Comp Plan). In Crystal, the end-user can choose one or many job classes, one or many years, and one or of many Provider Comp Plans. When I publish this report to LBI, my parameters do not display the 'left' 'right' boxes that allow you move data from the left to the right that you want to include. My question is, why are...
5 1656
by  thummel1Jump to last post
09/09/2014 11:45 AM
1 Replies and 1245 Views LBI RS table where report runtime is stored  1245  1 Started by  Jey Hi, We are using LBI version 10.3 and I am looking for RS table where the report runtime is stored.
1 1245
by  Greg MoellerJump to last post
08/30/2014 10:11 AM
15 Replies and 3495 Views LBI Deployment from DEV to TEST to PROD  3495  15 Started by  George Graham Wanted to start a thread to see what different methods people are using for deploying changes in LBI from a DEV/TEST environment to PROD. There are obviously several key areas that come into play - and this is just a couple of examples to get the ball roilling: 1. Reporting data sources - are they named differently Credentials different from one to the other 2. Published back office reports - differences in product line names and/or IOS services - are you manually changing them when deploy...
15 3495
by  David BrittonJump to last post
08/27/2014 10:07 AM
2 Replies and 1536 Views Crystal Reports and OLEDB  1536  2 Started by  Layne We have had numerous occasions when Crystal Reports inside LRS have all of a sudden started prompting for an OLEDB username and password. We can input the porper username and password into the report and it will work just fine for that one time, but will keeep asking for the username and password each and every time that it's run. We even had some report instances that were run overnight in our history today that would prompt for the OLEDB username and pasword. Does anyone know how LRS uses th...
2 1536
by  mikePJump to last post
08/22/2014 3:09 PM
0 Replies and 1128 Views LT101 Supervisor Errors to LBI missing data  1128  0 Started by  clb393 Hello! We have the LT101 Supervisor Errors report upload to Crystal via OLEDB connection. The report runs fine in portal but in LBI it does not include those errors where the supervisor field is missing. Is this a case of missing XML tags If so how would i get the tags added Thanks for your help, Chris
0 1128
08/21/2014 3:04 PM
3 Replies and 1118 Views Scheduling limitations  1118  3 Started by  thummel1 Hi, We have many LBI reports that are scheduled. Is it possible to limit the number of saved instances in the HISTORY section of the LBI report For example, Customer A want an LBI report scheduled to run every Monday. They only want to have the last 6 scheduled reports saved. Is there a way to 'purge' reports older than this without going in and manually deleting them I ask because an issue recently came up where server space is almost at max capacity and the thought is that these save...
3 1118
by  Matthew NyeJump to last post
08/20/2014 1:14 PM
5 Replies and 1411 Views Date Stamp in PERSACTION table  1411  5 Started by  thummel1 Hi, I'm wondering what would be the equaivalent to the Date Stampof PA Actions in the PERSACTION table There are several date fields in there but none of them seem to reference the date that the transaction was entered. Logically, it seems that there would be one data field that contained the same date (since we run a PA100 on a nightly basis), but all the date field have a variety of dates or no date. Does this data field exist
5 1411
by  MattJump to last post
08/15/2014 10:24 AM
13 Replies and 1855 Views LBI - Schedule a report with a parameter  1855  13 Started by  thummel1 Hi, Is it possible to schedule an LBI report that requires the end-user to enter a parameter My objective is to allow a manager to view only the records he or she needs to see by entering their User ID as the parameter to view their data on the report. This needs to be scheduled in LBI because we cannot bump up against Production. Furthermore, bursting this report by manager (which was my first approach) is not working for reasons that Lawson Support hasn't been able to diagnose yet. (The ...
13 1855
by  RandyJump to last post
08/14/2014 9:13 AM
0 Replies and 1034 Views Export report & append date to filename?  1034  0 Started by  Jimmy Chiu Is there a way to export a report with a format Where the date is grabbed from the system time
0 1034
08/01/2014 10:02 AM
27 Replies and 3430 Views Crystal Reports Will Not Refresh in Report Services  3430  27 Started by  Jordan I've been asked to get reports and documents setup on an existing dashboard for our supply chain team. I don't have a true IT background and am essentially wondering if I need to get our Lawson IT group involved in this problem. I have reports created in Crystal and they refresh with no problem in there. I've published them to the reporting services but when I click to either View Latest Instance or View with Data Refresh, I get the following error: Error Failed to open the connection. F...
27 3430
by  redankerJump to last post
07/24/2014 9:44 AM
8 Replies and 1370 Views Name Change Report  1370  8 Started by  thummel1 Does anyone have a Crystal report that is designed to show an employees 'Old' name, and 'New' name, side by side My goal is to be able to design the report so I can see my current last name and in another column, my prior last name. I already have a report that shows old name and new name, but old name is in a group and new name is in it's own group. Would love if you are willing to share the SQL of a report designed this way. Thank you!
8 1370
by  thummel1Jump to last post
07/23/2014 2:57 PM
0 Replies and 1029 Views Bursting LBI report that has 5 subreports  1029  0 Started by  thummel1 Has anyone been successful in bursting an LBI report that contains subreports I have isolated the issue to when I add the bursting feature to the scheduled LBI report, I receive a prompt to enter the UserID and Password. I know this issue is isolated to bursting because when I shut the bursting off, the report opens just fine. The field the report is burst on (the manager's User ID) is in the 'main' report. I reviewed this report with Lawson support yesterday and they suggested I add the User I...
0 1029
07/23/2014 7:27 AM
1 Replies and 1318 Views Report Not Bursting As Expected  1318  1 Started by  Elizabeth Ardito I have been using LBI to published back office reports for years. We recently purchased the full version and I am attempting to setup and burst a crystal report with department data and vice president summaries (the summaries are subreports). We are on LBI version The problem is, it seems to burst almost correctly. I only have access to the departments I am assigned to in the maintain rights but I have access to the vice president summaries who are responsible for the departments....
1 1318
by  thummel1Jump to last post
07/23/2014 7:07 AM
1 Replies and 1125 Views LBI report returns to Crystal parameter page  1125  1 Started by  Adam K I am having some issues with a few reports using url's to access subreports. The reports have a URL link to sub report. When the sub report is closed the crystal parameter page opens instead of going back to the base report. I am on LBI and CRAS 12. Has anyone seen this behavior before And did you find a workaround or solution Lawson was unable to replicate the issue.
1 1125
by  mikePJump to last post
07/15/2014 1:06 PM
16 Replies and 1921 Views Table for Report Schedule Names  1921  16 Started by  clb393 &91;IMAGE:651&93; Hello! I would like to know what table in LBI i can query that lists Report Schedule Names. Please see above for a screen print of what i am referring to. Thanks, Chris
16 1921
by  Greg MoellerJump to last post
07/02/2014 10:16 AM
3 Replies and 2310 Views URL/link to AP150 Output  2310  3 Started by  Bill Corriveau Anyone have a way to add a URL/link or button to Lawson report output&160;We are looking to provide the ability for payment reviewers to run AP150 in non-update and then view the actual&160;invoice images from our images server, while looking through the AP150 output online. Does it require generating the report in a different output format in order for a URL to work The standard text outputs allow for drill around, but we're trying to figure out how to do something similar only point to a U...
3 2310
by  GiuliaJump to last post
06/23/2014 1:58 PM
4 Replies and 1238 Views LBI Report Owner change  1238  4 Started by  Mary Porter Is there a way to do a mass update for LBI report ownership change I only found an article on mass updates for Smart Notifications.
4 1238
by  Mary PorterJump to last post
06/20/2014 1:08 PM
0 Replies and 958 Views Incorporate GL Data in the MM280  958  0 Started by  Whitney Johnson Is there a way to incorporate GL in the Department Expense Distribution Report so that it ties back to the Operating Expense Currently we are having to run two reports to provide this information. The MM280 and GL290 for the account needed. This report would have all the same field headings as the current MM280 report, but include entity, department, and whether the transaction was an accrual or not. Also, the main difference being year to date instead of just that month.
0 958
06/19/2014 9:11 AM
0 Replies and 1022 Views LBI Pricing  1022  0 Started by  Ruma Malhotra Our organization is planning to buy LBI and before we take the leap forward wanted to find out some information about pricing. Is anyone out there who has recently bought LBI and is willing to share the prices quoted by Infor. I want to compare prices and was looking for any users on LBI who are looking to buy or who have recently purchased itn and are willing to share the price quotes. Thanks in advance, Ruma
0 1022
06/03/2014 8:51 AM
3 Replies and 1114 Views Listing the bursting rights by user  1114  3 Started by  Donna I can create a number of reports from Lawson FS and RS but I can't find a table that has the rights for a user. Does a table that has this information exist Example User Department Rights Me 1000 2000 3000
3 1114
by  DonnaJump to last post
05/23/2014 3:13 PM
8 Replies and 1509 Views Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?  1509  8 Started by  mlarson I'm trying to figure out how to link the data in the ENBATREE table of the EFS schema to the report data found in the ERS schema via a SQL query. After analyzing the database tables I have not seen anything from the EFS schema that can be linked to the REPORTID field which is used by the majority of the tables in the ERS schema. Any help would be appreciated, thanks!
8 1509
by  JeffCozzagJump to last post
05/15/2014 4:20 PM
10 Replies and 1730 Views Emailing LBI reports  1730  10 Started by  Law123 We are converting from Crystal Enterprise to LBI for reporting. Crystal Enterprise allows reports to be emailed to an outlook distribution group (i.e. Accounting). This reduces report maintenance because I don't have to do anything when new accounting personnel are hired. The outlook groups are maintained by others. Can LBI reports be emailed to an outlook group If so, how I've assigned email addresses to individual users, but I don't know how to get LBI to email to an outlook group. ...
10 1730
by  Greg MoellerJump to last post
05/15/2014 10:04 AM
1 Replies and 1163 Views Upgrade to RAS 2011  1163  1 Started by  Greg Moeller So, the other evening we upgraded our production LBI Reporting Services instance to The next morning we had some issues with specifically parameter containing drillable reports. I opened a call with Infor and was basically told that this was a known issue with SAP, and we (Infor) are waiting for the next SP to see if that will fix the issue(s). Has anyone else took the leap yet to RAS 2011 Are you experiencing the same symptoms I find it hard to believe that we are the only...
1 1163
by  Greg MoellerJump to last post
05/15/2014 10:02 AM
3 Replies and 1599 Views Convert LBI Reports to Business Objects  1599  3 Started by  Donna We have LBI, BOE and an assortment of other distribution tools for our organization. We would like to consolidate to one distribution tool. Currently we use LBI for Lawson Reporting and BOE for EPIC. We are considering using BOE for Lawson, EPIC/ Clarity, Midas and Kronos reporting. However, we have over 600 reports published in LBI and would like to make contact with other Lawson users who are using BOE for Lawson Reports to discuss their satisfaction level with BOE. Thank you. Donna...
3 1599
by  DonnaJump to last post
05/12/2014 5:04 PM
2 Replies and 844 Views Printing multiple parameter descriiption value fields  844  2 Started by  Donna I have a formula that will print the values in my parameter that accepts multiple parameter values. My user would like to see the parameter descripton field instead. Does anyone have a suggestion for accessing the parameter description value field Thank you. Donna
2 844
by  DonnaJump to last post
05/12/2014 4:58 PM
9 Replies and 2595 Views Infor Lawson BI - Add new dashboard  2595  9 Started by  Robby Am I missing something in this new setup Infor Lawson BI This is a new setup and the install included quickstart items, Now, I have to add a new dashboard and I can't find the little icon that is supposed to be to the right of all the dashboard tabs. Is there something I'm missing in this new setup or do you think there is a security setting that has been missed which is hiding this from me I have 'LBIAdmin' authority... Help! Robby.........
9 2595
by  Greg MoellerJump to last post
05/09/2014 1:25 PM
2 Replies and 1275 Views LBI and Cognos  1275  2 Started by  Nabil Hello All, I'm wondering if any of you has heard if Infor is planning to move away from SAP Crystal to IBM Cognos thanks! Nabil
2 1275
by  NabilJump to last post
05/06/2014 12:04 PM
1 Replies and 940 Views Assign user with an access to multiple reports in Lawson LBI  940  1 Started by  Yugandhar Can anyone of you tell how to assigh the security access for an user to access multiple reports other than assigning report user to individual reports
1 940
by  Law123Jump to last post
05/06/2014 11:21 AM
1 Replies and 1029 Views Automating Rights Import  1029  1 Started by  George Graham I thought I had seen this posted before but cannot find it. Has anyone been able to automate the import of rights from a csv We want to automate the setup of LBI users entirely and know we can update the tables directly - but would rather use the import option if there is a way to automate it.
1 1029
by  Ken CarleyJump to last post
04/09/2014 2:51 PM
0 Replies and 895 Views LBI Data Source of Instance Queue Connection  895  0 Started by  khart I know where the Instance folder is on our reporting server but what type of report am I able to use that data source It is useful in any way Example: D:\LawsonDocuments\12_reportName\Instances
0 895
03/31/2014 4:26 PM
6 Replies and 1415 Views Report Auditing  1415  6 Started by  Greg Moeller Since we are now on version 10 of LBI, I've been asked by several users to turn report auditing on. I've successfully done that and written an audit report with some of the information that the users wanted in it. My question comes in here. I turned auditing on at 17:00 on the 13th, now at 10:30 on the 15th, I already have 340 rows in the table. Can I just have my DBA strip the table of older data from the table going forward Maybe just keep a quarters worth, and strip the rest
6 1415
by  Greg MoellerJump to last post
03/28/2014 4:01 PM
3 Replies and 1105 Views Display burst rights info in report?  1105  3 Started by  mikeP I have a Crystal report that's bursting properly now; most users see all info, one group sees a reduced set. Is there a way I can report some bursting rights info on the report, so I could place a header similar to: 'Report limited to Fund xxx', where the xxx comes from the filter criteria placed on the right's imported structure Thanks, Mike .
3 1105
by  mikePJump to last post
03/19/2014 12:08 PM
0 Replies and 969 Views Transaction Counts  969  0 Started by  FireGeek21 We need to report on the number of transactions we do. I can get transaction history from the HRHISTORY. How can I determine all the transactions done directly on HR11.1, HR13.1, BN32.1 and HR13.3 Thanks!
0 969
03/12/2014 4:21 PM
4 Replies and 841 Views Bursting, How can I restrict one group and allow the rest  841  4 Started by  mikeP Just getting started with bursting. We have a report that should generally be available to all, but handful of users (all in their own custom group) should only see one work location. Playing with a simple test report, I created the element, structure, and right to restrict that group. What I can't figure out is how to allow another group full access. The only thing that jumps out is to give them a right that is NOT= 'qwzyxs' or some other string that I know is not a real work location....
4 841
by  amynelsonJump to last post
03/12/2014 1:30 PM
2 Replies and 1233 Views Dashboard module to new tab?  1233  2 Started by  BarbaraS Is there any easy way to move an entire module from one dashboard tab to a new tab without recreating the module and all of the links Thanks Barbara
2 1233
by  mark.cookJump to last post
03/10/2014 8:03 AM
3 Replies and 1458 Views PO Comment database location  1458  3 Started by  dukeslater On PO20.1 there is a button labeled 'Add Cmt'. Clicking it brings up an Attachments window, and under 'Comments to Print on Purchase Orders' I need to find both the Title and Text fields. My usual methods of tracking this down don't seem to work for this one. Thanks in advance for any direction you can provide.
3 1458
by  dukeslaterJump to last post
03/07/2014 2:19 PM
2 Replies and 1197 Views Import Devices not working  1197  2 Started by  Mary Porter We were upgraded to LBI Version10. and I have not been able to import devices since then. I am using the same device template as we did before. I checked the device type naming (from an earlier post by Greg Moeller) and still can't upload. My error is: - An error occured when attempting to save the device to the database. - The device import has completed with errors. Some devices might not have been imported. Nothing imported. Infor said they can't duplicate update to the next...
2 1197
by  Mary PorterJump to last post
02/13/2014 6:38 PM
4 Replies and 1984 Views MM280 DistributionReport  1984  4 Started by  Nicole M Hi I'm looking to recreate the MM280 Mateerials Report using a query, not necessarily with Crystal Reports. Probably with SQL or another tool I have. Has anyone already recreated this If so, can you provide the tables and fields I would need.
4 1984
by  Gary GastaJump to last post
02/07/2014 8:36 AM
4 Replies and 1343 Views Report Schedules  1343  4 Started by  Robby Good Morning, We're running LBI (201105) 9-0-4-2-137 We have reports scheduled nearly everyday, normally they run with no problems. However, yesterday and this morning, no reports ran as scheduled. (I have a Smart Note to alert me to this fact). Due to the nature of the reports, I needed to send them manually (so payroll could get their data). While running a couple manually, the rest of them 'started' back up and sent themselves out!! Is there a mechanism within the schedul...
4 1343
by  RobbyJump to last post
02/06/2014 3:55 PM
3 Replies and 2034 Views ODBC 64-bit driver  2034  3 Started by  Mary Porter We have Oracle_11g 32 bit drivers installed but new client machines are being installed as 64bit. Where's the best place to get 64 bit drivers
3 2034
by  Mary PorterJump to last post
02/05/2014 5:53 PM
3 Replies and 1941 Views Bursting PDF to Dashboard  1941  3 Started by  Whitney Johnson Trying to burst a PDF to the LBI Dashboard. The PDF report has both COMPANY AND ACCT UNIT as bursting elements, but I don't get the drop down box to assign COMPANY OR ACCT UNIT for Element for field mapping. Can a PDF file be burst through LBI Thanks, Whitney
3 1941
by  Roger2010Jump to last post
01/28/2014 10:35 AM
2 Replies and 1414 Views Invoke report from url and have it sent as email attachment  1414  2 Started by  TRK Hi Another challenge. I've been trying to find the information in the documentation, but my skills are not high enough to get anything useful out of the, should I say, limited documentation available. Background From time to time I receive a file, which is then imported into a SQL DB via a Powershell script. The data imported should then be sent to the user in a nice looking report, which is attached as PDF in an e-mail. The report is created and takes 3 parameters: sender, messageID and ...
2 1414
by  TRKJump to last post
01/23/2014 12:41 AM
0 Replies and 971 Views Crystal Report for S3 Fiancial Rolls  971  0 Started by  Randy Not sure if this belongs here or S3 Financials. Has anyone had success customing reports that would whow accounting unit summary at highest level, then the next levels downward I'm thinking the dbo.GLCONSOL table would be a start, but wonder if anyone has completed this and how
0 971
01/13/2014 3:51 PM
1 Replies and 1042 Views Exporting as CSV creating duplicates?  1042  1 Started by  thummel1 Hi, I have a Crystal Report that contains a sub report. This report is loaded in LBI. When I choose to export the report as CSV, first, it takes like an hour (annoying), second, it creates a duplicate or triple (or more) records for each record on the report. Why are the repeated records occuring on the report We have other reports that are exported this way that also have sub reports. Any insight would be much appreiated! Thanks! Tania Hummelgard
1 1042
by  Dave CurtisJump to last post
01/04/2014 6:21 AM
3 Replies and 1771 Views LBI Current User Formula???  1771  3 Started by  DanH I am publishing an EE roster of 6000 people. I need the Manager running the report to only view employees they have access to. I concatenated a few fields where the IDs are to make the field i want touse to check the manager . i already tried the formula below: CurrentCEUsername in {Manager String} in lbi and crystal but it did not pull the data. In LBI, it kept asking the users for a default ID and PW. Can someone please assist Thanks!
3 1771
by  Greg MoellerJump to last post
01/02/2014 1:39 PM
2 Replies and 1275 Views Burting by LBI Report content  1275  2 Started by  Ruma Malhotra We have several reports that are needing to be bursted by a field on the report and we are on version 10 of LBI but we are experiencing that bursting is not working right and wanted to check with anybody out there what their experiences have been Thanks in advance.
2 1275
by  Susan PrenticeJump to last post
12/23/2013 3:24 PM
6 Replies and 1409 Views Refreshing server for LBI  1409  6 Started by  Ronnie I have a question and I am getting no where currently with infor support. I just want information from them but they are not getting anywhere with me and just wanting me to run fiddler etc. I feel this is an easy solution. Here is the issue. In our portal we have an area that uses xml pages. I have made a change to one of the xml files where it now uses a fully qualified URL instead of a short URL name. example...inside the XML file there is host=''><URL><!&91;CDATA&91;...
6 1409
by  Alex TsekhanskyJump to last post
12/22/2013 4:50 PM
3 Replies and 1170 Views LBI without Lawson Portal  1170  3 Started by  Kate Liamero We are having our systems moved and I want LBI to be available longer than lawson. We usually log into lbi via a link in the lawson portal but I do have the direct url for lbi. I am being told they are not sure if LBI can be up without the portal We don't want to allow users to log into the portal because we don't want any data changed. Our LBI is strictly reports only. As long as the database is up can users log directly into LBI and run their reports without the portal also being accessib...
3 1170
by  Kate LiameroJump to last post
12/13/2013 9:14 AM
0 Replies and 1143 Views LBI RFP  1143  0 Started by  Daniel Does anyone have an example RFP for implementation of Lawson Business Intelligence that they could share. Thanks for any assistance.
0 1143
12/09/2013 11:16 AM
38 Replies and 4119 Views Upgrading to LBI 10  4119  38 Started by  ric9d Has anyone here upgraded from LBI 9.05 to 10 I called Infor Support and was told that it would take 1-2 hours, maybe even less. And that it would just be an install on top of the existing one. Is it really that easy What should I look out for We are only upgrading LBI to 10. None of the other Lawson apps would be upgraded. Is that possible recommended Thanks!
38 4119
by  Chris MartinJump to last post
12/05/2013 11:45 AM
1 Replies and 970 Views Lawson report AM260 to Crystal cannot use csv  970  1 Started by  Donna The AM260 report is still in the user's print manager and he needs an excel file created. I just received this call 5 minutes ago. I used to 'crystallize' Lawson standard reports10 years ago but have not done it in recent memory. I rarely use OLEDB although I have it on my computer. Of course the users needs it tomorrow and I was going to be on PTO but I would still like to help if at all possible. I am searching for documentation on this that is newer than the article posted in the...
1 970
by  DonnaJump to last post
11/27/2013 10:04 AM
4 Replies and 1195 Views Default dashboard view  1195  4 Started by  Ronnie Ok...So I am setting up our Lawson dashboards for our Lawson 10 we are going to implement. We are coming from 9. Is there a way to set individual portal roles to have a certain dashboard tab show up as the main home tab that opens when they log in I have two created for our regular employees, but the additional tab is the one that is defaulting when they open up lawson. I have a main one created that I would like to default open when they log in. Where is this set
4 1195
by  RonnieJump to last post
11/12/2013 2:51 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 2 of 9 << < 12345 > >>

RSS Feed Available