Last Post
179 Topics and 618 Replies Smart Notification  179  618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
179 618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 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 915 Views Crystal report reading a csv file  915  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 915
07/14/2015 11:12 AM
4 Replies and 1049 Views Report Run Log  1049  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 1049
by  Sue KnowltonJump to last post
07/01/2015 2:00 PM
1 Replies and 1085 Views Dashboards and bursting  1085  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 1085
by  Dave CurtisJump to last post
06/23/2015 11:35 AM
0 Replies and 736 Views Summarizing totals in main rpt for arrays in sub rpt  736  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 736
06/22/2015 2:02 PM
0 Replies and 920 Views Upgrade best practices?  920  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 920
06/17/2015 3:01 PM
2 Replies and 1652 Views oleDB Query Builder Error  1652  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 1652
by  Srini RaoJump to last post
06/17/2015 6:52 AM
10 Replies and 1999 Views Default Report Permissions  1999  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 1999
by  Greg MoellerJump to last post
06/16/2015 10:26 AM
2 Replies and 1193 Views Total Rewards Statement?  1193  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 1193
by  thummel1Jump to last post
06/08/2015 3:34 PM
1 Replies and 1215 Views Updating LBI to latest available version  1215  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 1215
by  Carl.SeayJump to last post
05/28/2015 7:59 PM
8 Replies and 1638 Views LBI Report Usage Statistics  1638  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 1638
by  Greg MoellerJump to last post
05/15/2015 1:46 PM
2 Replies and 1210 Views not All LBI users show up in LBI  1210  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 1210
by  Xin LiJump to last post
05/07/2015 2:18 PM
1 Replies and 1143 Views Crystal-Financial Statements-Selecting the month  1143  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 1143
by  RandyJump to last post
04/29/2015 10:43 AM
0 Replies and 1154 Views LSR report not coming up  1154  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 1154
04/21/2015 4:35 PM
18 Replies and 5202 Views How do I report off of a derived field, specifically app.pmt-status?  5202  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 5202
by  John HenleyJump to last post
03/26/2015 10:11 AM
4 Replies and 1171 Views ODBC work on LBI 10.5?  1171  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 1171
by  ISO DanJump to last post
03/19/2015 12:09 PM
1 Replies and 870 Views HS15 data  870  1 Started by  Karen Ploof or is it generated on the fly
1 870
by  Karen PloofJump to last post
03/09/2015 12:58 PM
12 Replies and 2237 Views LBI to network share export  2237  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 2237
by  Joan HerzfeldtJump to last post
03/09/2015 12:38 PM
6 Replies and 1171 Views API and JDBC  1171  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 1171
by  Matthew NyeJump to last post
03/09/2015 11:45 AM
2 Replies and 1430 Views Report is Blank  1430  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 1430
by  Srini RaoJump to last post
02/20/2015 9:58 AM
1 Replies and 1121 Views LBI SSL Errors  1121  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 1121
by  Carl.SeayJump to last post
02/03/2015 1:07 PM
2 Replies and 1214 Views HR Department Name  1214  2 Started by  Alise Would anyone know from their experience what table contains the HR Department name
2 1214
by  AliseJump to last post
01/22/2015 9:45 AM
0 Replies and 1133 Views BackOffice Reports Not working  1133  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 1133
01/16/2015 9:46 AM
4 Replies and 1323 Views LBI back office reports do not work  1323  4 Started by  Xin Li After upgrade to LBI RS, none of our Lawson back office report work. Anyone has any idea
4 1323
by  Xin LiJump to last post
01/15/2015 9:26 AM
1 Replies and 1356 Views MA236  1356  1 Started by  bernfc10 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 1356
by  mikePJump to last post
01/12/2015 10:17 AM
0 Replies and 1130 Views Crystal report hyperlink to detail crystal report  1130  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 1130
01/10/2015 12:06 AM
0 Replies and 780 Views Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction  780  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 780
12/12/2014 7:16 AM
1 Replies and 1138 Views LBI issue when last folder in LBI list deleted  1138  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 1138
by  DonnaJump to last post
12/01/2014 12:13 PM
6 Replies and 4953 Views Data Mart  4953  6 Started by  Lisa Stewart Since Lawson no longer offers a Datamart solution what are most customers using
6 4953
by  ssarawgiJump to last post
11/25/2014 12:44 PM
2 Replies and 1239 Views Report opens very slow  1239  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 1239
by  JanJump to last post
11/20/2014 2:56 PM
11 Replies and 1790 Views Published report does not run on a schedule  1790  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 1790
by  DonnaJump to last post
11/18/2014 11:04 PM
9 Replies and 1383 Views GLTRANS join to GLCHARTGTL - to obtain Account Description  1383  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 1383
by  AliseJump to last post
11/18/2014 12:39 PM
1 Replies and 1073 Views How to set the date parameter format to ddmmyyyy(UK format)?  1073  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 1073
by  Matthew NyeJump to last post
11/10/2014 4:42 AM
3 Replies and 2865 Views Error when running report in LBI (dashboard)  2865  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 2865
by  Beate Hughes-BrownJump to last post
11/06/2014 8:37 AM
5 Replies and 2018 Views Income statements using Crystal  2018  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 2018
by  MelissaJump to last post
10/29/2014 2:16 PM
13 Replies and 4082 Views Financial statement performance – RW100 as data source vs. Crystal direct to tables  4082  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 4082
by  MelissaJump to last post
10/29/2014 2:01 PM
1 Replies and 1341 Views RAS log on as account  1341  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 1341
by  Greg MoellerJump to last post
10/27/2014 3:25 PM
1 Replies and 978 Views Securing Details report link from users  978  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 978
by  Matthew NyeJump to last post
10/13/2014 12:30 PM
0 Replies and 1548 Views windows authentication for LBI reports  1548  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 1548
09/25/2014 10:45 AM
0 Replies and 1140 Views LBI and Dynamic Parameters  1140  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 1140
09/24/2014 12:26 PM
1 Replies and 897 Views End User sees Parameters differently  897  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 897
by  thummel1Jump to last post
09/24/2014 7:57 AM
0 Replies and 833 Views LBI - support Signatures ( picture )  833  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 833
09/15/2014 5:00 AM
2 Replies and 1963 Views LBI Report Delivery Options  1963  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 1963
by  thummel1Jump to last post
09/12/2014 2:33 PM
5 Replies and 1441 Views LBI and Dynamic Parameters  1441  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 1441
by  thummel1Jump to last post
09/09/2014 11:45 AM
1 Replies and 1135 Views LBI RS table where report runtime is stored  1135  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 1135
by  Greg MoellerJump to last post
08/30/2014 10:11 AM
15 Replies and 3369 Views LBI Deployment from DEV to TEST to PROD  3369  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 3369
by  David BrittonJump to last post
08/27/2014 10:07 AM
2 Replies and 1453 Views Crystal Reports and OLEDB  1453  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 1453
by  mikePJump to last post
08/22/2014 3:09 PM
0 Replies and 983 Views LT101 Supervisor Errors to LBI missing data  983  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 983
08/21/2014 3:04 PM
3 Replies and 1051 Views Scheduling limitations  1051  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 1051
by  Matthew NyeJump to last post
08/20/2014 1:14 PM
5 Replies and 1303 Views Date Stamp in PERSACTION table  1303  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 1303
by  MattJump to last post
08/15/2014 10:24 AM
13 Replies and 1614 Views LBI - Schedule a report with a parameter  1614  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 1614
by  RandyJump to last post
08/14/2014 9:13 AM
0 Replies and 937 Views Export report & append date to filename?  937  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 937
08/01/2014 10:02 AM
27 Replies and 3237 Views Crystal Reports Will Not Refresh in Report Services  3237  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 3237
by  redankerJump to last post
07/24/2014 9:44 AM
8 Replies and 1273 Views Name Change Report  1273  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 1273
by  thummel1Jump to last post
07/23/2014 2:57 PM
0 Replies and 919 Views Bursting LBI report that has 5 subreports  919  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 919
07/23/2014 7:27 AM
1 Replies and 1217 Views Report Not Bursting As Expected  1217  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 1217
by  thummel1Jump to last post
07/23/2014 7:07 AM
1 Replies and 1016 Views LBI report returns to Crystal parameter page  1016  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 1016
by  mikePJump to last post
07/15/2014 1:06 PM
16 Replies and 1768 Views Table for Report Schedule Names  1768  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 1768
by  Greg MoellerJump to last post
07/02/2014 10:16 AM
3 Replies and 2210 Views URL/link to AP150 Output  2210  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 2210
by  GiuliaJump to last post
06/23/2014 1:58 PM
4 Replies and 1143 Views LBI Report Owner change  1143  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 1143
by  Mary PorterJump to last post
06/20/2014 1:08 PM
0 Replies and 866 Views Incorporate GL Data in the MM280  866  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 866
06/19/2014 9:11 AM
0 Replies and 920 Views LBI Pricing  920  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 920
06/03/2014 8:51 AM
3 Replies and 1026 Views Listing the bursting rights by user  1026  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 1026
by  DonnaJump to last post
05/23/2014 3:13 PM
8 Replies and 1426 Views Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?  1426  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 1426
by  JeffCozzagJump to last post
05/15/2014 4:20 PM
10 Replies and 1550 Views Emailing LBI reports  1550  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 1550
by  Greg MoellerJump to last post
05/15/2014 10:04 AM
1 Replies and 1068 Views Upgrade to RAS 2011  1068  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 1068
by  Greg MoellerJump to last post
05/15/2014 10:02 AM
3 Replies and 1509 Views Convert LBI Reports to Business Objects  1509  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 1509
by  DonnaJump to last post
05/12/2014 5:04 PM
2 Replies and 772 Views Printing multiple parameter descriiption value fields  772  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 772
by  DonnaJump to last post
05/12/2014 4:58 PM
9 Replies and 2340 Views Infor Lawson BI - Add new dashboard  2340  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 2340
by  Greg MoellerJump to last post
05/09/2014 1:25 PM
2 Replies and 1194 Views LBI and Cognos  1194  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 1194
by  NabilJump to last post
05/06/2014 12:04 PM
1 Replies and 854 Views Assign user with an access to multiple reports in Lawson LBI  854  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 854
by  Law123Jump to last post
05/06/2014 11:21 AM
1 Replies and 948 Views Automating Rights Import  948  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 948
by  Ken CarleyJump to last post
04/09/2014 2:51 PM
0 Replies and 833 Views LBI Data Source of Instance Queue Connection  833  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 833
03/31/2014 4:26 PM
6 Replies and 1347 Views Report Auditing  1347  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 1347
by  Greg MoellerJump to last post
03/28/2014 4:01 PM
3 Replies and 1040 Views Display burst rights info in report?  1040  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 1040
by  mikePJump to last post
03/19/2014 12:08 PM
0 Replies and 914 Views Transaction Counts  914  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 914
03/12/2014 4:21 PM
4 Replies and 800 Views Bursting, How can I restrict one group and allow the rest  800  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 800
by  amynelsonJump to last post
03/12/2014 1:30 PM
2 Replies and 1180 Views Dashboard module to new tab?  1180  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 1180
by  mark.cookJump to last post
03/10/2014 8:03 AM
3 Replies and 1401 Views PO Comment database location  1401  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 1401
by  dukeslaterJump to last post
03/07/2014 2:19 PM
2 Replies and 1141 Views Import Devices not working  1141  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 1141
by  Mary PorterJump to last post
02/13/2014 6:38 PM
4 Replies and 1861 Views MM280 DistributionReport  1861  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 1861
by  Gary GastaJump to last post
02/07/2014 8:36 AM
4 Replies and 1292 Views Report Schedules  1292  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 1292
by  RobbyJump to last post
02/06/2014 3:55 PM
3 Replies and 1937 Views ODBC 64-bit driver  1937  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 1937
by  Mary PorterJump to last post
02/05/2014 5:53 PM
3 Replies and 1887 Views Bursting PDF to Dashboard  1887  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 1887
by  Roger2010Jump to last post
01/28/2014 10:35 AM
2 Replies and 1326 Views Invoke report from url and have it sent as email attachment  1326  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 1326
by  TRKJump to last post
01/23/2014 12:41 AM
0 Replies and 911 Views Crystal Report for S3 Fiancial Rolls  911  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 911
01/13/2014 3:51 PM
1 Replies and 995 Views Exporting as CSV creating duplicates?  995  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 995
by  Dave CurtisJump to last post
01/04/2014 6:21 AM
3 Replies and 1694 Views LBI Current User Formula???  1694  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 1694
by  Greg MoellerJump to last post
01/02/2014 1:39 PM
2 Replies and 1214 Views Burting by LBI Report content  1214  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 1214
by  Susan PrenticeJump to last post
12/23/2013 3:24 PM
6 Replies and 1323 Views Refreshing server for LBI  1323  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 1323
by  Alex TsekhanskyJump to last post
12/22/2013 4:50 PM
3 Replies and 1105 Views LBI without Lawson Portal  1105  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 1105
by  Kate LiameroJump to last post
12/13/2013 9:14 AM
0 Replies and 1083 Views LBI RFP  1083  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 1083
12/09/2013 11:16 AM
38 Replies and 4001 Views Upgrading to LBI 10  4001  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 4001
by  Chris MartinJump to last post
12/05/2013 11:45 AM
1 Replies and 914 Views Lawson report AM260 to Crystal cannot use csv  914  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 914
by  DonnaJump to last post
11/27/2013 10:04 AM
4 Replies and 1113 Views Default dashboard view  1113  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 1113
by  RonnieJump to last post
11/12/2013 2:51 PM
10 Replies and 1600 Views LBI v 10.1.x cosmetic change  1600  10 Started by  Greg Moeller In LBI version 10, we are noticing that the dashboards background is a deep blue/navy blue and the selected dashboard text is black. Anyone know which specific file this is controlled from We'd like to change the selected dashboard color.
10 1600
by  Matthew NyeJump to last post
11/11/2013 10:48 AM
3 Replies and 1019 Views LBI Uploading RIGHTS using CSV file --- Description is not uploadable?  1019  3 Started by  ric9d I checked the CSV file format specs to upload rights, it doesn't have one for 'Description'. Does anyone have any idea Thanks in advance.
3 1019
by  JeanneSJump to last post
11/06/2013 12:51 PM
0 Replies and 1009 Views Querying PR35.2 versus PR36  1009  0 Started by  clb393 is there any way i can query the data on each form separately If not, is there a field indicator which would distinguish the two Thanks, Chris
0 1009
11/04/2013 8:13 AM
15 Replies and 3539 Views What to use for reporting financials in S3  3539  15 Started by  Melissa I'm curious what others are using for reporting financials. we have been live on lawson since january and the report writer in lawson is great for the style 1 type balance sheet and P&L reports. However, being in healthcare we have a lot of need for slicing and dicing our accouting unit information and building all the calculations and groups etc that have to go into creating it is tedious. and then keeping track of them all in case something changes is almost impossible. Crystal reports is a ni...
15 3539
by  Chris MartinJump to last post
11/01/2013 12:56 PM
1 Replies and 1222 Views Direct reports in non-Lawson report  1222  1 Started by  Greg Moeller Investigating ways to deliver a report via LBI to a select group of managers within our IT department based on their direct reports... Problem is, this is not a Lawson report, it is coming from our Help Desk application database. The database contains employee names. We've hard-coded the names and got a report that works, but it is all manual now as we have to go in and select the manager, run the report, export to pdf, and repeat for the next manager. Can I just build a ri...
1 1222
by  Greg MoellerJump to last post
10/30/2013 3:10 PM
3 Replies and 1244 Views The Value of RW100  1244  3 Started by  JonA Can someone give me an overview of RW100 How is it used From what information I've gathered it seems to be a Financial reporting tool. Does it have any applications for supply chain/procurement What information can it provide that I can't get with Crystal Is it easier than Crystal
3 1244
by  JonAJump to last post
10/30/2013 2:31 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