Forums
 Topics
 Replies
 Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
Search this forum:
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 1 of 512345 > >>
Topics
 Replies
 Views
 Last Post
3 Replies and 6008 Views Crystal Labor Utiilization Report to publish in LBI    6008  3 Started by  Jan This is a general information question on labor utilization reporting. I'm converting an existing custom Lawson back office report which shows labor utilization by company/cost center/job.&160; This is an old paper report that was earlier published to eBroadCast.&160; Some user issues were that it could not be effectively exported into an Excel spreadsheet for them to work with more effectively.&160; We have a few different versions of this back office report - one reports the numbers per p...
3 6008
by  JanJump to last post
01/06/2010 9:05 AM
0 Replies and 88 Views Exporting crystal report in text format?  88  0 Started by  Lance Jurgensen Am I missing something in my system I don't seem to have an option to export a report run from LBI to Text The output to CSV is similar but it surrounds each line with quote marks. Anyone know of a way around this Thanks, -Lance LBI 10-6-17-0-339 Crystal RAS 2011
0 88
09/12/2018 4:24 PM
1 Replies and 159 Views Summarized Transactions - Payroll  159  1 Started by  O. Johnson I've been able to write SQL to get from the GLTRANS Summarized Transactions back to the invoices on the AP side, but now being asked to do the same on the PR side. Anyone have any experience in getting from a GLTRANS Summarized Transaction back to the PR transactions that make up the Summarized Transaction Thanks!
1 159
by  Ragu RaghavanJump to last post
09/05/2018 6:53 AM
4 Replies and 2205 Views LBI and Crystal 2016, Windows 10 (UPDATED)  2205  4 Started by  Kelly H We are in the process of migrating to Windows 10. One concern is that we are all using Crystal 2008 for our LBI reports and Lawson reporting. Our tech person is concerned about Crystal 2008 and Windows 10 not working well together. is anyone using Crystal 2013 for LBI Have there been any issues As of 11/29/17- it appears we can only upgrade to Crystal 2016. Anyone have Crystal 2016 and Windows 10 working with Lawson
4 2205
by  SRHarrisJump to last post
07/19/2018 12:10 PM
3 Replies and 753 Views List of active employees at a certain point in time.  753  3 Started by  agersh I am looking to produce a list of all employees that had an active employee status at a specific point in time (specific date). For example, all employees that had an active employee status on 10/1/2015. Any idea of the SQL query that would produce these results
3 753
by  agershJump to last post
06/11/2018 9:32 AM
4 Replies and 597 Views Deliver LBI report to Email  597  4 Started by  thummel1 I am exploring various delivery options of LBI reports to customers. One option I am exploring is the ability to deliver a scheduled LBI report to an email delivery device. We currently have that functionality in place for Smart Notes; however, this is not an option for this particular need. I am wondering if similar functionality exists within Reporting Services If yes, are there resources to learn about configuration We are on version 10.6.13.0.326 for reporting services. Thank you!
4 597
by  Dave CurtisJump to last post
05/30/2018 3:00 PM
3 Replies and 915 Views Lost Data Settings  915  3 Started by  Katy Prince Old reports have these data settings: Datasource in Report: Override Datasource Default User ID Default Password Confirm Password When Viewing Report: But when I try to publish a new report all of the above is missing... Anyone else ever run into this See attached.
3 915
by  Greg MoellerJump to last post
04/16/2018 1:05 PM
3 Replies and 667 Views Moving Lawson Documents  667  3 Started by  Donna I write reports and publish them but have never set up LBI. We have new administrators and are not sure how to point LBI from one location to another to find the Lawson Documents folder. We have done all the back up and copying for the folder but are looking for some guidance on the LBI technical side. Thank you. Donna Shelton
3 667
by  DonnaJump to last post
04/12/2018 3:05 PM
2 Replies and 1920 Views QLIK  1920  2 Started by  Donna We are in the process of implementing QLIK. We currently use LBI and Crystal Reports but will be moving some of our reporting over to QLIK. QLIK will be used at our hospital for some EPIC, Clarity, Lawson and other hospital subsystems.reporting. If anyone else especially in healthcare is using QLIK or in the process of implementing QLIK we would like to make contact with them and maybe eventually create a Lawson QLIK forum.
2 1920
by  NabilJump to last post
03/20/2018 10:55 AM
1 Replies and 911 Views Convert PR261 to easy to read format  911  1 Started by  thummel1 Has anyone had the need to replicate the PR261 report but in LBI, with the goal of being to be able to read it in a simple format, export to Excel, and run any necessary calculations against the fields for auditing purposes Our payroll department uses this report to ensure the taxable wages are appearing correctly, but the format is not ideal for auditing purposes. Payroll has requested a format that would display one row per employee, with each deduction code appearing in it's own column with ...
1 911
by  Jason BeardJump to last post
03/09/2018 3:22 PM
1 Replies and 1359 Views Upgrade for LBI v10 - Infor BI, BIRST or other  1359  1 Started by  NatalieD October 2016, we upgraded to Lawson v10 and LBI v10. We report heavily on operational/detail level data throughout our Supply Chain department. We primarily use Crystal Report files posted to LBI to facilitate data dumps and summary information to our end users (data to review and update inventory reorder theory, item conversions, etc). We regularly use Lawson Add-ins for large record changes so our field demand for reporting is quite large. For years we have struggled with record limitations in...
1 1359
by  NabilJump to last post
02/07/2018 3:15 PM
2 Replies and 1942 Views Lawson Smart Reports - LSR Designer  1942  2 Started by  dkester I'm new to LSR and LSR Designer. We're just starting to test some of our reports using LSF Designer and unable to get a template created for PR260. I've been using the user guide, LSRDUG_10.0.3.0_W_01 to configure the designer but still unable to link the report to a template. The default, CU201 that INFOR provided looks pretty straight forward, but I'm unable to get another template setup. My goal is to create a barebones report for PR260 and apply our company logo, nothing fancy or complic...
2 1942
by  dkesterJump to last post
01/10/2018 3:55 PM
3 Replies and 2269 Views LBI vs. Infor Birst  2269  3 Started by  Nabil Infor is promoting Birst as the LBI replacement. They said (in a Demo) that Infor Reporting is not the future direction and LBI is to be replaced by Birst. I'm wondering if any of you are considering this move We are just short of 200 Crystal Reports and some 30-40 Smartnotes. All of these will need to converted to Birst reports or Alerts. Thanks, Nabil
3 2269
by  JeremyJump to last post
01/02/2018 11:57 AM
0 Replies and 270 Views Output to CSV does not retain  270  0 Started by  thummel1 Since our upgrade to v10, we have several scheduled reports in LBI that are not retaining their output type settings. One specific report is set to save in CSV format in the Report Options, with the default Output Type saved as Comma Separate Values (CSV) and only Comma Separated Value is checked in 'Allowed Output types'. Yet when the report runs on the schedule, the scheduled instances are generating in RPT format. I've tried deleting the schedule and adding back in, deleting the report an...
0 270
12/01/2017 8:36 AM
10 Replies and 2854 Views LBI Schedule Disappear Randomly  2854  10 Started by  Dave Curtis Over a year ago we started having this random issue with LBI report schedules randomly disappearing. We have tried to find a reason why and tie it to some event but have not been able to. What is additionally head scratching is that not ALL of the schedule is gone. If I look in the table that has the schedule triggers (ejs_triggers: This is the info on the second part of the schedule with delivery info etc.) I will find the schedule but the actual schedule in ejs_cron_triggers is gone. So ...
10 2854
by  Joan HerzfeldtJump to last post
11/22/2017 9:15 AM
8 Replies and 1805 Views Report will not burst  1805  8 Started by  Donna This is very strange. I have another version of the same report with the same bursting rights structure that runs successfully but the newly published report runs if I remove bursting rights but displays as a blank repot once bursting rights are added. We even republished the report with a new report ID but it will not burst or even display any data once the bursting is added.
8 1805
by  DonnaJump to last post
10/11/2017 5:15 PM
0 Replies and 384 Views Survey Functionality  384  0 Started by  thummel1 I am wondering if Lawson V10 has the ability to create a survey for employees in Employee Self Service
0 384
09/05/2017 2:09 PM
3 Replies and 2012 Views Remove MNR PO Lines from Report  2012  3 Started by  brupp Hello - I have a Crystal Report of open PO lines where PO qty < Received qty & have been asked to only include those lines without an invoice matched to the line. I found POLINE.MATCHED_NO_REC but do not understand the numeric values & they're not listed in the guru data dictionary. Does anyone know the values & their meaning, & will setting this field achieve the desired result in my Crystal Report Thanks.
3 2012
by  Kat VJump to last post
09/05/2017 8:18 AM
0 Replies and 416 Views Infor Enhancement to APAUDIT  416  0 Started by  NatalieD Currently, when we audit changes to our AP10.1 and AP10.2 address changes using APAUDIT, the table also shows address changes to PO10. Auditing AP10.1 and AP10.2 address changes is required by our internal audit department. We utilize field ID's 5, 6, 7, 8, 9, 10, 11, 12, 18, 19, 20, 21, 22, and 23. We are showing false audit findings due to the merged data in APAUDIT. Please reference Infor incident 10826136 for troubleshooting with Infor tech and their test findings. Currently no way...
0 416
08/21/2017 6:51 AM
15 Replies and 3282 Views Guru Data Dictionary  3282  15 Started by  FireGeek21 Does anyone know information about accessing the data dictionaries on here Going to Tech -> Data Dictionary -> clicking on 9.0 for tables, getting an error - 404 - File or directory not found. They have been helpful for us in the past. Thanks!
15 3282
by  John HenleyJump to last post
08/03/2017 2:29 PM
1 Replies and 1626 Views UTC Conversions on Date Range Functions  1626  1 Started by  Joan Herzfeldt I'm accessing a database that has dates stored in UTC so even though 'an action was taken' on 6/30/2017 20:12:00 Central time (where I'm located) , due to the conversion to UTC this record does not show up on the report if I use ' in the LastFullMonth' because it converts to 7/1/2017 01:12:00 UTC. I know how to replace LastFullMonth with two separate date parameters. What I want to know is... Is there a way to convert any of the 'Date Range Functions' (ie: LastFullMonth) to take the time zone...
1 1626
by  John HenleyJump to last post
08/03/2017 10:29 AM
7 Replies and 3263 Views LBI On Demand-passing in authuser value  3263  7 Started by  petec We are using the LBI RS ers/ersRequestHandler.jsp to create report bookmarks in Portal for remote EMSS users. Has anyone been able to use &SelFormula or perhaps &LawUserID to pull the authuser value (user who has logged in) For example, if user 3436 logs in, I want that valued passed as a parameter into the LBI\Crystal report so the user only sees their data. Let me know. Thanks. (need it for Portal and eventually workspace, these users won't have LSO).
7 3263
by  Who Da PhillyJump to last post
07/20/2017 8:21 AM
0 Replies and 408 Views ReportWriter GL Income Statement 12 Mo.  408  0 Started by  Ron Soclof How is it best to create formulas to have columns for the 11 prior months to CPAMT. I tried CPAMT-1 which just subtracts 1 from the current period total. I tried CP-1 which displays the prior month number I was trying to get the previous months totals for those prior months. Thanks
0 408
06/27/2017 10:50 AM
2 Replies and 2134 Views LBI Server Out of Memory  2134  2 Started by  thummel1 We have been experiencing a routine weekly outage with LBI. Users receive the message 'LBI Server Out of memory'. We were informed that it could be due to the volume of activity on the RAS Server, and suggested remedies included changing reports to not open in a Crystal Report viewer so that it bypasses the RAS Server. That was done on the reports that seemed most problematic yet the issue continues. Another suggestion was to rebuild more complex reports residing in Crystal in other systems ...
2 2134
by  Greg MoellerJump to last post
05/30/2017 4:46 PM
1 Replies and 1692 Views LBI Delete Parameter Values  1692  1 Started by  Katman When updating an LBI report, I cannot delete a value in the parameters drop down list. Steps to Recreate (See attached image): Edit LBI Report Click Maintain Parameters under Data Filtering Select Parameter to update In Available Values box, check the value you want to delete. Click Delete button. Nothing happens. I am the report owner. I have also logged in using Lawson master account. I still cannot delete a value from the list. &91;img&93;/Portals/0/...
1 1692
by  KatmanJump to last post
05/30/2017 1:54 PM
2 Replies and 1721 Views Verifying LBI Maintain Rights  1721  2 Started by  Survivor We are moving from on-premise to the Cloud without realizing that we were expected to maintain LBI security from that initial cut. We have some reports which are bursted. It appears that some people were partially set up. Does anyone have any SQL they use to confirm LBI Rights match
2 1721
by  Joan HerzfeldtJump to last post
03/21/2017 8:38 AM
6 Replies and 2904 Views Framework Services Tools Dashboard  2904  6 Started by  Robby I can un-check the 'All' box, but can't save it. In our dev version which is 10.0.0.134, I can, but only if I 'play' with the IE compatibility settings. I've got a ticket in with Infor, but the development team says that it is working as designed. That's a terrible design! And what did they do between 10.0.0.134 and 10.4.0.0.190 that limited this ability. Anyway, who else is running 10.4.0.0.190 and what are you doing One of my thoughts was - perhaps there's a setting during installation th...
6 2904
by  SurvivorJump to last post
03/20/2017 11:25 AM
7 Replies and 2234 Views LBI Tools Tab Reporting My Reports  2234  7 Started by  Donna We have tried creating new lists maintaining existing lists and have not been successful in allowing both of us access to all the reports. I have access to all of my reports and all reports for any prior LBI administrators including Lawson but cannot see the reports she has published to LBI. The new LBI administrator can see some of my reports and all of her reports but there are gaps. Our IT department and Lawson support can't seem to figure this out either but it causes some time consuming ...
7 2234
by  lmackinJump to last post
03/01/2017 12:17 PM
1 Replies and 1565 Views LBI Backoffice to GL90 security  1565  1 Started by  texasInstruments Has anyone been successful in securing GL90 when used as a destination from LBI Backoffice RW100 reports drill around We need to be able to limit by accounting unit based on what rights they have in LBI when they arrive at the GL90 form from LBI. Currently, a user can type in different accounting unit numbers and inquire on GL90 to see information that they are not given in LBI rights. We have tested security rules that do limit access based on a security group value but I am thinking that w...
1 1565
by  texasInstrumentsJump to last post
02/20/2017 4:17 PM
0 Replies and 795 Views Paramertized Crystal Reports freezes  795  0 Started by  anatoli.s Hi lawson gurus, We are using Crystal Report with parameters, and sometimes user is not able to open that report (the reports stuck at 'Please wait' before showing parameters page). ERS log shows the CrystalEngine exceptions (the sample exception text below), and I assume that could be fixed by Guest user re-configuration (details at http://www-01.ibm.com/support/docview.wssuid=swg21443725) However, I didn't find any similar options in Lawson Reporting Services Administration. Could you a...
0 795
02/14/2017 6:49 AM
1 Replies and 1696 Views Embed <LAW> tag  1696  1 Started by  Katy Prince I took the training on this so long ago and I can't remember how to embed the <LAW> tag in a Crystal Report so that I can burst it in LBI.
1 1696
by  NatalieDJump to last post
02/08/2017 10:14 AM
1 Replies and 1795 Views Report  1795  1 Started by  kweixel-eb I'm not an admin, but in accounting with some database programming experience. I've been using the S3 Query Wizard, but would like to do aggregate functions on large data sets (>1million txns). Is there a free report writer that works with Lawson Or, is there another way to do this Thanks
1 1795
by  dcaianiJump to last post
02/06/2017 9:08 AM
3 Replies and 2325 Views Item Locn usage using ICHISTORY - date range?  2325  3 Started by  NatalieD I am attempting to rewrite an existing report that calculates the usage for all items at location with SOH >0. It's using the ICHISTORY table and is YTD data only. I've been requested to make this a rolling 12 month scheduled report. The Usage field is a case formula (see below). I'm not sure how to correct to allow for the months from the year prior to the parameter year. As in, if they enter parameter year = 2016 and parameter month = 1, how can Feb-Dec 2015 be included to make the 12 month...
3 2325
by  NatalieDJump to last post
02/03/2017 1:35 PM
1 Replies and 1670 Views Edit Report List under Maintain Reports  1670  1 Started by  Donna We are using the Maintain Reports All list because we have multiple LBI administrators who cannot see each other's reports but we need the report number that LBI assigns when you publish a report displayed in the list. We are looking for a way to add the report number to the list.
1 1670
by  NatalieDJump to last post
02/03/2017 9:17 AM
1 Replies and 1931 Views Infor BI versus LBI versus other solutions  1931  1 Started by  CMNew Does anybody have experience using Infor BI versus Lawson BI We purchased Lawson BI but have'nt implemented it. Our rep is recommending that we switch to Infor BI instead and maintains that Lawson BI wont continue to be supported. We have another team here who thinks we should ditch the Infor solution entirely and start using Tableau instead which the company has'nt purchased yet but they have researched it and think its a preferred solution for reporting all round Any thoughts or input i...
1 1931
by  RandyJump to last post
01/24/2017 1:10 PM
0 Replies and 564 Views Cleanup user rights  564  0 Started by  Xin Li We have a lot users used to be LBI users. Even though they are no longer LBI users, their user rights are still left behind in LBI. Is there any simple way to remove their user right in LBI
0 564
01/17/2017 10:10 AM
0 Replies and 729 Views LBI report linked to Excel file  729  0 Started by  NatalieD Has anyone successfully linked an Excel file to a published LBI report We regularly use Crystal Reports linked to an Excel file to help pull reports for a specific set of items. We populate the Excel file with the list of items and then run the file which is linked by the field. I've been trying to publish a report to LBI that would allow our end users to populate an excel file and then run a report off LBI (avoiding the need to have Crystal Reports but giving them the flexibility to run ...
0 729
01/16/2017 8:41 AM
1 Replies and 1861 Views Change user language in LawsonFS database  1861  1 Started by  TRK Hi forum When creating a new user in LBI, the default language is for some reason set to Danish :blink: As we are a company with locations several places in the world it would be much more beneficial if the language was English. How to either set the default language for new users to English or to update the language preference directly in the database See attachment of the setting in question in the web interface. Thanks in advance, Thomas
1 1861
by  TRKJump to last post
12/28/2016 3:06 AM
1 Replies and 2062 Views Crystal Report does not run  2062  1 Started by  Survivor There are a few Crystal reports which do not run and displays the message 'The report you requested requires further information.' It prompts for the user and password. There is only one data source, and it has been overridden with an ODBC connection used by other reports. It works for some people but not others. How can this be resolved
1 2062
by  Jimmy ChiuJump to last post
12/23/2016 8:16 AM
4 Replies and 2300 Views Republishing reports not working LBI 10.6  2300  4 Started by  Lance Jurgensen We have a new LBI 10.6 install, data migrated from 10.4 and then upgraded. Pretty much everything is working except we can not republish reports. The screen is just a bunch of empty boxes and not all labels are visible etc. See attachment for details. Anyone seen this after an upgrade Thanks, -Lance
4 2300
by  Jimmy ChiuJump to last post
12/23/2016 8:09 AM
3 Replies and 2147 Views Enhancement requests 9809 & 9813 - suggest you vote!  2147  3 Started by  NatalieD ER 9809 Description Currently there is no way to report by either group, list, or attribute. It would be helpful to export this information to Excel to help with analysis and maintenance. Proposed Solution Add capability to extract/report on LBI reports by group, list, or attribute. Adding capability to export this information to Excel would be useful. ER 9813 Description Add capability to search for LBI reports. Allowing search by wildcard would be very useful. Right now looking...
3 2147
by  Kelly HJump to last post
12/23/2016 8:03 AM
1 Replies and 1914 Views Crystal Report - Help Adding Fields to Existing Query  1914  1 Started by  Chris-T Good afternoon, Let me start by stating that while I'm a DB person at my local hospital, I have never worked with Lawson data before. I've been requested to create an employee history report and thanks to the talented folks here, I have very nearly what I need. Would someone be able to assist me in adding two fields to this query - I'm looking to add the employee's prior supervisor and current supervisor (much like the current position and prior position). I believe the d...
1 1914
by  Jeff ShumateJump to last post
11/28/2016 6:42 PM
4 Replies and 2839 Views RNI Crystal  2839  4 Started by  Mark Silva Which tables and fields are best and any joins to create a crystal report to display RNI. We can see  PORECLINE ENT-REC-QTY – the Receipt Quantity on PO30  MAINVDTL ENTERED-QTY – The Invoice Quantity on MA43  POLINE VBUY-UNIT-CST – The PO Line Unit Cost So we know if we take Receipt Quantity less Entered Quantity we get RNI Quantity. We can take this against PO Line Unit Cost to get RNI amount. B...
4 2839
by  JonAJump to last post
11/28/2016 1:57 PM
0 Replies and 780 Views Report will not pull up  780  0 Started by  Survivor There is one person who is having an issue pulling up any Crystal reports. The pop-up flashes a URL with the web server and another with the LBI server. I noticed the error logs have: The Viewer could not be created because the Device Client type is not supported How do you resolve that issue
0 780
11/23/2016 2:44 PM
0 Replies and 629 Views Determine if an employee received a promotion/demotion  629  0 Started by  agersh I have been asked to build a Crystal Report to track employee status, position, department changes, and promotions/demotions for a select group of employees. Using the HRHISTORY table I am track an employee’s status, position and department changes. But I am having trouble determining what to look at to determine if an employee received a promotion/demotion.
0 629
11/17/2016 2:01 PM
0 Replies and 753 Views Need GLTRANS and FBDETAIL view  753  0 Started by  Donna I am preparing a crystal report that uses GLTRANS for the expense column and provides totals by system code that tie back to all the sub systems. The report also displays budget in a sub report at the account level but the report performance is terrible. There is a significant percentage of accounts that do not have expense transactions but are budgeted. Does anyone have a view or sql query that might be helpful in obtaining all the populated records for each table The view does not nee...
0 753
11/15/2016 10:30 PM
11 Replies and 3447 Views Searching for BANK-STATUS field  3447  11 Started by  ric9d Hello all, I am looking for the BANK-STATUS field for my report. Please help as I dont know where to get it from (table and field names pls!). The possible values are 'Reconciled', 'Issued', etc. THANKS! Ric
11 3447
by  Greg DeyJump to last post
11/11/2016 5:00 PM
9 Replies and 5229 Views LBI to Infor BI  5229  9 Started by  Greg Moeller Just got an email from my PM stating we need to get to Infor BI for Lawson. A PDF attachment to this email indicates How to move from LBI to Infor BI for Lawson A migration consists of two parts: • A license migration, and • a technical migration. License migration Customers just need to provide the existing LBI and Viewpoint license SKUs to their sales reps. There is a standard conversion document available that provides the resulting Infor BI for Lawson licenses...
9 5229
by  Vijay SJump to last post
11/08/2016 8:28 AM
1 Replies and 1946 Views POAGMTPART  1946  1 Started by  NatalieD Hello - I'm trying to build a crystal report that will show the contracted price for an item based on the IC12 location company. We have instances where we have more than one vendor agreement based on one for a specific participant company. When I pull the contract tables in (POVAGRMTHD, POVAGRMTLN and POAGMTPART) they report duplicates the item for every possible contract. I'm trying to narrow down to have it only show the vendor agreement based on the location company using the agreement parti...
1 1946
by  Joan HerzfeldtJump to last post
11/03/2016 10:41 AM
3 Replies and 1999 Views Unable to view LBI Report  1999  3 Started by  Vijay S All, We went to LBI 10.2 , RAS - 11. When we try to publish a report , we are getting message published successfully, But when we Run the report , we are getting the following error: ------------------------------------------------------------------------------------------ | | 'com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The system cannot find the path specified. ---- Error code:-2147467259 &91;CRSDK00000000&93; Error code name:failed' ...
3 1999
by  Vijay SJump to last post
10/25/2016 9:10 AM
6 Replies and 2252 Views Crystal Report for PO23 Orphaned Items  2252  6 Started by  brupp Hello - I have a Crystal Report for POINTERFAC with ORIGIN_CD=IC to catch those items that do not add to or create a PO due to having the wrong replenishment vendor (or whatever the reason). It works fine except for 6 items that I cannot find either in PO23 or on a PO100 error report. I just need them to go away & cannot figure out the required action in Lawson. Any ideas Thanks.
6 2252
by  bruppJump to last post
09/16/2016 3:00 PM
0 Replies and 652 Views Parameters and Scheduled Instances  652  0 Started by  thummel1 Hi, I am working in Lawson version 9.0.1. Can a scheduled report have parameters added to it For instance, we have a scheduled report that contains many employee demographics. The end users would like the ability to select the Employee Last Name and/or Employee ID so only those matching records will display, versus the alternative of exporting a large report and filtering/sorting for the needed record. I know there is the option within LBI to create a parameter, and I tested this option ...
0 652
09/12/2016 1:38 PM
6 Replies and 2267 Views Cross Reference All LBI Reports to Security  2267  6 Started by  Survivor Is there a way to create a list of all LBI reports and the security tied to each Some of our security is by individual user and some by groups.
6 2267
by  SurvivorJump to last post
08/19/2016 11:42 AM
5 Replies and 2428 Views Internet Explorer 11 and LBI Version 9.0.4  2428  5 Started by  Fred Pinto Hi Everyone, I just upgraded a user from XP to Win7 and now their BI web page is all screwed up. I tried the compatibility view but I get the same screen. I've attched a screen shot. Any ideas
5 2428
by  Fred PintoJump to last post
08/10/2016 10:34 AM
1 Replies and 2521 Views Crystal Reporting in the Cloud  2521  1 Started by  imty Hello All, We currently use Crystal Reports with Lawson for financial reporting. Our current Production database is on a dedicated in-house server. The reports seem to run fine in this environment. We are now migrating to the Cloud and have modified the data source for all CR to point to the Cloud database. The database is called the LSLMDB in the Cloud Server. We are noticing a drastic drop in the run time of some reports especially ones where data is being retrieved for both the current and...
1 2521
by  Jimmy ChiuJump to last post
08/05/2016 1:47 PM
4 Replies and 3102 Views Crystal report not refreshing  3102  4 Started by  BMcKay 1. Modified Crystal report, did save without data 2. Republished on dashboard via LBI>Report Details 3. LBI>Report Details>Data Settings, chose the datasource and entered user id/password. Now I go to Dashboard, click on report and it has old data in it. I'm new at both Crystal and LBI. Beth
4 3102
by  NatalieDJump to last post
07/28/2016 9:25 AM
2 Replies and 2228 Views LBI 10.5  2228  2 Started by  LoriN Has anyone moved to Infor BI for Lawson Version 10.5 or 10.6 I am trying to determine what the migration process is for this. I know we need to fill out an order form to switch from LBI to IBI. I have tried to get additional information from our Account Exec, but not had much luck with the information I am looking for. I see that LBI 10.4 is end of maintenance on 2/28/17. What was the process like for conversion Did you need to have consulting, or was the conversion fairly seamless. ...
2 2228
by  Greg MoellerJump to last post
07/27/2016 10:52 AM
3 Replies and 2293 Views Updating user rights in LBI within IE11  2293  3 Started by  Kelly H We recently upgraded to IE11 and since then we can't update user rights in LBI. When we use IE9, it still works fine. Has anyone else experienced this and figured out a work around The only work around we have right now is to reimage a machine and put IE9 on that machine rather than IE11. And so far this is the only issue we are having in IE11 that we have found so far.
3 2293
by  Greg DeyJump to last post
07/07/2016 9:46 AM
1 Replies and 2179 Views Bursting Reports on Dashboard  2179  1 Started by  Basia We currently have several reports on our LBI dashboard that are bursted by user (LAWSONRS_CurrentUser). When a user runs the bursted report, it displays data that is assigned to them however, when they click on the refresh button in the report (after it ran the first time), they are prompted to select a user name (making the bursting obsolete). This allows them to view data of the entire organization since they are able to select any user in the drop down menu. Has anyone ever experie...
1 2179
by  Dave CurtisJump to last post
06/30/2016 9:04 AM
3 Replies and 2313 Views Refresh RS SN FS Databases  2313  3 Started by  Giulia We have upgraded our LBI to 10.4 and our Lawson to 10. We are currently testing and plan to go live in May. In the mean time we are adding Reports and Smart Notes in our current production databases and publishing them to dashboards. To avoid manually keeping the two databases in sync (creating and publishing these new items in both environments), is there a tool or script that will refresh the upgraded RS SN and FS databases with the current production RS SN and FS databases without impacting t...
3 2313
by  Greg MoellerJump to last post
06/28/2016 11:40 AM
2 Replies and 2236 Views ICTRANS Location w-Name  2236  2 Started by  brupp Hello - I have a Crystal Report with ICTRANS.FROM_TO_LOC & I need to add the name of the location to the report. Sometimes this is a par location & sometimes it is a requesting location. It is working with our par locations that have IC81 headers using ICLOCATION, but I'm losing the requesting locations since those are in RQ01/REQLOC. Any suggestions My knee jerk reaction is to add our req locs to IC81 as a header only but I believe these will create ghost IC02's which may cause an en...
2 2236
by  bruppJump to last post
06/17/2016 8:17 AM
0 Replies and 1226 Views Item/Vendor report  1226  0 Started by  NatalieD I'm trying to write a Crystal Report that has ITEMMAST and POITEMVEN to show all the items in the item master as well as any PO13 information. When I pull in APVENMAST to pull in the vendor name I have to filter out a specific vendor group. When I do this, it eliminates any IC11 records that don't have a PO13. Any suggestions SELECT 'ITEMMAST'.'ITEM_GROUP', 'ITEMMAST'.'ITEM', 'ITEMMAST'.'DESCRIPTION', 'ITEMMAST'.'DESCRIPTION2', 'ITEMMAST'.'INVEN_MAJCL', 'ITEMMAST'.'INVEN_MINCL', 'ITEMMAST'....
0 1226
06/16/2016 3:26 PM
1 Replies and 2256 Views 7.1.5 Lawson Insight GL / Fin.  2256  1 Started by  edj Using an old Lawson Insight version, 7.1.5 on iSeries/AS400. A user was recently changed from an AP group to Financial/GL but something must have been missed because while the user can run a financial report, they cannot view it so as to move it to an active print outq. I am not very familiar with Lawson user setup, and anyone that was has moved on. I'm out of ideas as to where or how this permission/authority is granted. I can view the spooled output in the outq and move it to print, but the u...
1 2256
by  edjJump to last post
06/14/2016 12:08 PM
3 Replies and 2266 Views Excel Exports format incorrectly in LBI  2266  3 Started by  Donna It has always been a challenge to get some of our more complex reports to export with correct EXCEL formatting in LBI but now newly published reports have some real issues with the columns when exported. It appears that the exported report totally ignores the columns in the published Crystal report. These same reports export beautifully when directly exported from Crystal to Excel outside of LBI. I reached out to a peer who is also a consultant and he is having the same problem. Reports that...
3 2266
by  DonnaJump to last post
06/02/2016 3:26 PM
2 Replies and 2100 Views PO Spend Validation  2100  2 Started by  NatalieD Hello - Any thoughts on the best approach or screen in Lawson to help validate a PO spend report Ideally I would like to be able to have a number I can compare the amount of PO spend within a time period.
2 2100
by  NatalieDJump to last post
05/19/2016 10:02 AM
5 Replies and 2290 Views Crystal Par Stock Out Report  2290  5 Started by  bcarmichael99 I am looking for a way to use a crystal report to show when items stock out for our par locations. I have tried querying multiple different ways but everytime I do, it throws off the number because we have updated the par level. I need a way to include whatever the par level was at the time the count was completed. Any help would be greatly appreciated.
5 2290
by  JonAJump to last post
05/18/2016 11:47 AM
1 Replies and 2389 Views Oracle ODBC Driver Configuration Error  2389  1 Started by  JonA I'm trying to set up my my ODBC connection for Crystal on a new pc (Windows 7, Oracle version 12.1.0) but I'm getting this error: Testing Connection SQLState=08004 &91;Oracle&93;&91;ODBC&93;&91;Ora&93;ORA-12154: TNS:could not resolve the connect identifier specified When I compare the ODBC driver config and tnsnames.ora file to my current pc (Windows XP, Oracle version 11g) they look identical. And my connection test is successful on this pc. Any ideas
1 2389
by  JonAJump to last post
05/12/2016 2:28 PM
2 Replies and 2114 Views Table Joins - MMDIST & GL  2114  2 Started by  brupp Hello - I am trying to build a Crystal Report for Inventory transactions - I have everything in place except for descriptions for AU's. I have GLMASTER, GLNAMES & GLCHARTDTL available. I'm only getting results for one of our companies. I've played with the joins but no success. Perhaps I'm missing a parameter - any suggestions
2 2114
by  bruppJump to last post
05/09/2016 10:47 AM
2 Replies and 2196 Views Items and unit price  2196  2 Started by  Deleted User Hello - I am trying to build a Crystal Report for all IC11 items along with their unit price. .What table can I use for unit price If I use ICTRANS I get multiple records for same item with different unit price. Thanks for your help.
2 2196
by  Kat VJump to last post
05/09/2016 8:53 AM
2 Replies and 2095 Views IC11 and vendor data  2095  2 Started by  NatalieD I'm trying to create a Crystal report that will list ALL of my IC11 records and then list the PO13 records for the item. I have itemmast leftouter to POITEMVEN and am OK. When I try to link APVENMAST to POITEMVEN to get the vendor name. We have two vendor groups and one has to be filtered out - this seems to be the when I loose all IC11 records that do not have PO13 records (no vendor group). If I remove the vendor group record select, the report duplicates based on the vendor ID if the vendor n...
2 2095
by  NatalieDJump to last post
05/06/2016 7:11 AM
6 Replies and 3265 Views List of bursting rights, elements and users  3265  6 Started by  Donna What tables have the bursting information fields Thank you. Donna
6 3265
by  Lance KelleyJump to last post
05/03/2016 2:59 PM
1 Replies and 2152 Views need documentation on publishing on LBI  2152  1 Started by  NatalieD Hi! I am new to LBI and I'm having trouble understanding how the rights for each user and group relates to how a report is published and linked on LBI. Does anyone have any documentation they would be willing to share to help me out I've been able to republish and keep everything going but I'm having trouble with setting up published reports to get the published report match the rights to the dashboard it is linked. LBI Reporting Services 10.1.0.0.110 Much appreciated!
1 2152
by  JonAJump to last post
04/22/2016 8:24 AM
1 Replies and 2310 Views Future of LBI  2310  1 Started by  Kelly H We are currently on LBI 10. In the past we have heard issues around some functionality going away in LBI 11. There is a post on the Lawson community pages that talks about lBI moving to OLAP instead of Crystal Has there been any road maps shown that indicate where LBI is headed
1 2310
by  Shane JonesJump to last post
04/16/2016 6:50 AM
1 Replies and 2022 Views How to add a custom table to lawson data dictionary version 9.0.0.1  2022  1 Started by  apsnaveen How to add a custom table to lawson data dictionary version 9.0.0.1
1 2022
by  mikePJump to last post
04/14/2016 10:32 AM
1 Replies and 2146 Views Print to a network printer?  2146  1 Started by  Lance Jurgensen I have a request to print a scheduled report on a network printer and I am finding the 'documentation' lacking on Infor Extreme... I have the device type setup and I can see the HelloWorld....pdf files getting created in the temp directory. Getting 'Unable to retrieve content from '{0}'. when running the delivery test.
1 2146
by  Lance JurgensenJump to last post
04/06/2016 10:56 AM
9 Replies and 2798 Views Links on dashboard (LBI) will not launch  2798  9 Started by  JonA We have a couple users that when they click on the links on one of our LBI dashboards, nothing happens. If they log into a different pc it works fine. So this leads me to think it's a setting on the pc. IT has verified that Lawson security, IE version and compatibility settings are fine. The links on other dashboards work as expected. Anyone have a similar issue
9 2798
by  EthanJump to last post
03/23/2016 5:28 PM
5 Replies and 2464 Views PERSACTION Report build  2464  5 Started by  thummel1 Has anyone attempted to build a report using the PERSACTION table that would list all employees in the table, that includes their current demographic information (e.g. current Process Level, Dept, Job Code, User Level, FTE, others...) and also display the same demograhpics of what they are transferring to (new Process Level, Dept, Job Code, User Level, FTE, others... ). The table appears to be built in a way that is not very conducive to easy reporting. The goal of this report is to replace a...
5 2464
by  Dave CurtisJump to last post
03/23/2016 7:36 AM
6 Replies and 5123 Views Crystal and PRSAGDTL.EFFECT_DATE  5123  6 Started by  Maria I am tying to pull the max EFFECT_DATE frm the PRSAGDTL table in Crystal and cannot find a formula or command that will do this. Does anyone have any ideas or has had an issue with this that can help me out. I would appeciate any and all help. Thanks Maria
6 5123
by  mikePJump to last post
03/21/2016 12:18 PM
1 Replies and 1995 Views MSCM Signature  1995  1 Started by  john5 I have a request for data from MSCM to show deliveries, show it was delivered to and also the signatures that were captured. I can gather all the needed data, I see the bitmap field for the signature but want to convert that to the signature to show on a report. Has anyone done this that can share some thoughts on how to code this Thank You.
1 1995
by  Greg MoellerJump to last post
03/10/2016 10:23 AM
5 Replies and 2177 Views Report for LBI reports posted and publishing/Report ID  2177  5 Started by  NatalieD I'm trying to create one report that will tell me the location of all my published reports on LBI dashboards and what the correlating publishing numbers. I have two separate reports using ERS_Reports (enter publishing to get rpt name) and ENPBATREE (location of all reports including dashboard and module name) but can't find a way to link them together. Any thoughts
5 2177
by  DonnaJump to last post
03/03/2016 2:56 PM
0 Replies and 894 Views AP150 invoices put on hold  894  0 Started by  Deleted User Hello all, I am looking for the logic(criteria) for invoices put on credit hold on AP150 for my report. Please help as I dont know where to get it from (table and field names pls!). Thanks
0 894
02/29/2016 7:33 AM
3 Replies and 2520 Views PERSACTION-Position Number?  2520  3 Started by  thummel1 I am building a report designed to show various field that will be changing in the PERSACTION table. One of the fields I need to display is the Position Number, before and after. I can see where the 'After' is (PERSACTION.NEW_VALUE_7), but I am not sure the best way to display the 'before'. I can see the Process Level and Department as their own data fields, but not Position, which is important because an employee can have up to 5 positions. Any suggestions on how to display (e.g. data field...
3 2520
by  pbelskyJump to last post
02/03/2016 5:03 PM
3 Replies and 2482 Views Freight Data Output to Text File  2482  3 Started by  JonA I need someone well versed in SQL to check my script for syntax and structure. I can read scripts and understand for the most part what a script was designed to do but this is the first one I've built. I created this one by starting with Crystal and reverse engineering other examples and lots of Google searches. The purpose of this script is to create a text file of freight expense history (we use AOC codes) for the past 7 days and file name should be MIDMIC-COMP-YYYYMMDD.txt where YYMMDD is ...
3 2482
by  JonAJump to last post
02/03/2016 2:08 PM
4 Replies and 2430 Views Dashboard Missing  2430  4 Started by  Kelly H We have users that have been able to see one of the dashboards in LBI for quite some time. All of the sudden some of them cant see it. But some are able to. I have checked the sharing on the dashboard,as well as the various reports within the dashboard. The user is a part of a role that has access to that dashboard. I tried adding just his user ID to that access, but it still didnt work. He has tried it in IE and Chrome. It was initially one user, but now we have an another user state they also ...
4 2430
by  Kelly HJump to last post
02/02/2016 2:38 PM
0 Replies and 932 Views MA236 Criteria  932  0 Started by  Kidd Kasper Hello all, I have resources that would like to have a Crystal Report in LBI that essentially duplicates MA236. I've tried to pick through the logic of the program to pull all the criteria that it's using. Although I know programming logic in general, I've never learned Cobalt. What I have thus far is: apinvoice.rec_status in (0,1) apinvoice.match_status in (0,1) apinvoice.invoice_type not in ('C', 'D', 'R') apinvoice.mtch_proc_type in ('R', 'A') mainvdtl.r_status = 0 mainvdtl.matche...
0 932
01/27/2016 10:08 AM
2 Replies and 2390 Views SQL query of AP230  2390  2 Started by  Deleted User Can anybody share with me SQL query of AP230 Thanks a lot
2 2390
by  klemmyjbJump to last post
01/14/2016 1:41 PM
2 Replies and 2788 Views LBI Utilization  2788  2 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
2 2788
by  Greg MoellerJump to last post
01/12/2016 3:47 PM
1 Replies and 2624 Views SQL Query of GL90  2624  1 Started by  Michelle Hager I have the below query and I can't seem to get the description of the inventory items. I'm mimicking GL90 can anyone help SELECT GLT.TO_COMPANY AS 'Co' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(VEN.VENDOR) ELSE('N/A') END AS 'Vendor' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(API.VOUCHER_NBR) ELSE('N/A') END AS 'Voucher' ,GLT.ACCT_UNIT AS 'Dept' ,GLT.SYSTEM AS 'System' ,GLT.ACCOUNT 'Account' ,GLC.ACCOUNT_DESC AS 'Acct Description' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(APD.ORIG_BASE_AMT) ELSE...
1 2624
by  LesleyJump to last post
01/11/2016 10:23 AM
1 Replies and 2311 Views User cannot access her report  2311  1 Started by  Donna Hi, The user has access to everything in the dashboard and module as well as the report but is not allowed to access the report after the v10 upgrade. She was running it prior to the upgrade. The user is both a report user and a member of a role on the report and on the dashboard published report. She can run anything else on the dashboard except this report. The default permissions are set up correctly. Error message is 'you do not have access to view the latest instance of this re...
1 2311
by  DonnaJump to last post
01/06/2016 11:01 AM
6 Replies and 3050 Views Lost Report Connection  3050  6 Started by  Katy Prince The Crystal Reports that I published into LBI were working fine then all of a sudden stopped working and started asking for credentials. Then they still won't run. I have other Crystal Reports that run fine (coming from a different database, not infor/Lawson). AND all of my smart notifications are working fine.
6 3050
by  DonnaJump to last post
01/06/2016 10:46 AM
3 Replies and 2708 Views Export of user rights?  2708  3 Started by  Greg Moeller Looking for anyone with experience in exporting existing LBI rights. We are in the middle of configuring our upgrade including a server update and a platform upgrade. We have a lot of rights and would hate to manually enter all of them again.
3 2708
by  Greg MoellerJump to last post
01/05/2016 8:48 AM
0 Replies and 1233 Views Parameters in LBI  1233  0 Started by  thummel1 Hi, I am using Crystal Reports (which is reading from a table in MS Access and is not an approved Data Source in LBI) to generate an LBI report. Because the report is using a data source that is not approved for distribution, the end users can only view it by selecting 'View this Instance' in the LBI report. I would like to add a parameter that allows the end-user to select multiple Process Levels. I have tried to add an LBI parameter, but it seems to only allow one Process Level and not multipl...
0 1233
12/23/2015 3:03 PM
4 Replies and 4006 Views Record selection formula - unexpected results  4006  4 Started by  JonA I've got a report that links MMDIST ==> POLINE (ROJ) and POLINE ==> MAINVDTL (ROJ). I'm looking for all invoice payments for PO lines charged to our supply accounts, grouping the data by whether the line is associated with an agreement or not. The end result is a graph that shows contract/non-contract supply spend for the health system. My issue is that MMDIST has multiple posting types resulting in duplicate data. I found if I eliminate all data with a posting type of H1 I'm left with g...
4 4006
by  mikePJump to last post
12/21/2015 3:16 PM
0 Replies and 1189 Views Lawson Financials AR Report  1189  0 Started by  AnnePep Hello, I am working on a report that I want to show the date an Acounts Receivable invoice was paid or 'applied'. Is there any system time stamp anywhere in Lawson with this information The only dates I see are deposit_date and gl_date on the ARAPPLIED record. These are driven by user input I believe. We wanted to create a metric using the date an invoice was acutally marked 'Paid' in the system (order to cash KPI) Has anyone created this What tables are you using Thank you for an...
0 1189
12/21/2015 8:59 AM
3 Replies and 2577 Views Dashboard Access Rights  2577  3 Started by  Katy Prince I've set up a new dashboard and am trying to grant access rights to a group of users and it isn't working. Is there somewhere else that I need to grant dashboard rights other than in LBI when setting up the user access
3 2577
by  Katy PrinceJump to last post
12/02/2015 9:37 AM
1 Replies and 2130 Views Oracle OLE DB datasource report to be changed to SQL datasource  2130  1 Started by  Donna We were able to change the LBI Crystal reports that use the Lawson tables from the version 9 Oracle database source ODBC connection to the new version 10 SQL database source connection but we still have some SQL reports, OLE DB reports and some Lawson Standard reports. Has anyone else dealt with these reporting issues
1 2130
by  DonnaJump to last post
11/30/2015 3:39 PM
2 Replies and 2390 Views Can you query this in LRS?  2390  2 Started by  Ronnie I have been asked to check into querying our LRS for some info. We are wanting to see what users are tied to all of our reports. Sure I could go into each report and look and see what users and roles are assigned, and then go into security and see who is assigned to each of those roles, BUT we have almost 600 reports I have to query through. I have found the LRS database and tables, but I do not find the info where it shows what users and roles are assigned to the reports.
2 2390
by  Joan HerzfeldtJump to last post
11/17/2015 8:40 AM
4 Replies and 2665 Views Is it possible to use Crystal Enterprise instead of embeded Crystal RAS with LBI  2665  4 Started by  David Britton We currently use the embedded Crystal RAS that came with LBI to run Crystal reports for Lawson 9.0.1. We are currently upgrading to Lawson 10 and LBI 10. We have purchased Crystal Enterprise (SAP 4.1 Enterprise BI Suite) to use as a 'global' reporting solution. Is it possible to configure LBI to use our Enterprise server rather than the embedded RAS Looking at the configuration steps for LBI 9.0.1 I found a requirement for Crystal Enterprise 10 Embedded Edition or Crystal Report Se...
4 2665
by  petecJump to last post
11/06/2015 1:40 PM
0 Replies and 1071 Views Essbase api  1071  0 Started by  brooke Does anyone have the essbase api for AIX
0 1071
11/02/2015 9:56 AM
8 Replies and 3132 Views LBI Report Utilization  3132  8 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
8 3132
by  DonnaJump to last post
10/09/2015 11:05 AM
3 Replies and 3013 Views Which database tables are used for storing LBI report dashboard group hierarchy data?  3013  3 Started by  mlarson I'm new to LBI and trying to find out where report dashboard group hierarchy data is stored. For example, if I had a reports dashboard for clients and on that dashboard there are different groups containing links to run crystal reports. I found a good start for what to look for in the data dictionary on this site (https://www.lawsonguru.com/GuruContent/datadict/ios803/tables/index.html) but there is no data for these tables in my database.
3 3013
by  DonnaJump to last post
10/09/2015 11:00 AM
4 Replies and 3536 Views what table contains dashboard info  3536  4 Started by  Deleted User What table in the LBI database contains the info that shows what dashboards and or modules a report id is linked on
4 3536
by  DonnaJump to last post
10/07/2015 12:49 PM
9 Replies and 4149 Views Employee work history report  4149  9 Started by  Lance Jurgensen Hello, New to Lawson and learning the data on the fly. HRHistory is a bit of a conundrum for me yet. I am trying to write SQL for a crystal report that will report a chronological history of an employees work history from Lawson. Similar to the PA340 Action History Listing but with more useful information :-) Basics such as Name, Employee, position, position description, FTE, supervisor, job code, status, date effective for all positions an employee has held. Would be grateful for any...
9 4149
by  Lance JurgensenJump to last post
09/24/2015 1:25 PM
1 Replies and 2243 Views LBI Utilization  2243  1 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
1 2243
by  Chris MackleyJump to last post
09/14/2015 12:39 PM
0 Replies and 1172 Views Wildcard in LBI report name  1172  0 Started by  Joan Herzfeldt I use the device type 'Network Drive' to export files and place them in the exact folder another system uses to import the file. My problem is several systems need the files named specifically with the current date in the name. I know the Report Name is what's used for the file name when it's exported, which I don't like but can live with. So far I've been able to work around it, but now I have a system that needs the Date FIRST, ugh. Does anyone have a solution for adding dates to the filen...
0 1172
09/04/2015 10:18 AM
6 Replies and 2810 Views Using Lawson Report as a data source in Crystal  2810  6 Started by  Kelly H We are trying to use a Lawson report as a data source in crystal. We have the URL and are able to publish that to LBI. But ultimately we would like to use the report to create a larger report in Crystal which we could then publish in LBI. Is there a way to tie this report to the tables in Lawson via Crystal to create the larger report Any thoughts or suggestions anyone has would be appreciated.
6 2810
by  Greg MoellerJump to last post
09/03/2015 1:47 PM
0 Replies and 1164 Views SCM Reporting - Cycle Count Variances  1164  0 Started by  Robby Since this is a reporting question pertaining to SCM, I posted in both places in hopes of finding someone who knows just what I need! I'll let you know up front, I'm new to reporting for Supply Chain, so if this is too easy of a question....don't hold that against me! The business wants me to create a report (custom, of course!) to highlight the cycle count variances. Apparently, Lawson only tells you 0 (zero) variance if your count is greater than the expected count. But, here's...
0 1164
07/31/2015 12:07 PM
2 Replies and 1915 Views Issue with PDF reporting  1915  2 Started by  Tony Scott Hi, We are using Lawson Portal 9.0.1 at our workplace and we always have issue with report not showing proper format in pdf. When we run report using RW100 and then go to view options PDF-landscape, it does not show all the columns in the report. I am attaching a file that shows example of this on page 1. To fix this, we use a cumbersome approach, where we open the print folder, locate the jobname, change the font type, orientation, scaling to display all the columns and format properl...
2 1915
by  Tony ScottJump to last post
07/20/2015 9:34 PM
8 Replies and 16160 Views How 2 Convert Quartz Scheduler date/times?  16160  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 16160
by  Greg MoellerJump to last post
07/15/2015 9:36 AM
4 Replies and 1422 Views Crystal report reading a csv file  1422  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 1422
by  DVJump to last post
07/14/2015 12:17 PM
0 Replies and 1103 Views Crystal report reading a csv file  1103  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 1103
07/14/2015 11:12 AM
4 Replies and 1235 Views Report Run Log  1235  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 1235
by  Sue KnowltonJump to last post
07/01/2015 2:00 PM
1 Replies and 1256 Views Dashboards and bursting  1256  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 1256
by  Dave CurtisJump to last post
06/23/2015 11:35 AM
0 Replies and 868 Views Summarizing totals in main rpt for arrays in sub rpt  868  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 868
06/22/2015 2:02 PM
0 Replies and 1090 Views Upgrade best practices?  1090  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 1090
06/17/2015 3:01 PM
2 Replies and 1965 Views oleDB Query Builder Error  1965  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 1965
by  Srini RaoJump to last post
06/17/2015 6:52 AM
10 Replies and 2238 Views Default Report Permissions  2238  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 2238
by  Greg MoellerJump to last post
06/16/2015 10:26 AM
2 Replies and 1399 Views Total Rewards Statement?  1399  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 1399
by  thummel1Jump to last post
06/08/2015 3:34 PM
1 Replies and 1578 Views Updating LBI to latest available version  1578  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 1578
by  Carl.SeayJump to last post
05/28/2015 7:59 PM
8 Replies and 1936 Views LBI Report Usage Statistics  1936  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 1936
by  Greg MoellerJump to last post
05/15/2015 1:46 PM
2 Replies and 1426 Views not All LBI users show up in LBI  1426  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 1426
by  Xin LiJump to last post
05/07/2015 2:18 PM
1 Replies and 1340 Views Crystal-Financial Statements-Selecting the month  1340  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 1340
by  RandyJump to last post
04/29/2015 10:43 AM
0 Replies and 1389 Views LSR report not coming up  1389  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 1389
04/21/2015 4:35 PM
18 Replies and 5657 Views How do I report off of a derived field, specifically app.pmt-status?  5657  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 5657
by  John HenleyJump to last post
03/26/2015 10:11 AM
4 Replies and 1404 Views ODBC work on LBI 10.5?  1404  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 1404
by  ISO DanJump to last post
03/19/2015 12:09 PM
1 Replies and 1077 Views HS15 data  1077  1 Started by  Karen Ploof or is it generated on the fly
1 1077
by  Karen PloofJump to last post
03/09/2015 12:58 PM
12 Replies and 2531 Views LBI to network share export  2531  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 2531
by  Joan HerzfeldtJump to last post
03/09/2015 12:38 PM
6 Replies and 1471 Views API and JDBC  1471  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 1471
by  Matthew NyeJump to last post
03/09/2015 11:45 AM
2 Replies and 1748 Views Report is Blank  1748  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 1748
by  Srini RaoJump to last post
02/20/2015 9:58 AM
1 Replies and 1308 Views LBI SSL Errors  1308  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 1308
by  Carl.SeayJump to last post
02/03/2015 1:07 PM
2 Replies and 1517 Views HR Department Name  1517  2 Started by  Alise Would anyone know from their experience what table contains the HR Department name
2 1517
by  AliseJump to last post
01/22/2015 9:45 AM
0 Replies and 1374 Views BackOffice Reports Not working  1374  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 1374
01/16/2015 9:46 AM
4 Replies and 1582 Views LBI back office reports do not work  1582  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 1582
by  Xin LiJump to last post
01/15/2015 9:26 AM
1 Replies and 1724 Views MA236  1724  1 Started by  Chesca I got a called from our purchase manager about the MA236 report not being put in the buyer's queue. He is the only person that's getting the report. The job is scheduled to run in RECDEF. How do I get the report to print in each of the buyer's queue Should I open an incident with Lawson
1 1724
by  mikePJump to last post
01/12/2015 10:17 AM
0 Replies and 1397 Views Crystal report hyperlink to detail crystal report  1397  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 1397
01/10/2015 12:06 AM
0 Replies and 953 Views Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction  953  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 953
12/12/2014 7:16 AM
1 Replies and 1373 Views LBI issue when last folder in LBI list deleted  1373  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 1373
by  DonnaJump to last post
12/01/2014 12:13 PM
6 Replies and 5218 Views Data Mart  5218  6 Started by  Lisa Stewart Since Lawson no longer offers a Datamart solution what are most customers using
6 5218
by  ssarawgiJump to last post
11/25/2014 12:44 PM
2 Replies and 1454 Views Report opens very slow  1454  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 1454
by  JanJump to last post
11/20/2014 2:56 PM
11 Replies and 2191 Views Published report does not run on a schedule  2191  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 2191
by  DonnaJump to last post
11/18/2014 11:04 PM
9 Replies and 1702 Views GLTRANS join to GLCHARTGTL - to obtain Account Description  1702  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 1702
by  AliseJump to last post
11/18/2014 12:39 PM
1 Replies and 1292 Views How to set the date parameter format to ddmmyyyy(UK format)?  1292  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 1292
by  Matthew NyeJump to last post
11/10/2014 4:42 AM
3 Replies and 3118 Views Error when running report in LBI (dashboard)  3118  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 3118
by  Beate Hughes-BrownJump to last post
11/06/2014 8:37 AM
5 Replies and 2220 Views Income statements using Crystal  2220  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 2220
by  MelissaJump to last post
10/29/2014 2:16 PM
13 Replies and 4395 Views Financial statement performance – RW100 as data source vs. Crystal direct to tables  4395  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 4395
by  MelissaJump to last post
10/29/2014 2:01 PM
1 Replies and 1668 Views RAS log on as account  1668  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 1668
by  Greg MoellerJump to last post
10/27/2014 3:25 PM
1 Replies and 1134 Views Securing Details report link from users  1134  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 1134
by  Matthew NyeJump to last post
10/13/2014 12:30 PM
0 Replies and 1792 Views windows authentication for LBI reports  1792  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 1792
09/25/2014 10:45 AM
0 Replies and 1379 Views LBI and Dynamic Parameters  1379  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 1379
09/24/2014 12:26 PM
1 Replies and 1083 Views End User sees Parameters differently  1083  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 1083
by  thummel1Jump to last post
09/24/2014 7:57 AM
0 Replies and 1022 Views LBI - support Signatures ( picture )  1022  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 1022
09/15/2014 5:00 AM
1 Replies and 2308 Views LBI Report Delivery Options  2308  1 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
1 2308
by  Dave CurtisJump to last post
09/10/2014 11:32 AM
5 Replies and 1925 Views LBI and Dynamic Parameters  1925  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 1925
by  thummel1Jump to last post
09/09/2014 11:45 AM
1 Replies and 1371 Views LBI RS table where report runtime is stored  1371  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 1371
by  Greg MoellerJump to last post
08/30/2014 10:11 AM
15 Replies and 3667 Views LBI Deployment from DEV to TEST to PROD  3667  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 3667
by  David BrittonJump to last post
08/27/2014 10:07 AM
2 Replies and 1637 Views Crystal Reports and OLEDB  1637  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 1637
by  mikePJump to last post
08/22/2014 3:09 PM
0 Replies and 1274 Views LT101 Supervisor Errors to LBI missing data  1274  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 1274
08/21/2014 3:04 PM
3 Replies and 1199 Views Scheduling limitations  1199  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 1199
by  Matthew NyeJump to last post
08/20/2014 1:14 PM
5 Replies and 1529 Views Date Stamp in PERSACTION table  1529  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 1529
by  MattJump to last post
08/15/2014 10:24 AM
13 Replies and 2045 Views LBI - Schedule a report with a parameter  2045  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 2045
by  RandyJump to last post
08/14/2014 9:13 AM
0 Replies and 1115 Views Export report & append date to filename?  1115  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 1115
08/01/2014 10:02 AM
27 Replies and 3661 Views Crystal Reports Will Not Refresh in Report Services  3661  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 3661
by  redankerJump to last post
07/24/2014 9:44 AM
8 Replies and 1453 Views Name Change Report  1453  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 1453
by  thummel1Jump to last post
07/23/2014 2:57 PM
0 Replies and 1119 Views Bursting LBI report that has 5 subreports  1119  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 1119
07/23/2014 7:27 AM
1 Replies and 1440 Views Report Not Bursting As Expected  1440  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 1440
by  thummel1Jump to last post
07/23/2014 7:07 AM
1 Replies and 1230 Views LBI report returns to Crystal parameter page  1230  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 1230
by  mikePJump to last post
07/15/2014 1:06 PM
16 Replies and 2093 Views Table for Report Schedule Names  2093  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 2093
by  Greg MoellerJump to last post
07/02/2014 10:16 AM
3 Replies and 2390 Views URL/link to AP150 Output  2390  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 2390
by  GiuliaJump to last post
06/23/2014 1:58 PM
4 Replies and 1314 Views LBI Report Owner change  1314  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 1314
by  Mary PorterJump to last post
06/20/2014 1:08 PM
0 Replies and 1053 Views Incorporate GL Data in the MM280  1053  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 1053
06/19/2014 9:11 AM
0 Replies and 1126 Views LBI Pricing  1126  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 1126
06/03/2014 8:51 AM
3 Replies and 1201 Views Listing the bursting rights by user  1201  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 1201
by  DonnaJump to last post
05/23/2014 3:13 PM
8 Replies and 1648 Views Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?  1648  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 1648
by  JeffCozzagJump to last post
05/15/2014 4:20 PM
10 Replies and 1947 Views Emailing LBI reports  1947  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 1947
by  Greg MoellerJump to last post
05/15/2014 10:04 AM
1 Replies and 1262 Views Upgrade to RAS 2011  1262  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 1262
by  Greg MoellerJump to last post
05/15/2014 10:02 AM
3 Replies and 1710 Views Convert LBI Reports to Business Objects  1710  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 1710
by  DonnaJump to last post
05/12/2014 5:04 PM
2 Replies and 945 Views Printing multiple parameter descriiption value fields  945  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 945
by  DonnaJump to last post
05/12/2014 4:58 PM
9 Replies and 2883 Views Infor Lawson BI - Add new dashboard  2883  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 2883
by  Greg MoellerJump to last post
05/09/2014 1:25 PM
2 Replies and 1367 Views LBI and Cognos  1367  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 1367
by  NabilJump to last post
05/06/2014 12:04 PM
1 Replies and 1049 Views Assign user with an access to multiple reports in Lawson LBI  1049  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 1049
by  Law123Jump to last post
05/06/2014 11:21 AM
1 Replies and 1101 Views Automating Rights Import  1101  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 1101
by  Ken CarleyJump to last post
04/09/2014 2:51 PM
0 Replies and 979 Views LBI Data Source of Instance Queue Connection  979  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 979
03/31/2014 4:26 PM
6 Replies and 1503 Views Report Auditing  1503  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 1503
by  Greg MoellerJump to last post
03/28/2014 4:01 PM
3 Replies and 1191 Views Display burst rights info in report?  1191  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 1191
by  mikePJump to last post
03/19/2014 12:08 PM
0 Replies and 1047 Views Transaction Counts  1047  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 1047
03/12/2014 4:21 PM
4 Replies and 919 Views Bursting, How can I restrict one group and allow the rest  919  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 919
by  amynelsonJump to last post
03/12/2014 1:30 PM
2 Replies and 1309 Views Dashboard module to new tab?  1309  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 1309
by  mark.cookJump to last post
03/10/2014 8:03 AM
3 Replies and 1535 Views PO Comment database location  1535  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 1535
by  dukeslaterJump to last post
03/07/2014 2:19 PM
2 Replies and 1298 Views Import Devices not working  1298  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 1298
by  Mary PorterJump to last post
02/13/2014 6:38 PM
4 Replies and 2171 Views MM280 DistributionReport  2171  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 2171
by  Gary GastaJump to last post
02/07/2014 8:36 AM
4 Replies and 1425 Views Report Schedules  1425  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 1425
by  RobbyJump to last post
02/06/2014 3:55 PM
3 Replies and 2120 Views ODBC 64-bit driver  2120  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 2120
by  Mary PorterJump to last post
02/05/2014 5:53 PM
3 Replies and 2055 Views Bursting PDF to Dashboard  2055  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 2055
by  Roger2010Jump to last post
01/28/2014 10:35 AM
2 Replies and 1508 Views Invoke report from url and have it sent as email attachment  1508  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 1508
by  TRKJump to last post
01/23/2014 12:41 AM
0 Replies and 1046 Views Crystal Report for S3 Fiancial Rolls  1046  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 1046
01/13/2014 3:51 PM
1 Replies and 1143 Views Exporting as CSV creating duplicates?  1143  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 1143
by  Dave CurtisJump to last post
01/04/2014 6:21 AM
3 Replies and 2091 Views LBI Current User Formula???  2091  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 2091
by  Greg MoellerJump to last post
01/02/2014 1:39 PM
2 Replies and 1338 Views Burting by LBI Report content  1338  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 1338
by  Susan PrenticeJump to last post
12/23/2013 3:24 PM
6 Replies and 1547 Views Refreshing server for LBI  1547  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 1547
by  Alex TsekhanskyJump to last post
12/22/2013 4:50 PM
3 Replies and 1260 Views LBI without Lawson Portal  1260  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 1260
by  Kate LiameroJump to last post
12/13/2013 9:14 AM
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 1 of 512345 > >>


RSS Feed Available