Forums
 Topics
 Replies
 Last Post
180 Topics and 622 Replies Smart Notification  180  622
RE: Align Columns
by  Randy
12/13/2017 2:52 PM
180 622
RE: Align Columns
by  Randy
12/13/2017 2:52 PM
Search this forum:
Search
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 > >>
Topics
 Replies
 Views
 Last Post
8 Replies and 14693 Views How 2 Convert Quartz Scheduler date/times?  14693  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 14693
by  Greg MoellerJump to last post
07/15/2015 9:36 AM
4 Replies and 1246 Views Crystal report reading a csv file  1246  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 1246
by  DVJump to last post
07/14/2015 12:17 PM
0 Replies and 948 Views Crystal report reading a csv file  948  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 948
07/14/2015 11:12 AM
4 Replies and 1076 Views Report Run Log  1076  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 1076
by  Sue KnowltonJump to last post
07/01/2015 2:00 PM
1 Replies and 1118 Views Dashboards and bursting  1118  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 1118
by  Dave CurtisJump to last post
06/23/2015 11:35 AM
0 Replies and 756 Views Summarizing totals in main rpt for arrays in sub rpt  756  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 756
06/22/2015 2:02 PM
0 Replies and 955 Views Upgrade best practices?  955  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 955
06/17/2015 3:01 PM
2 Replies and 1702 Views oleDB Query Builder Error  1702  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 1702
by  Srini RaoJump to last post
06/17/2015 6:52 AM
10 Replies and 2050 Views Default Report Permissions  2050  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 2050
by  Greg MoellerJump to last post
06/16/2015 10:26 AM
2 Replies and 1229 Views Total Rewards Statement?  1229  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 1229
by  thummel1Jump to last post
06/08/2015 3:34 PM
1 Replies and 1323 Views Updating LBI to latest available version  1323  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 1323
by  Carl.SeayJump to last post
05/28/2015 7:59 PM
8 Replies and 1676 Views LBI Report Usage Statistics  1676  8 Started by  Donna We are cleaning up our dashboards and want to track the report usage. We are on LBI 10.2.0.0.126 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 1676
by  Greg MoellerJump to last post
05/15/2015 1:46 PM
2 Replies and 1257 Views not All LBI users show up in LBI  1257  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 1257
by  Xin LiJump to last post
05/07/2015 2:18 PM
1 Replies and 1182 Views Crystal-Financial Statements-Selecting the month  1182  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 1182
by  RandyJump to last post
04/29/2015 10:43 AM
0 Replies and 1203 Views LSR report not coming up  1203  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 1203
04/21/2015 4:35 PM
18 Replies and 5285 Views How do I report off of a derived field, specifically app.pmt-status?  5285  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 5285
by  John HenleyJump to last post
03/26/2015 10:11 AM
4 Replies and 1220 Views ODBC work on LBI 10.5?  1220  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 1220
by  ISO DanJump to last post
03/19/2015 12:09 PM
1 Replies and 913 Views HS15 data  913  1 Started by  Karen Ploof or is it generated on the fly
1 913
by  Karen PloofJump to last post
03/09/2015 12:58 PM
12 Replies and 2288 Views LBI to network share export  2288  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 2288
by  Joan HerzfeldtJump to last post
03/09/2015 12:38 PM
6 Replies and 1230 Views API and JDBC  1230  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 1230
by  Matthew NyeJump to last post
03/09/2015 11:45 AM
2 Replies and 1514 Views Report is Blank  1514  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 1514
by  Srini RaoJump to last post
02/20/2015 9:58 AM
1 Replies and 1157 Views LBI SSL Errors  1157  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 1157
by  Carl.SeayJump to last post
02/03/2015 1:07 PM
2 Replies and 1285 Views HR Department Name  1285  2 Started by  Alise Would anyone know from their experience what table contains the HR Department name
2 1285
by  AliseJump to last post
01/22/2015 9:45 AM
0 Replies and 1188 Views BackOffice Reports Not working  1188  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 1188
01/16/2015 9:46 AM
4 Replies and 1377 Views LBI back office reports do not work  1377  4 Started by  Xin Li After upgrade to LBI 10.4.2.0.231 RS, none of our Lawson back office report work. Anyone has any idea
4 1377
by  Xin LiJump to last post
01/15/2015 9:26 AM
1 Replies and 1431 Views MA236  1431  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 1431
by  mikePJump to last post
01/12/2015 10:17 AM
0 Replies and 1198 Views Crystal report hyperlink to detail crystal report  1198  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 1198
01/10/2015 12:06 AM
0 Replies and 810 Views Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction  810  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 810
12/12/2014 7:16 AM
1 Replies and 1187 Views LBI issue when last folder in LBI list deleted  1187  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 1187
by  DonnaJump to last post
12/01/2014 12:13 PM
6 Replies and 5014 Views Data Mart  5014  6 Started by  Lisa Stewart Since Lawson no longer offers a Datamart solution what are most customers using
6 5014
by  ssarawgiJump to last post
11/25/2014 12:44 PM
2 Replies and 1283 Views Report opens very slow  1283  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 1283
by  JanJump to last post
11/20/2014 2:56 PM
11 Replies and 1871 Views Published report does not run on a schedule  1871  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: com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: 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 1871
by  DonnaJump to last post
11/18/2014 11:04 PM
9 Replies and 1460 Views GLTRANS join to GLCHARTGTL - to obtain Account Description  1460  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 1460
by  AliseJump to last post
11/18/2014 12:39 PM
1 Replies and 1128 Views How to set the date parameter format to ddmmyyyy(UK format)?  1128  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 1128
by  Matthew NyeJump to last post
11/10/2014 4:42 AM
3 Replies and 2915 Views Error when running report in LBI (dashboard)  2915  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 2915
by  Beate Hughes-BrownJump to last post
11/06/2014 8:37 AM
5 Replies and 2056 Views Income statements using Crystal  2056  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 2056
by  MelissaJump to last post
10/29/2014 2:16 PM
13 Replies and 4153 Views Financial statement performance – RW100 as data source vs. Crystal direct to tables  4153  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 4153
by  MelissaJump to last post
10/29/2014 2:01 PM
1 Replies and 1406 Views RAS log on as account  1406  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 1406
by  Greg MoellerJump to last post
10/27/2014 3:25 PM
1 Replies and 1002 Views Securing Details report link from users  1002  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 1002
by  Matthew NyeJump to last post
10/13/2014 12:30 PM
0 Replies and 1592 Views windows authentication for LBI reports  1592  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 1592
09/25/2014 10:45 AM
0 Replies and 1185 Views LBI and Dynamic Parameters  1185  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 1185
09/24/2014 12:26 PM
1 Replies and 935 Views End User sees Parameters differently  935  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 935
by  thummel1Jump to last post
09/24/2014 7:57 AM
0 Replies and 872 Views LBI - support Signatures ( picture )  872  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 872
09/15/2014 5:00 AM
2 Replies and 2009 Views LBI Report Delivery Options  2009  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 2009
by  thummel1Jump to last post
09/12/2014 2:33 PM
5 Replies and 1529 Views LBI and Dynamic Parameters  1529  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 1529
by  thummel1Jump to last post
09/09/2014 11:45 AM
1 Replies and 1187 Views LBI RS table where report runtime is stored  1187  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 1187
by  Greg MoellerJump to last post
08/30/2014 10:11 AM
15 Replies and 3418 Views LBI Deployment from DEV to TEST to PROD  3418  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 3418
by  David BrittonJump to last post
08/27/2014 10:07 AM
2 Replies and 1481 Views Crystal Reports and OLEDB  1481  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 1481
by  mikePJump to last post
08/22/2014 3:09 PM
0 Replies and 1039 Views LT101 Supervisor Errors to LBI missing data  1039  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 1039
08/21/2014 3:04 PM
3 Replies and 1071 Views Scheduling limitations  1071  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 1071
by  Matthew NyeJump to last post
08/20/2014 1:14 PM
5 Replies and 1349 Views Date Stamp in PERSACTION table  1349  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 1349
by  MattJump to last post
08/15/2014 10:24 AM
13 Replies and 1723 Views LBI - Schedule a report with a parameter  1723  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 1723
by  RandyJump to last post
08/14/2014 9:13 AM
0 Replies and 976 Views Export report & append date to filename?  976  0 Started by  Jimmy Chiu Is there a way to export a report with a filename.date format Where the date is grabbed from the system time
0 976
08/01/2014 10:02 AM
27 Replies and 3318 Views Crystal Reports Will Not Refresh in Report Services  3318  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 3318
by  redankerJump to last post
07/24/2014 9:44 AM
8 Replies and 1311 Views Name Change Report  1311  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 1311
by  thummel1Jump to last post
07/23/2014 2:57 PM
0 Replies and 966 Views Bursting LBI report that has 5 subreports  966  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 966
07/23/2014 7:27 AM
1 Replies and 1248 Views Report Not Bursting As Expected  1248  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 9.0.4.2. 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 1248
by  thummel1Jump to last post
07/23/2014 7:07 AM
1 Replies and 1056 Views LBI report returns to Crystal parameter page  1056  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 9.0.4.2 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 1056
by  mikePJump to last post
07/15/2014 1:06 PM
16 Replies and 1832 Views Table for Report Schedule Names  1832  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 1832
by  Greg MoellerJump to last post
07/02/2014 10:16 AM
3 Replies and 2249 Views URL/link to AP150 Output  2249  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 2249
by  GiuliaJump to last post
06/23/2014 1:58 PM
4 Replies and 1178 Views LBI Report Owner change  1178  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 1178
by  Mary PorterJump to last post
06/20/2014 1:08 PM
0 Replies and 906 Views Incorporate GL Data in the MM280  906  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 906
06/19/2014 9:11 AM
0 Replies and 955 Views LBI Pricing  955  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 955
06/03/2014 8:51 AM
3 Replies and 1060 Views Listing the bursting rights by user  1060  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 1060
by  DonnaJump to last post
05/23/2014 3:13 PM
8 Replies and 1458 Views Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?  1458  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 1458
by  JeffCozzagJump to last post
05/15/2014 4:20 PM
10 Replies and 1617 Views Emailing LBI reports  1617  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 1617
by  Greg MoellerJump to last post
05/15/2014 10:04 AM
1 Replies and 1105 Views Upgrade to RAS 2011  1105  1 Started by  Greg Moeller So, the other evening we upgraded our production LBI Reporting Services instance to 10.3.1.0.68. 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 1105
by  Greg MoellerJump to last post
05/15/2014 10:02 AM
3 Replies and 1538 Views Convert LBI Reports to Business Objects  1538  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 1538
by  DonnaJump to last post
05/12/2014 5:04 PM
2 Replies and 805 Views Printing multiple parameter descriiption value fields  805  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 805
by  DonnaJump to last post
05/12/2014 4:58 PM
9 Replies and 2436 Views Infor Lawson BI - Add new dashboard  2436  9 Started by  Robby Am I missing something in this new setup Infor Lawson BI 10.2.0.0.126 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 2436
by  Greg MoellerJump to last post
05/09/2014 1:25 PM
2 Replies and 1222 Views LBI and Cognos  1222  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 1222
by  NabilJump to last post
05/06/2014 12:04 PM
1 Replies and 885 Views Assign user with an access to multiple reports in Lawson LBI  885  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 885
by  Law123Jump to last post
05/06/2014 11:21 AM
1 Replies and 983 Views Automating Rights Import  983  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 983
by  Ken CarleyJump to last post
04/09/2014 2:51 PM
0 Replies and 855 Views LBI Data Source of Instance Queue Connection  855  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 855
03/31/2014 4:26 PM
6 Replies and 1374 Views Report Auditing  1374  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 1374
by  Greg MoellerJump to last post
03/28/2014 4:01 PM
3 Replies and 1066 Views Display burst rights info in report?  1066  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 1066
by  mikePJump to last post
03/19/2014 12:08 PM
0 Replies and 938 Views Transaction Counts  938  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 938
03/12/2014 4:21 PM
4 Replies and 818 Views Bursting, How can I restrict one group and allow the rest  818  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 818
by  amynelsonJump to last post
03/12/2014 1:30 PM
2 Replies and 1197 Views Dashboard module to new tab?  1197  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 1197
by  mark.cookJump to last post
03/10/2014 8:03 AM
3 Replies and 1428 Views PO Comment database location  1428  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 1428
by  dukeslaterJump to last post
03/07/2014 2:19 PM
2 Replies and 1160 Views Import Devices not working  1160  2 Started by  Mary Porter We were upgraded to LBI Version10.1.12.0.179 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 1160
by  Mary PorterJump to last post
02/13/2014 6:38 PM
4 Replies and 1909 Views MM280 DistributionReport  1909  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 1909
by  Gary GastaJump to last post
02/07/2014 8:36 AM
4 Replies and 1305 Views Report Schedules  1305  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 1305
by  RobbyJump to last post
02/06/2014 3:55 PM
3 Replies and 1977 Views ODBC 64-bit driver  1977  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 1977
by  Mary PorterJump to last post
02/05/2014 5:53 PM
3 Replies and 1913 Views Bursting PDF to Dashboard  1913  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 1913
by  Roger2010Jump to last post
01/28/2014 10:35 AM
2 Replies and 1368 Views Invoke report from url and have it sent as email attachment  1368  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 1368
by  TRKJump to last post
01/23/2014 12:41 AM
0 Replies and 936 Views Crystal Report for S3 Fiancial Rolls  936  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 936
01/13/2014 3:51 PM
1 Replies and 1017 Views Exporting as CSV creating duplicates?  1017  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 1017
by  Dave CurtisJump to last post
01/04/2014 6:21 AM
3 Replies and 1725 Views LBI Current User Formula???  1725  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 1725
by  Greg MoellerJump to last post
01/02/2014 1:39 PM
2 Replies and 1239 Views Burting by LBI Report content  1239  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 1239
by  Susan PrenticeJump to last post
12/23/2013 3:24 PM
6 Replies and 1363 Views Refreshing server for LBI  1363  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 1363
by  Alex TsekhanskyJump to last post
12/22/2013 4:50 PM
3 Replies and 1133 Views LBI without Lawson Portal  1133  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 1133
by  Kate LiameroJump to last post
12/13/2013 9:14 AM
0 Replies and 1111 Views LBI RFP  1111  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 1111
12/09/2013 11:16 AM
38 Replies and 4044 Views Upgrading to LBI 10  4044  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 4044
by  Chris MartinJump to last post
12/05/2013 11:45 AM
1 Replies and 935 Views Lawson report AM260 to Crystal cannot use csv  935  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 935
by  DonnaJump to last post
11/27/2013 10:04 AM
4 Replies and 1145 Views Default dashboard view  1145  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 1145
by  RonnieJump to last post
11/12/2013 2:51 PM
10 Replies and 1637 Views LBI v 10.1.x cosmetic change  1637  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 1637
by  Matthew NyeJump to last post
11/11/2013 10:48 AM
3 Replies and 1040 Views LBI Uploading RIGHTS using CSV file --- Description is not uploadable?  1040  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 1040
by  JeanneSJump to last post
11/06/2013 12:51 PM
0 Replies and 1029 Views Querying PR35.2 versus PR36  1029  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 1029
11/04/2013 8:13 AM
15 Replies and 3654 Views What to use for reporting financials in S3  3654  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 3654
by  Chris MartinJump to last post
11/01/2013 12:56 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