Forums
 Topics
 Replies
 Last Post
185 Topics and 632 Replies Smart Notification  185  632
RE: Infoset Query String ...
by  thummel1
08/21/2019 4:50 PM
185 632
RE: Infoset Query String ...
by  thummel1
08/21/2019 4:50 PM
Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 512345 > >>
Topics
 Replies
 Views
 Last Post
3 Replies and 6716 Views Crystal Labor Utiilization Report to publish in LBI    6716  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 6716
by  JanJump to last post
01/06/2010 9:05 AM
1 Replies and 282 Views LBI 10.6 Sorting by Instance Name  282  1 Started by  dcaiani We recently upgraded to LBI 10.6 from 10.4. In each version up until 10.6 you could sort reports via the Instance Name, now in 10.6 you cannot. So we publish about 15 RW100 reports each month and keep the historical instances on LBI for 24 months. Each month the instance name is renamed in this format 'fiscal year period number actual month & year' (for example FY19 Period 04 January 2019). That way we could sort descending by instance number and it keeps the most current version on top ...
1 282
by  Greg DeyJump to last post
11/12/2019 6:49 PM
0 Replies and 193 Views Querying a business class  193  0 Started by  Casy We pull data from the SQL database for our Landmark environment. There is a field that we were unable to locate a table for and according to support, this field is only located in the audit log. The instructions provided on how to query the audit log are convoluted at best. Is anyone aware of a table that houses the below: Business Class: Employee Form Name: Terminate BusFormAttribute Name: Employee_reason_code Any idea if it truly does ONLY exist in the audit log We are on V10 Lan...
0 193
08/12/2019 3:27 PM
1 Replies and 448 Views MN Wage Theft Reporting Solutions  448  1 Started by  thummel1 I am wondering what other Minnesota organizations have implemented as a reporting solution for the new MN Wage Theft Reporting laws that went into effective on 7/1/2019 Has anyone heard if Infor is working on a reporting solution All responses are welcome.
1 448
by  John HenleyJump to last post
07/23/2019 1:46 PM
0 Replies and 222 Views Adding PO100 exception message to crytal report query  222  0 Started by  katiepdx I want to include the Reason for Exception in one of my Crystal report. This is the exception message from PO100 Error report. Any one know if this information stay somewhere in any of Lawson tables Thanks,
0 222
07/17/2019 6:26 PM
2 Replies and 653 Views Preserve formatting upon LBI export  653  2 Started by  thummel1 We would like to be able to export existing LBI reports, (or set them to open directly as Excel (.xlsx)) so that the columns are sized according to the data in each column. The purpose of this is so that the end user does not have to spend the extra time re-sizing the columns to see all the data in each column of the Excel spreadsheet Is there a way to do this if the report is coming from Crystal I have tried changing some settings in the Export options within the Crystal report, which works...
2 653
by  JonAJump to last post
07/10/2019 2:48 PM
11 Replies and 5874 Views Employee work history report  5874  11 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...
11 5874
by  Dave CurtisJump to last post
05/17/2019 2:33 PM
3 Replies and 785 Views Adding more users to the sync  785  3 Started by  Greg Moeller I remember a LONG time ago, where we ran into a limit on how many users we could sync to LBI from LSF. I think we've hit that limit again, and was wondering if anyone here remembered where to change it at Any help would be appreciated! TIA, -Greg
3 785
by  Greg MoellerJump to last post
03/20/2019 1:25 PM
1 Replies and 666 Views PO31 comments table  666  1 Started by  NatalieD Anyone know what table houses the comments made on PO31 I know L_HPCR is for PO20 - need to query PO31 comments.
1 666
by  NatalieDJump to last post
02/21/2019 12:49 PM
1 Replies and 628 Views PO20 inventory items & MMDIST  628  1 Started by  NatalieD Hello All - Wondering if any of you have and experience pulling the accounting information for PO20 lines for inventory items. We have always used MMDIST - as referenced on the PO20 lines MMD-ACCOUNT, etc. Recently realized that some items in our custom query were not pulling. In chat with Infor, they stated that all PO lines account and accounting unit fields referencing MMD on the PO20 screen will be in MMDIST except for inventory items. They referenced IC04 for the IC12 to get the correct ...
1 628
by  Jeff NJump to last post
02/14/2019 3:05 PM
5 Replies and 4878 Views MA236 criteria.  4878  5 Started by  T.Welsh Hello all, I am attempting to write an enhanced version of MA236 in Crystal XI. I aquired code on MA236 using 'bldsh' command but the exact criteria is still unclear to me. I can get within a few records of a perfect match to MA236, but I always end up a few records short and, in addition, get a few that are not in MA236. Has anyone attempted this in Crystal before If so, or even if not, does anyone have a clear set of criteria for MA236 Any help would be GREATLY appreciated. Thank...
5 4878
by  NatalieDJump to last post
10/22/2018 10:29 AM
0 Replies and 659 Views INFOR BI Issue  659  0 Started by  vip1982 Hello Everyone, I would appreciate your support into the issue below, INFOR till now didnt solve it for us. We have installed the following: 1) Infor Business Vault Enterprise Edition 11.3.2 2) Infor BI OLAP Server (64 bit) 11.0.0.365 3) Infor LN Analytics Foundation 10.5.2 We are using Infor LN FP9. We have 2 companies: 222 and 333. Company 222 has common Master data in it which is shared with company 333. We have published all the data referring the document 'Infor_LN_I...
0 659
10/22/2018 2:07 AM
0 Replies and 659 Views CSV export options not working in 10.6  659  0 Started by  Joan Herzfeldt Has anyone else had this happen after upgrading to 10.6 (LBI/RAS) In crystal reports you can define the export options under File->Export->Report Export Options. You can tell it to use a pipe (|) as the separator, whether or not to put commas around the data, and how to export page/group header sections. LBI in the Schedule under Bursting and Distribution you can set the output type to CSV and then choose where it outputs. Previously it would use the export options that were saved w...
0 659
10/02/2018 11:31 AM
0 Replies and 455 Views Crystal Report Paramaters with Encryption  455  0 Started by  JasonP We have an email notification that goes to users that has an embedded link with dynamic parameters such as so that https://xxx.xxxx.net:9443/efs/FSRemotefsid=RS:RS-HMC Reporting Services:1099&Dobeforeevent=false&Company=10&Vendor=48663&Invoice=1153 Is there a way to encrypt the Company , Vendor, and invoice values and have crystal accepts those.
0 455
09/28/2018 10:56 AM
0 Replies and 572 Views Exporting crystal report in text format?  572  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 572
09/12/2018 4:24 PM
1 Replies and 615 Views Summarized Transactions - Payroll  615  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 615
by  Ragu RaghavanJump to last post
09/05/2018 6:53 AM
4 Replies and 2768 Views LBI and Crystal 2016, Windows 10 (UPDATED)  2768  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 2768
by  SRHarrisJump to last post
07/19/2018 12:10 PM
3 Replies and 1418 Views List of active employees at a certain point in time.  1418  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 1418
by  agershJump to last post
06/11/2018 9:32 AM
4 Replies and 1265 Views Deliver LBI report to Email  1265  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 1265
by  Dave CurtisJump to last post
05/30/2018 3:00 PM
3 Replies and 1405 Views Lost Data Settings  1405  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 1405
by  Greg MoellerJump to last post
04/16/2018 1:05 PM
3 Replies and 1211 Views Moving Lawson Documents  1211  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 1211
by  DonnaJump to last post
04/12/2018 3:05 PM
2 Replies and 2349 Views QLIK  2349  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 2349
by  NabilJump to last post
03/20/2018 10:55 AM
1 Replies and 1371 Views Convert PR261 to easy to read format  1371  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 1371
by  Jason BeardJump to last post
03/09/2018 3:22 PM
1 Replies and 2196 Views Upgrade for LBI v10 - Infor BI, BIRST or other  2196  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 2196
by  NabilJump to last post
02/07/2018 3:15 PM
2 Replies and 2362 Views Lawson Smart Reports - LSR Designer  2362  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 2362
by  dkesterJump to last post
01/10/2018 3:55 PM
3 Replies and 3423 Views LBI vs. Infor Birst  3423  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 3423
by  JeremyJump to last post
01/02/2018 11:57 AM
0 Replies and 669 Views Output to CSV does not retain  669  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 669
12/01/2017 8:36 AM
10 Replies and 3864 Views LBI Schedule Disappear Randomly  3864  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 3864
by  Joan HerzfeldtJump to last post
11/22/2017 9:15 AM
8 Replies and 2368 Views Report will not burst  2368  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 2368
by  DonnaJump to last post
10/11/2017 5:15 PM
0 Replies and 709 Views Survey Functionality  709  0 Started by  thummel1 I am wondering if Lawson V10 has the ability to create a survey for employees in Employee Self Service
0 709
09/05/2017 2:09 PM
3 Replies and 2637 Views Remove MNR PO Lines from Report  2637  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 2637
by  Kat VJump to last post
09/05/2017 8:18 AM
0 Replies and 794 Views Infor Enhancement to APAUDIT  794  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 794
08/21/2017 6:51 AM
15 Replies and 4672 Views Guru Data Dictionary  4672  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 4672
by  John HenleyJump to last post
08/03/2017 2:29 PM
1 Replies and 2078 Views UTC Conversions on Date Range Functions  2078  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 2078
by  John HenleyJump to last post
08/03/2017 10:29 AM
7 Replies and 3687 Views LBI On Demand-passing in authuser value  3687  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 3687
by  Who Da PhillyJump to last post
07/20/2017 8:21 AM
0 Replies and 780 Views ReportWriter GL Income Statement 12 Mo.  780  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 780
06/27/2017 10:50 AM
2 Replies and 2580 Views LBI Server Out of Memory  2580  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 2580
by  Greg MoellerJump to last post
05/30/2017 4:46 PM
1 Replies and 2188 Views LBI Delete Parameter Values  2188  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 2188
by  KatmanJump to last post
05/30/2017 1:54 PM
2 Replies and 2045 Views Verifying LBI Maintain Rights  2045  2 Started by  ALB 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 2045
by  Joan HerzfeldtJump to last post
03/21/2017 8:38 AM
6 Replies and 3434 Views Framework Services Tools Dashboard  3434  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 3434
by  ALBJump to last post
03/20/2017 11:25 AM
7 Replies and 2857 Views LBI Tools Tab Reporting My Reports  2857  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 2857
by  lmackinJump to last post
03/01/2017 12:17 PM
1 Replies and 1884 Views LBI Backoffice to GL90 security  1884  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 1884
by  texasInstrumentsJump to last post
02/20/2017 4:17 PM
0 Replies and 1210 Views Paramertized Crystal Reports freezes  1210  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 1210
02/14/2017 6:49 AM
1 Replies and 1997 Views Embed <LAW> tag  1997  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 1997
by  NatalieDJump to last post
02/08/2017 10:14 AM
1 Replies and 2124 Views Report  2124  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 2124
by  dcaianiJump to last post
02/06/2017 9:08 AM
3 Replies and 2845 Views Item Locn usage using ICHISTORY - date range?  2845  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 2845
by  NatalieDJump to last post
02/03/2017 1:35 PM
1 Replies and 1983 Views Edit Report List under Maintain Reports  1983  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 1983
by  NatalieDJump to last post
02/03/2017 9:17 AM
1 Replies and 2513 Views Infor BI versus LBI versus other solutions  2513  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 2513
by  RandyJump to last post
01/24/2017 1:10 PM
0 Replies and 866 Views Cleanup user rights  866  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 866
01/17/2017 10:10 AM
0 Replies and 1205 Views LBI report linked to Excel file  1205  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 1205
01/16/2017 8:41 AM
1 Replies and 2192 Views Change user language in LawsonFS database  2192  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 2192
by  TRKJump to last post
12/28/2016 3:06 AM
1 Replies and 2513 Views Crystal Report does not run  2513  1 Started by  ALB 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 2513
by  Jimmy ChiuJump to last post
12/23/2016 8:16 AM
4 Replies and 2747 Views Republishing reports not working LBI 10.6  2747  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 2747
by  Jimmy ChiuJump to last post
12/23/2016 8:09 AM
3 Replies and 2511 Views Enhancement requests 9809 & 9813 - suggest you vote!  2511  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 2511
by  Kelly HJump to last post
12/23/2016 8:03 AM
1 Replies and 2281 Views Crystal Report - Help Adding Fields to Existing Query  2281  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 2281
by  Jeff ShumateJump to last post
11/28/2016 6:42 PM
4 Replies and 3771 Views RNI Crystal  3771  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 3771
by  JonAJump to last post
11/28/2016 1:57 PM
0 Replies and 1201 Views Report will not pull up  1201  0 Started by  ALB 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 1201
11/23/2016 2:44 PM
0 Replies and 1017 Views Determine if an employee received a promotion/demotion  1017  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 1017
11/17/2016 2:01 PM
0 Replies and 1063 Views Need GLTRANS and FBDETAIL view  1063  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 1063
11/15/2016 10:30 PM
11 Replies and 4067 Views Searching for BANK-STATUS field  4067  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 4067
by  Greg DeyJump to last post
11/11/2016 5:00 PM
9 Replies and 6069 Views LBI to Infor BI  6069  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 6069
by  Vijay SJump to last post
11/08/2016 8:28 AM
1 Replies and 2242 Views POAGMTPART  2242  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 2242
by  Joan HerzfeldtJump to last post
11/03/2016 10:41 AM
3 Replies and 2385 Views Unable to view LBI Report  2385  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 2385
by  Vijay SJump to last post
10/25/2016 9:10 AM
6 Replies and 2663 Views Crystal Report for PO23 Orphaned Items  2663  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 2663
by  bruppJump to last post
09/16/2016 3:00 PM
0 Replies and 946 Views Parameters and Scheduled Instances  946  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 946
09/12/2016 1:38 PM
6 Replies and 2881 Views Cross Reference All LBI Reports to Security  2881  6 Started by  ALB 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 2881
by  ALBJump to last post
08/19/2016 11:42 AM
5 Replies and 2888 Views Internet Explorer 11 and LBI Version 9.0.4  2888  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 2888
by  Fred PintoJump to last post
08/10/2016 10:34 AM
1 Replies and 2920 Views Crystal Reporting in the Cloud  2920  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 2920
by  Jimmy ChiuJump to last post
08/05/2016 1:47 PM
4 Replies and 3524 Views Crystal report not refreshing  3524  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 3524
by  NatalieDJump to last post
07/28/2016 9:25 AM
2 Replies and 2608 Views LBI 10.5  2608  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 2608
by  Greg MoellerJump to last post
07/27/2016 10:52 AM
3 Replies and 2652 Views Updating user rights in LBI within IE11  2652  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 2652
by  Greg DeyJump to last post
07/07/2016 9:46 AM
1 Replies and 2451 Views Bursting Reports on Dashboard  2451  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 2451
by  Dave CurtisJump to last post
06/30/2016 9:04 AM
3 Replies and 2797 Views Refresh RS SN FS Databases  2797  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 2797
by  Greg MoellerJump to last post
06/28/2016 11:40 AM
2 Replies and 2584 Views ICTRANS Location w-Name  2584  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 2584
by  bruppJump to last post
06/17/2016 8:17 AM
0 Replies and 1887 Views Item/Vendor report  1887  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 1887
06/16/2016 3:26 PM
1 Replies and 2699 Views 7.1.5 Lawson Insight GL / Fin.  2699  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 2699
by  edjJump to last post
06/14/2016 12:08 PM
3 Replies and 2555 Views Excel Exports format incorrectly in LBI  2555  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 2555
by  DonnaJump to last post
06/02/2016 3:26 PM
2 Replies and 2454 Views PO Spend Validation  2454  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 2454
by  NatalieDJump to last post
05/19/2016 10:02 AM
5 Replies and 2815 Views Crystal Par Stock Out Report  2815  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 2815
by  JonAJump to last post
05/18/2016 11:47 AM
1 Replies and 2923 Views Oracle ODBC Driver Configuration Error  2923  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 2923
by  JonAJump to last post
05/12/2016 2:28 PM
2 Replies and 2472 Views Table Joins - MMDIST & GL  2472  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 2472
by  bruppJump to last post
05/09/2016 10:47 AM
2 Replies and 2540 Views Items and unit price  2540  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 2540
by  Kat VJump to last post
05/09/2016 8:53 AM
2 Replies and 2433 Views IC11 and vendor data  2433  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 2433
by  NatalieDJump to last post
05/06/2016 7:11 AM
6 Replies and 3731 Views List of bursting rights, elements and users  3731  6 Started by  Donna What tables have the bursting information fields Thank you. Donna
6 3731
by  Lance KelleyJump to last post
05/03/2016 2:59 PM
1 Replies and 2600 Views need documentation on publishing on LBI  2600  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 2600
by  JonAJump to last post
04/22/2016 8:24 AM
1 Replies and 2654 Views Future of LBI  2654  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 2654
by  Shane JonesJump to last post
04/16/2016 6:50 AM
1 Replies and 2392 Views How to add a custom table to lawson data dictionary version 9.0.0.1  2392  1 Started by  apsnaveen How to add a custom table to lawson data dictionary version 9.0.0.1
1 2392
by  mikePJump to last post
04/14/2016 10:32 AM
1 Replies and 2600 Views Print to a network printer?  2600  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 2600
by  Lance JurgensenJump to last post
04/06/2016 10:56 AM
9 Replies and 3272 Views Links on dashboard (LBI) will not launch  3272  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 3272
by  EthanJump to last post
03/23/2016 5:28 PM
5 Replies and 2894 Views PERSACTION Report build  2894  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 2894
by  Dave CurtisJump to last post
03/23/2016 7:36 AM
6 Replies and 5468 Views Crystal and PRSAGDTL.EFFECT_DATE  5468  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 5468
by  mikePJump to last post
03/21/2016 12:18 PM
1 Replies and 2418 Views MSCM Signature  2418  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 2418
by  Greg MoellerJump to last post
03/10/2016 10:23 AM
5 Replies and 2508 Views Report for LBI reports posted and publishing/Report ID  2508  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 2508
by  DonnaJump to last post
03/03/2016 2:56 PM
0 Replies and 1243 Views AP150 invoices put on hold  1243  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 1243
02/29/2016 7:33 AM
3 Replies and 2909 Views PERSACTION-Position Number?  2909  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 2909
by  pbelskyJump to last post
02/03/2016 5:03 PM
3 Replies and 2801 Views Freight Data Output to Text File  2801  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 2801
by  JonAJump to last post
02/03/2016 2:08 PM
4 Replies and 2827 Views Dashboard Missing  2827  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 2827
by  Kelly HJump to last post
02/02/2016 2:38 PM
0 Replies and 1314 Views MA236 Criteria  1314  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 1314
01/27/2016 10:08 AM
2 Replies and 2692 Views SQL query of AP230  2692  2 Started by  Deleted User Can anybody share with me SQL query of AP230 Thanks a lot
2 2692
by  klemmyjbJump to last post
01/14/2016 1:41 PM
2 Replies and 3285 Views LBI Utilization  3285  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 3285
by  Greg MoellerJump to last post
01/12/2016 3:47 PM
1 Replies and 3147 Views SQL Query of GL90  3147  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 3147
by  LesleyJump to last post
01/11/2016 10:23 AM
1 Replies and 2651 Views User cannot access her report  2651  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 2651
by  DonnaJump to last post
01/06/2016 11:01 AM
6 Replies and 3433 Views Lost Report Connection  3433  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 3433
by  DonnaJump to last post
01/06/2016 10:46 AM
3 Replies and 3045 Views Export of user rights?  3045  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 3045
by  Greg MoellerJump to last post
01/05/2016 8:48 AM
0 Replies and 1587 Views Parameters in LBI  1587  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 1587
12/23/2015 3:03 PM
4 Replies and 4614 Views Record selection formula - unexpected results  4614  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 4614
by  mikePJump to last post
12/21/2015 3:16 PM
0 Replies and 1581 Views Lawson Financials AR Report  1581  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 1581
12/21/2015 8:59 AM
3 Replies and 3140 Views Dashboard Access Rights  3140  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 3140
by  Katy PrinceJump to last post
12/02/2015 9:37 AM
1 Replies and 2481 Views Oracle OLE DB datasource report to be changed to SQL datasource  2481  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 2481
by  DonnaJump to last post
11/30/2015 3:39 PM
2 Replies and 2781 Views Can you query this in LRS?  2781  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 2781
by  Joan HerzfeldtJump to last post
11/17/2015 8:40 AM
4 Replies and 3062 Views Is it possible to use Crystal Enterprise instead of embeded Crystal RAS with LBI  3062  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 3062
by  petecJump to last post
11/06/2015 1:40 PM
0 Replies and 1433 Views Essbase api  1433  0 Started by  brooke Does anyone have the essbase api for AIX
0 1433
11/02/2015 9:56 AM
8 Replies and 3722 Views LBI Report Utilization  3722  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 3722
by  DonnaJump to last post
10/09/2015 11:05 AM
3 Replies and 3379 Views Which database tables are used for storing LBI report dashboard group hierarchy data?  3379  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 3379
by  DonnaJump to last post
10/09/2015 11:00 AM
4 Replies and 3949 Views what table contains dashboard info  3949  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 3949
by  DonnaJump to last post
10/07/2015 12:49 PM
1 Replies and 2589 Views LBI Utilization  2589  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 2589
by  Chris MackleyJump to last post
09/14/2015 12:39 PM
0 Replies and 1562 Views Wildcard in LBI report name  1562  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 1562
09/04/2015 10:18 AM
6 Replies and 3253 Views Using Lawson Report as a data source in Crystal  3253  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 3253
by  Greg MoellerJump to last post
09/03/2015 1:47 PM
0 Replies and 1544 Views SCM Reporting - Cycle Count Variances  1544  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 1544
07/31/2015 12:07 PM
2 Replies and 2281 Views Issue with PDF reporting  2281  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 2281
by  Tony ScottJump to last post
07/20/2015 9:34 PM
8 Replies and 18203 Views How 2 Convert Quartz Scheduler date/times?  18203  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 18203
by  Greg MoellerJump to last post
07/15/2015 9:36 AM
4 Replies and 1877 Views Crystal report reading a csv file  1877  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 1877
by  DVJump to last post
07/14/2015 12:17 PM
0 Replies and 1449 Views Crystal report reading a csv file  1449  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 1449
07/14/2015 11:12 AM
4 Replies and 1554 Views Report Run Log  1554  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 1554
by  Sue KnowltonJump to last post
07/01/2015 2:00 PM
1 Replies and 1553 Views Dashboards and bursting  1553  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 1553
by  Dave CurtisJump to last post
06/23/2015 11:35 AM
0 Replies and 1187 Views Summarizing totals in main rpt for arrays in sub rpt  1187  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 1187
06/22/2015 2:02 PM
0 Replies and 1389 Views Upgrade best practices?  1389  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 1389
06/17/2015 3:01 PM
2 Replies and 2326 Views oleDB Query Builder Error  2326  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 2326
by  Srini RaoJump to last post
06/17/2015 6:52 AM
10 Replies and 2720 Views Default Report Permissions  2720  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 2720
by  Greg MoellerJump to last post
06/16/2015 10:26 AM
2 Replies and 1777 Views Total Rewards Statement?  1777  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 1777
by  thummel1Jump to last post
06/08/2015 3:34 PM
1 Replies and 1916 Views Updating LBI to latest available version  1916  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 1916
by  Carl.SeayJump to last post
05/28/2015 7:59 PM
8 Replies and 2403 Views LBI Report Usage Statistics  2403  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 2403
by  Greg MoellerJump to last post
05/15/2015 1:46 PM
2 Replies and 1767 Views not All LBI users show up in LBI  1767  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 1767
by  Xin LiJump to last post
05/07/2015 2:18 PM
1 Replies and 1656 Views Crystal-Financial Statements-Selecting the month  1656  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 1656
by  RandyJump to last post
04/29/2015 10:43 AM
0 Replies and 1708 Views LSR report not coming up  1708  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 1708
04/21/2015 4:35 PM
18 Replies and 6356 Views How do I report off of a derived field, specifically app.pmt-status?  6356  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 6356
by  John HenleyJump to last post
03/26/2015 10:11 AM
4 Replies and 1797 Views ODBC work on LBI 10.5?  1797  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 1797
by  ISO DanJump to last post
03/19/2015 12:09 PM
1 Replies and 1409 Views HS15 data  1409  1 Started by  Karen Ploof or is it generated on the fly
1 1409
by  Karen PloofJump to last post
03/09/2015 12:58 PM
12 Replies and 3239 Views LBI to network share export  3239  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 3239
by  Joan HerzfeldtJump to last post
03/09/2015 12:38 PM
6 Replies and 1918 Views API and JDBC  1918  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 1918
by  Matthew NyeJump to last post
03/09/2015 11:45 AM
2 Replies and 2112 Views Report is Blank  2112  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 2112
by  Srini RaoJump to last post
02/20/2015 9:58 AM
1 Replies and 1656 Views LBI SSL Errors  1656  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 1656
by  Carl.SeayJump to last post
02/03/2015 1:07 PM
2 Replies and 1904 Views HR Department Name  1904  2 Started by  Alise Would anyone know from their experience what table contains the HR Department name
2 1904
by  AliseJump to last post
01/22/2015 9:45 AM
0 Replies and 1775 Views BackOffice Reports Not working  1775  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 1775
01/16/2015 9:46 AM
4 Replies and 1944 Views LBI back office reports do not work  1944  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 1944
by  Xin LiJump to last post
01/15/2015 9:26 AM
1 Replies and 2186 Views MA236  2186  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 2186
by  mikePJump to last post
01/12/2015 10:17 AM
0 Replies and 1714 Views Crystal report hyperlink to detail crystal report  1714  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 1714
01/10/2015 12:06 AM
0 Replies and 1296 Views Configuring an LBI Dashboard Content Module so that it executes a script or command line transaction  1296  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 1296
12/12/2014 7:16 AM
1 Replies and 1751 Views LBI issue when last folder in LBI list deleted  1751  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 1751
by  DonnaJump to last post
12/01/2014 12:13 PM
6 Replies and 5745 Views Data Mart  5745  6 Started by  Lisa Stewart Since Lawson no longer offers a Datamart solution what are most customers using
6 5745
by  ssarawgiJump to last post
11/25/2014 12:44 PM
2 Replies and 1774 Views Report opens very slow  1774  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 1774
by  JanJump to last post
11/20/2014 2:56 PM
11 Replies and 2739 Views Published report does not run on a schedule  2739  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 2739
by  DonnaJump to last post
11/18/2014 11:04 PM
9 Replies and 2180 Views GLTRANS join to GLCHARTGTL - to obtain Account Description  2180  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 2180
by  AliseJump to last post
11/18/2014 12:39 PM
1 Replies and 1681 Views How to set the date parameter format to ddmmyyyy(UK format)?  1681  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 1681
by  Matthew NyeJump to last post
11/10/2014 4:42 AM
3 Replies and 3487 Views Error when running report in LBI (dashboard)  3487  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 3487
by  Beate Hughes-BrownJump to last post
11/06/2014 8:37 AM
5 Replies and 2680 Views Income statements using Crystal  2680  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 2680
by  MelissaJump to last post
10/29/2014 2:16 PM
13 Replies and 4981 Views Financial statement performance – RW100 as data source vs. Crystal direct to tables  4981  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 4981
by  MelissaJump to last post
10/29/2014 2:01 PM
1 Replies and 2032 Views RAS log on as account  2032  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 2032
by  Greg MoellerJump to last post
10/27/2014 3:25 PM
1 Replies and 1440 Views Securing Details report link from users  1440  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 1440
by  Matthew NyeJump to last post
10/13/2014 12:30 PM
0 Replies and 2194 Views windows authentication for LBI reports  2194  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 2194
09/25/2014 10:45 AM
0 Replies and 1764 Views LBI and Dynamic Parameters  1764  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 1764
09/24/2014 12:26 PM
1 Replies and 1364 Views End User sees Parameters differently  1364  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 1364
by  thummel1Jump to last post
09/24/2014 7:57 AM
0 Replies and 1313 Views LBI - support Signatures ( picture )  1313  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 1313
09/15/2014 5:00 AM
1 Replies and 2760 Views LBI Report Delivery Options  2760  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 2760
by  Dave CurtisJump to last post
09/10/2014 11:32 AM
5 Replies and 2649 Views LBI and Dynamic Parameters  2649  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 2649
by  thummel1Jump to last post
09/09/2014 11:45 AM
1 Replies and 1785 Views LBI RS table where report runtime is stored  1785  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 1785
by  Greg MoellerJump to last post
08/30/2014 10:11 AM
15 Replies and 4208 Views LBI Deployment from DEV to TEST to PROD  4208  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 4208
by  David BrittonJump to last post
08/27/2014 10:07 AM
2 Replies and 1975 Views Crystal Reports and OLEDB  1975  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 1975
by  mikePJump to last post
08/22/2014 3:09 PM
0 Replies and 1631 Views LT101 Supervisor Errors to LBI missing data  1631  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 1631
08/21/2014 3:04 PM
3 Replies and 1525 Views Scheduling limitations  1525  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 1525
by  Matthew NyeJump to last post
08/20/2014 1:14 PM
5 Replies and 1923 Views Date Stamp in PERSACTION table  1923  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 1923
by  MattJump to last post
08/15/2014 10:24 AM
13 Replies and 2671 Views LBI - Schedule a report with a parameter  2671  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 2671
by  RandyJump to last post
08/14/2014 9:13 AM
0 Replies and 1462 Views Export report & append date to filename?  1462  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 1462
08/01/2014 10:02 AM
27 Replies and 4549 Views Crystal Reports Will Not Refresh in Report Services  4549  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 4549
by  redankerJump to last post
07/24/2014 9:44 AM
8 Replies and 1741 Views Name Change Report  1741  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 1741
by  thummel1Jump to last post
07/23/2014 2:57 PM
0 Replies and 1462 Views Bursting LBI report that has 5 subreports  1462  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 1462
07/23/2014 7:27 AM
1 Replies and 1729 Views Report Not Bursting As Expected  1729  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 1729
by  thummel1Jump to last post
07/23/2014 7:07 AM
1 Replies and 1572 Views LBI report returns to Crystal parameter page  1572  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 1572
by  mikePJump to last post
07/15/2014 1:06 PM
16 Replies and 2635 Views Table for Report Schedule Names  2635  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 2635
by  Greg MoellerJump to last post
07/02/2014 10:16 AM
3 Replies and 2707 Views URL/link to AP150 Output  2707  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 2707
by  GiuliaJump to last post
06/23/2014 1:58 PM
4 Replies and 1748 Views LBI Report Owner change  1748  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 1748
by  Mary PorterJump to last post
06/20/2014 1:08 PM
0 Replies and 1455 Views Incorporate GL Data in the MM280  1455  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 1455
06/19/2014 9:11 AM
0 Replies and 1477 Views LBI Pricing  1477  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 1477
06/03/2014 8:51 AM
3 Replies and 1507 Views Listing the bursting rights by user  1507  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 1507
by  DonnaJump to last post
05/23/2014 3:13 PM
8 Replies and 2027 Views Is there a key in the EFS schema that can link to the REPORTID field in the ERS schema?  2027  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 2027
by  JeffCozzagJump to last post
05/15/2014 4:20 PM
10 Replies and 2685 Views Emailing LBI reports  2685  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 2685
by  Greg MoellerJump to last post
05/15/2014 10:04 AM
1 Replies and 1553 Views Upgrade to RAS 2011  1553  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 1553
by  Greg MoellerJump to last post
05/15/2014 10:02 AM
3 Replies and 2052 Views Convert LBI Reports to Business Objects  2052  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 2052
by  DonnaJump to last post
05/12/2014 5:04 PM
2 Replies and 1325 Views Printing multiple parameter descriiption value fields  1325  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 1325
by  DonnaJump to last post
05/12/2014 4:58 PM
9 Replies and 3714 Views Infor Lawson BI - Add new dashboard  3714  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 3714
by  Greg MoellerJump to last post
05/09/2014 1:25 PM
2 Replies and 1732 Views LBI and Cognos  1732  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 1732
by  NabilJump to last post
05/06/2014 12:04 PM
1 Replies and 1370 Views Assign user with an access to multiple reports in Lawson LBI  1370  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 1370
by  Law123Jump to last post
05/06/2014 11:21 AM
1 Replies and 1334 Views Automating Rights Import  1334  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 1334
by  Ken CarleyJump to last post
04/09/2014 2:51 PM
0 Replies and 1270 Views LBI Data Source of Instance Queue Connection  1270  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 1270
03/31/2014 4:26 PM
6 Replies and 1854 Views Report Auditing  1854  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 1854
by  Greg MoellerJump to last post
03/28/2014 4:01 PM
3 Replies and 1458 Views Display burst rights info in report?  1458  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 1458
by  mikePJump to last post
03/19/2014 12:08 PM
0 Replies and 1308 Views Transaction Counts  1308  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 1308
03/12/2014 4:21 PM
4 Replies and 1187 Views Bursting, How can I restrict one group and allow the rest  1187  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 1187
by  amynelsonJump to last post
03/12/2014 1:30 PM
2 Replies and 1544 Views Dashboard module to new tab?  1544  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 1544
by  mark.cookJump to last post
03/10/2014 8:03 AM
3 Replies and 1789 Views PO Comment database location  1789  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 1789
by  dukeslaterJump to last post
03/07/2014 2:19 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 512345 > >>


RSS Feed Available