Last Post
180 Topics and 622 Replies Smart Notification  180  622
RE: Align Columns
by  Randy
12/13/2017 2:52 PM
180 622
RE: Align Columns
by  Randy
12/13/2017 2:52 PM
Search this forum:
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 3 of 9 << < 12345 > >>
 Last Post
1 Replies and 1244 Views Direct reports in non-Lawson report  1244  1 Started by  Greg Moeller Investigating ways to deliver a report via LBI to a select group of managers within our IT department based on their direct reports... Problem is, this is not a Lawson report, it is coming from our Help Desk application database. The database contains employee names. We've hard-coded the names and got a report that works, but it is all manual now as we have to go in and select the manager, run the report, export to pdf, and repeat for the next manager. Can I just build a ri...
1 1244
by  Greg MoellerJump to last post
10/30/2013 3:10 PM
3 Replies and 1281 Views The Value of RW100  1281  3 Started by  JonA Can someone give me an overview of RW100 How is it used From what information I've gathered it seems to be a Financial reporting tool. Does it have any applications for supply chain/procurement What information can it provide that I can't get with Crystal Is it easier than Crystal
3 1281
by  JonAJump to last post
10/30/2013 2:31 PM
2 Replies and 1316 Views LBI back office report error.  1316  2 Started by  Justin R I have a CU201 job in lawson. It is running and building instances (under C:\LawsonDocuments\147_CU201\Instances) of the back office report on the LBI server but when I try to view the latest instance it gives an error. Message: C:\LawsonDocuments\147_CU201\CU201.lxr (The system cannot find the file specified.) I can go in a view historical instances. I am new to this but I've got it to work before but I am testing a second report and haven't gotten it to work yet.
2 1316
by  Justin RJump to last post
10/24/2013 9:37 AM
3 Replies and 1521 Views Passing parameters to report through url  1521  3 Started by  George Graham Trying to set up some reports to run as 'scheduled' every other week so setting them up in windows task scheduler to submit the URL and create a new instance, I have that working fine, including the login, but the report has parameters - and when I try to pass the parameters in the URL it still brings up the window and asks for them to be filled in. Version of RS is 10.1. Here is what is being passed as part of the string: &FiscalYear=2013&AccountingPeriod=4 Those are the parameters define...
3 1521
by  George GrahamJump to last post
10/23/2013 7:06 PM
6 Replies and 1383 Views What table has field SKI_DATE_LST_USED  1383  6 Started by  Donna PA21 Identifies the Received Date as SKI_DATE_LST_USED when CNtrl Shift O is used but I cannot identify the table. Need help locating the field. Thank you. Donna
6 1383
by  DonnaJump to last post
10/08/2013 3:24 PM
3 Replies and 1077 Views Historical Report Instance and bursting  1077  3 Started by  James Deno I'm wondering if someone could help me to understand how bursting works when applied to a historical instance of a report. I have a crystal report that is bursted based a field in the report (user ID) so they can view their page only. The bursting works fine when you select 'view the latest instance', however, once a historical instance is created from the scheduler, it prompts for a user ID and password. If you enter the UID and password at the prompt, it opens the report, but managers a...
3 1077
by  Greg MoellerJump to last post
10/07/2013 11:10 AM
15 Replies and 4408 Views Scheduled Report - must login to view  4408  15 Started by  Roger French LBI 9.0.2 on Windows 2003 Env:&160;Unix, with Oracle DB In reporting services dashboard, when there is a *scheduled* report, the viewer logs into Reporting Services initially. Then the viewer must log in again with Oracle credientials to actually view the *scheduled*&160;report. Is this the way it's supposed to work&160;Having to log in twice to view a scheduled report(Sorry I did not set up this instance of Reporting services). For regular, published reports, the user only need to log i...
15 4408
by  Rob MarshallJump to last post
10/04/2013 12:59 PM
1 Replies and 1094 Views lbi blank rows  1094  1 Started by  AJP Hi Have had issues when the created and saved crystal report which is exported using LBI on a timed session to a user sent by email Every time one is sent - it seems to merge some cells and include blanks on rows and columns periodically Any ideas on how to remove this issue would be good I have tried not suppress & ensure there are no gaps between fields etc Thanks
1 1094
by  RobbyJump to last post
10/01/2013 10:46 AM
0 Replies and 1055 Views LBI and SSL  1055  0 Started by  George Graham I'm missing something right in front of my eyes. Setting up SSL for Lawson environment and have SSL for Lawson application server working fine. But can only get http://lbi/efs/go to work - not https://lbi/efs. SSL has been set up on the LBI sever and installed in WAS. But https just not working. And http still is - logs in just fine. BIggest issue is that lbi is integrated into portal roles as the home page and getting the popup to accept unsecured data with lawson being setup correctly. ...
0 1055
09/29/2013 4:00 PM
2 Replies and 1100 Views LBI: Report Events  1100  2 Started by  Robby Reporting Services offers 4 types of 'Report Events'. These are defined in the UG as a 'user exit that allows for a specific user-defined report task to be performed at a predetermined time.' The one example given is that of a logging program which tracks the amount of time it takes for the report to run. Is anyone out there in Lawson/Infor Guru-land using this feature Can you share a business application that you find useful for this Thanks for your time! -Robby
2 1100
by  RobbyJump to last post
09/17/2013 1:09 PM
3 Replies and 1437 Views Reporting Services - Why would you publish a Non-RPT File  1437  3 Started by  Robby OK, So I've just now realized that there is a selection called 'Non-RPT' File when you go to upload a report in Reporting Services. I looked in the Infor KB to see if something would give me a hint as to when you would want to do this. Seems that you can upload a word doc or excel file (). I can't think of why you would want to Is anyone doing this and why (what is the Business Need) Thanks! :confused:
3 1437
by  dcaianiJump to last post
09/13/2013 3:25 PM
2 Replies and 1583 Views New service for reports on the dashboard  1583  2 Started by  Nancy I am trying to set up a new service that we can use to point to html programs for our dashboards. Ever since we went live our dashboards have the full url to the XHRNET program it is calling. I have been told that we can set up a new service to replace the commom portion of the URL so that if it changes (which we are on the second round of changing) - it only has to be changed in one place. I would like to know what goes in the different fields on the new service screen and what do I ...
2 1583
by  NancyJump to last post
09/05/2013 2:32 PM
1 Replies and 1038 Views Scheduling a Group of Reports  1038  1 Started by  pnaq1120 I was looking to get some help regarding scheduling in LBI. We have about 60-70 reports that we are scheduling at different times each month and was hoping there is a way where these can be scheduled all at once instead of going in to each report one at a time and changing their run times individually.
1 1038
by  Matthew NyeJump to last post
08/26/2013 12:16 PM
0 Replies and 1031 Views query builder timeout  1031  0 Started by  Justin R When ever I click to expand the users to see the jobs it waits for a minute or 2 and then says it can not load. Is this some security issue Another user can expand it just fine.
0 1031
08/14/2013 3:19 PM
3 Replies and 2443 Views LBI crystal report with link to Portal Form  2443  3 Started by  JeanneS How do you create a link in a Crystal Report that is published on a dashboard to link to the Lawson Portal&160; I have a report that contains PO information and I want to create a link so when the user clicks on the PO number it takes them to the PO20.1 form with the PO number from the report auto populated in the PO20.1 form. Thanks! &160;
3 2443
by  Nirav BhattJump to last post
07/22/2013 2:01 PM
2 Replies and 1754 Views Cannot update Crystal Report in LBI  1754  2 Started by  dcaiani Good afternoon, We have a Crystal report, data source is a view built by our IT department. When I run it in Crystal I can get it to refresh after inputting new parameters (date range). I publish it in LBI and I can get to the report via the dashboard, but when I try to refresh and enter a new date range I get the following error message: Failed to open the connection. Failed to open the connection. EE Listing by HM AU with parameter {9C50237D-53A6-411C-A755-7C6B10D036D5}.rpt We have a...
2 1754
by  dcaianiJump to last post
07/16/2013 7:58 AM
2 Replies and 1677 Views LBI report prompt for username and password  1677  2 Started by  Xin Li I have a strange LBI report porblem. I can open the report with 'View with Data Refresh'. However when open the report 'View Lastest Instance' it prompts for username and password. I republished the report, it still has the same issue. However, when I publish the report as a new LBI report, no problem when 'View Latest Instance'. Any help greatly appreciated.
2 1677
by  imtyJump to last post
07/15/2013 6:11 PM
1 Replies and 1108 Views LBI report output to Excel - unwanted merging of cells  1108  1 Started by  clb393 Hello! I've created a report in Crystal 2008 which displays perfectly when exported to Excel. However, when this same report is uploaded to LBI, and then opened in .xls format, cells are being merged. Is there a setting so that i can have it output exactly as it is doing in Crystal Thanks, Chris
1 1108
by  SimoneJump to last post
07/09/2013 2:34 AM
5 Replies and 1240 Views Help with LBI dashboards and crystal reports  1240  5 Started by  Steven We recently purchased LBI so we are still very new to this tool. We have several reports that we need to build right away but don't have the skillsets in house just yet. Can anyone recommend some vendors that I can talk to
5 1240
by  mark.cookJump to last post
07/08/2013 6:47 AM
3 Replies and 776 Views CR hyperlink opening in same window, window keeps shrinking  776  3 Started by  mikeP We have a system of 10 reports set up like a mini-web site, the reports link back an forth to one another in a variety of ways. All the reports are published in LBI with 'Same window' selected for the Hyperlink Targets setting in the report's Output Options. This is the way we want it, and it works well except for one issue: Every time a hyperlink is clicked to invoke another report, the client area in the CR viewer adds another narrow margin, which in effect make the border around the ...
3 776
by  Matthew NyeJump to last post
07/02/2013 2:25 AM
2 Replies and 2205 Views Crystal 2008-Suppress Group Header 1 based on running total in Group Footer 1  2205  2 Started by  AngieP We have a Crystal report that groups employees by Supervisor. There is a running total in the footer that meet specific criteria. For example, a supervisor may have 5 people reporting to them, but none of them meet the criteria. In the footer, that supervisor's running total is 0. We want to suppress that supervisor from displaying if the running total is > 0. We can suppress the footer based on the running total, but not the header. We've played around with different counts, but can't...
2 2205
by  Matthew NyeJump to last post
06/21/2013 11:43 AM
3 Replies and 1067 Views Suppress distribution of Crystal report through LBI?  1067  3 Started by  LisaP I have published a Crystal report to LBI that shows overtime paid, grouped by department, and burst (emailed as an attachment) on a weekly schedule to the head of each department so that the department head only sees their department on the report. Occasionally a department has no overtime for the period, but the report is still distributed to the department head with the page headers and no detail (a blank report with the headers at the top). I have tried to find a way to suppress the distrib...
3 1067
by  LisaPJump to last post
06/13/2013 4:20 PM
5 Replies and 1825 Views Problem with permissions on report services  1825  5 Started by  George Graham We are pushing out links on dashboard for access to historical instances of reports. The users are getting access to these lists with no issue. However, they get a link for 'Details' which gets them to the report details page. We can lock down all of the items via permissions - with the exception of the General Properties. But this gives them the ability to change the report name, description and if it is active or not. I have not found a way to stop this. I've got a case open on this but no ans...
5 1825
by  Jerry MaogJump to last post
06/13/2013 11:06 AM
15 Replies and 2572 Views User Ids in a Report Security group in LBI  2572  15 Started by  Ruma Malhotra I am trying to query the reporting services database to find out the user-ids that are attached to a report security group in LBI. I see that ERS_REPORTACCESS has the access_type and access_value which could be a securitygroup for access type and has an access value associated but cannot seem to find a table that lists the user-ids attached to that report security group. We are on the lates version of Previously these values were stored in a table called ENPUSERGROUPLIST. Does anyone k...
15 2572
by  DonnaJump to last post
06/12/2013 4:45 PM
2 Replies and 1411 Views Using Crystal Reports 2008 to query LBI Schema  1411  2 Started by  Robby Hi All, Anyone ever seen this error message Failed to retrieve data from the database. Details: HYC00:&91;Crystal Reports&93;&91;ODBC Oracle driver&93; Optional feature not implemented When using Crystal Reports 2008 to query the LBI Schemas, I can get some tables, but others result in the error message. How do I fix this Thanks in advance :)
2 1411
by  DonnaJump to last post
06/11/2013 10:01 AM
4 Replies and 2041 Views LBI Crystal Report Hyperlink  2041  4 Started by  James Deno I have a crystal report that has picture objects that are set to hyperlink the user to url. When the user opens the target, it takes them from the report to the correct URL but it won't open that target in a new window. I've found a number of discussions related to this and have tried to implement the solutions. It seems no matter what I do, it continues to open target in same tab and the user then looses the report. I'm thinking this may be a report viewer setting or some other setting with our...
4 2041
by  The.Sam.GrovesJump to last post
06/10/2013 4:15 PM
5 Replies and 1600 Views Suggested Crystal reports techinal forums?  1600  5 Started by  CindyW I'm okay on the basics, but I need help with the trickier stuff. Not sure that this forum here is really for that sort of thing, so just wondering if you guys know of a good active crystal forum. I have a set of books in front of me, and I can usually figure it out, once I get pointed in the right direction! :blush:
5 1600
by  CindyWJump to last post
06/05/2013 3:53 PM
14 Replies and 2540 Views LBI Class  2540  14 Started by  imty Hello All, Can anyone recommend a good LBI course/class that I could take that is comprehensive and covers LBI Administration, interfacing LBI with Crystal and writing scripts to control LBI functionality. This may be a pretty advanced course but if there are introductory courses that encompass these areas, then I could first take the introductory course and progress to the advanced course. I have been using LBI as Admin for the past two years. So, I have a pretty good idea in areas suc...
14 2540
by  GeorgetteJump to last post
06/05/2013 9:47 AM
6 Replies and 1674 Views My Reports tab in LBI/Framework Services  1674  6 Started by  Robby Hi All, I'm seeing LBI 10-1-10-0-1 for the very first time. New install, still setting up for go-live in a few weeks. My previous experience tells me that the Tab 'My Reports' is visible for any user who is assigned reports as 'Report User'. Only - there is no tab showing up... Am I missing something &91;PS, the 'install' was done by someone else...did they overlook a step&93; Thanks in advance! Robby
6 1674
by  Greg MoellerJump to last post
05/31/2013 1:32 PM
4 Replies and 1114 Views Upgrade LBI 904.2 to 10.1.x  1114  4 Started by  Greg Moeller Something that we've noticed is on the schedule the 'Burst Report' check box has been intermittently unchecked by the upgrade. In conjunction with this the check box for Default Permissions (in the schedule) the box for 'Ability to view with refresh data and view with saved parameters' is also unchecked. Everywhere that we find the 'Burst Report' box being unchecked where it should be checked, we are also finding the second box unchecked. Is there any report that I can run that would indicate...
4 1114
by  Greg MoellerJump to last post
05/29/2013 9:18 AM
11 Replies and 2528 Views LBI Schedule runs but report is not produced  2528  11 Started by  Jan Hello I've got a situation where my cyrstal report published and scheduled into LBI occasionally does not produce a report. This is a long-running report that has not been updated for over a year. Typically the report schedule runs and the report is produced just fine. But lately, but not in all occasions, the report schedule says the report ran but the report is not produced. In these cases, I'll wait an additional day to make sure the report doesn't produce, but it never does. I then r...
11 2528
by  RobbyJump to last post
05/28/2013 6:30 AM
2 Replies and 1221 Views Delivery Device Audit  1221  2 Started by  Greg Moeller I'm trying to write a delivery device audit report. Does anyone know which table and fields I would need I've found the email address listed in a couple of tables and would like the login name, the delivery device name, and the address. Is the EFSDOCUMENTS.DOCNAME the appropriate field to use for the delivery device name How do I tie that back to the login id
2 1221
by  Greg MoellerJump to last post
05/24/2013 9:24 AM
5 Replies and 1240 Views Analyzing Report Activity in LBI  1240  5 Started by  Donna We would like to create a report that shows the number of times a report has been run and the last date it was run. Has anyone prepared a query or a report that provides this information
5 1240
by  WillJump to last post
05/04/2013 4:52 PM
11 Replies and 3291 Views Page Setup or Print takes over a minute to open in Crystal  3291  11 Started by  Mary Porter When we access Page Setup while in Crystal it takes over a minute to come up - the same thing when we click on Print - has anyone ever had this happen before It happens to all of us that are developing reports in Crystal Reports 2008.
11 3291
by  Mary PorterJump to last post
04/29/2013 4:58 PM
1 Replies and 1437 Views Converting Crystal Rpt criteria (sql) over to Lawson 4GL...HELP  1437  1 Started by  Sarah Good afternoon. We have a weekly file that goes to our medical insurance carrier and tells the carrier: 1. Employees that have current medical, dental and\or fsa\hsa plans with a row for the employee and a row for every dependent that is attached to the plan(s). 2. Employees that have changed medical, dental and\or fsa\hsa plans with a row for the employee and a row for every dependent that is attached or ended their plan(s). If I populate the crystal report sql and record selection, group...
1 1437
by  Ragu RaghavanJump to last post
04/29/2013 11:12 AM
3 Replies and 2177 Views Microsoft Reporting Services vs. LRS on LBI  2177  3 Started by  Joe O'Toole We have LBI running a number of Crystal reports but the bulk of our corporate reporting outside of Lawson is done with Microsoft Reporting Services. Because this is a company standard and reports are easier to deploy, schedule and maintain in MSRS we are considering moving new Lawson report development to MSRS. Has anyone used both MS RS and Crystal with Lawson that could offer their experiences We are curious about any limitations encountered with Crystal and MS RS accessing both Lawson and no...
3 2177
by  Joe O'TooleJump to last post
04/23/2013 6:14 PM
3 Replies and 1299 Views Report DataSource Override  1299  3 Started by  Greg Moeller How would one do that
3 1299
by  Greg MoellerJump to last post
04/19/2013 9:48 AM
7 Replies and 1532 Views YTD MM280 to Crystal using Lawson OLE DB  1532  7 Started by  Latoria We have a Crystal report built that uses the MM280 as a datasource. We have been able to successfully run the report to pull in 5 months of data, but when we add a 6th month, it errors out. Has anyone ever experienced or know of any limitations on data size or run time using the OLE DB connector that would cause the report to throw an error Crystal is describing it as a parsing error, but the individual monthly reports run fine--with no errors. Infor Support has told us to just split the rep...
7 1532
by  MichaelJump to last post
04/18/2013 3:58 PM
1 Replies and 1032 Views reporting Services>Delivery Administration  1032  1 Started by  Robby When running a delivery test for a users' email setup, the text in the body of the test email says 'Test email delivery successful!' Can that wording be changed To something like-- Please contact the LBI Administrator, Sally Soso, when you receive this test email. OR--- What happens when its a bad email address I tested, and so far no bounce-back to the admin email inbox...
1 1032
by  Greg MoellerJump to last post
04/18/2013 9:26 AM
5 Replies and 1375 Views Suppress the decimal point, keep the decimal numbers  1375  5 Started by  Mary Porter The record layout for one of our benefit carriers wants the contribution amount to have an implied decimal. I tried toText((ER_Match),2) but that still leaves the actual decimal place. Has anyone ever had to do this
5 1375
by  Mary PorterJump to last post
04/16/2013 12:26 PM
2 Replies and 985 Views Reporting Services  985  2 Started by  Robby Occasionally a user will log a trouble ticket saying that they are not getting a report they used to get. So, checking the schedule for that report I see that they are still designated as a user, and the 'Recipient(s)' field is still showing 'All Report Users and Roles' I'd like to be able to check their subscription status to see if they clicked the unsubscribe link and forgot :-(
2 985
by  RobbyJump to last post
04/11/2013 5:31 PM
3 Replies and 1038 Views Reporting from LBI Data Schemas  1038  3 Started by  Robby Hi All, It seems that it could be very useful to know things like 'Who is in This or That Custom Group', or when was the last time so-and-so Infoset was updated So, my question is this....Do you have some queries against the LBI Schemas that have proven useful for your end users or for your 'LBI Administrator' Care to share :-)
3 1038
by  GeorgetteJump to last post
04/04/2013 6:31 AM
1 Replies and 1442 Views Looking for the SQL behind a program in M3  1442  1 Started by  Vilfred I want to make reports with Crystal Report. Have find table using MDP. In program MOS320 I want to find the key to table used (CSYTAB), but I don't know the key filtered on. If I could take out the sql behind the program, I beleve I will see this. How can I find the sql behind each program in M3 my kind regards Vilfred.
1 1442
by  Ellen BatsJump to last post
04/03/2013 9:10 AM
3 Replies and 1001 Views Server Migration and Report File Reloacation  1001  3 Started by  SP Has anyone out there ever migrated from one LBI system to another and included a physical relocation of report files My obvious first concern is CLOBs and GLOBs. :-( Any experience with this is greatly appreciated. Infor has recommended a HW upgrade which would take us to 64-bit. Additionally, they have suggested that we consolidate from 2 production LBI instances to a single LBI instance, and from 5 RAS instances to just 3 on beefier hardware. A previous Infor consultant performed t...
3 1001
by  Ruma MalhotraJump to last post
03/25/2013 2:24 PM
1 Replies and 929 Views LBI Calendar pop-ups - shows blank page  929  1 Started by  Deelight When clicking on the calendar button next to a date field, it pops up a 'blank page' screen instead of a calendar. This seems to be isolated to my PC only. Has anyone else encountered this and what was the fix We are on LBI Thanks
1 929
by  Matthew NyeJump to last post
03/21/2013 2:36 PM
5 Replies and 1953 Views Lawson Crystal Reports and Prod Verses Dev  1953  5 Started by  Layne In developing Crystal Reports and their associated Views, Stored Procedures, and SQL Commands, where do most of you do your work Do you do most of it in a Lawson Development Environment and then transfer all needed SQL and RPT files to Production, or simply do your work in Production to start with If you needed to maintain a Development Environment so your users could always have access to all of your reports, how do you keep the Production and Development Product Line Crystal Reports, Views...
5 1953
by  Matthew NyeJump to last post
03/21/2013 6:11 AM
3 Replies and 1343 Views Service Date  1343  3 Started by  Rirruto Good Afternoon, I am trying to get the date in which an employee entered their current position, whether it be through a transfer or if they were hired into the position. The date can be seen in PA10.1 Length of Service and is called Service Date. I cannot click on it to find out what table and field I can find it in through Crystal. Can anyone help
3 1343
by  RirrutoJump to last post
03/15/2013 2:50 PM
4 Replies and 1307 Views LAWSONRS_CurrentUser can be changed on refresh report  1307  4 Started by  Richard Bergheim Hi, how can i prevent that the LAWSONRS_CurrentUser parameter can be changed on refresh report. Is it possible to disable the refresh button (something like GroupTree=False) thx, Richard
4 1307
by  GeorgetteJump to last post
03/12/2013 7:20 AM
5 Replies and 1362 Views User structure / rights  1362  5 Started by  Greg Moeller Anyone out in Guru-Land have a Crystal report or a SQL statement used to extract the 'Maintain Rights' for all of the users that they would be willing to share Structures / Groups / Etc I'm not even sure where to start, I've been away from this for too long. Thanks in Advance, -Greg
5 1362
by  Greg MoellerJump to last post
03/08/2013 12:58 PM
6 Replies and 1676 Views Unsubscribed user - how to resubscribe?  1676  6 Started by  David Levine Hello, A user has accidentally unsubscribed to a scheduled report (by clicking on the Unsubscribe Link). Strangely, we're unable to resubscribe her. Some notes: despite clicking on the link, her name still appears as on the distribution list in the Schedule Options-->Report Users list. Additionally, we've tried removing her name from the list and re-adding it, as well as creating a new schedule. Any thoughts on how to proceed, short of republishing the report or publishing as a new report ...
6 1676
by  RobbyJump to last post
03/05/2013 3:00 PM
3 Replies and 1477 Views RW100 Report to Crystal via Lawson OLEDB  1477  3 Started by  Racquetbal I am hoping someone can help me bring in a RW100 report into Crystal via the Lawson OLDEDB. In the RW100 report I do have the box checked to 'Y' on the Xtra XML area and have style 1 only. I do have the Lawson Query Builder 9.0.5 version and do select the 'Report' option under 'Select Command'. When I go over to the report and try to exeute I am getting the following error: Error&91;A document must contain exactly one root element.&93; occured while parsing XML response &91;1&93;,Col&...
3 1477
by  Ruma MalhotraJump to last post
03/05/2013 12:41 PM
5 Replies and 1381 Views LDAP Bind with LBI  1381  5 Started by  Roger French Setting up the LDAP bind with LBI FS. Not using DSSO. Windows 2008 Env = LBI v 9.0.4.x So, in setting up the Authentication Service, I choose LDAP and fill out the LDAP Bind parameters and credentials which I have. Under the 'Administrative Role' what goes in that Thank you, Roger
5 1381
by  Matthew NyeJump to last post
03/05/2013 9:02 AM
6 Replies and 1884 Views Tools dashboard  1884  6 Started by  Greg Moeller It's been quite a while since we set LBI up here, so I'm a little fuzzy on the way it was done. We are trying to share the Tools dashboard with some non-Administrators. Shouldn't I be able to just edit the Sharing of the dashboard and include a group to which they all belong, or is this a special Admin-only dashboard TIA, -Greg
6 1884
by  GeorgetteJump to last post
03/05/2013 8:38 AM
11 Replies and 1298 Views Disconnect between LBI role and right  1298  11 Started by  imty Hello group, I published a Crystal Report in LBI and am trying to burst it by 'Location.' I have outlined in the attached document, screen shots of the steps taken in publishing this report in LBI. The issue is that there appears to be a disconnect somewhere causing a hiccup. When I try running the report in LBI using 'View with Data Refresh', it seems to work fine. However, when I try using View Latest Instance or try to run it from the dashboard link I am being prompted for a userid and...
11 1298
by  imtyJump to last post
02/26/2013 6:02 PM
2 Replies and 1210 Views Best way to pull accurate received date for Requisition line item.  1210  2 Started by  Normajean Hello Lawson folks; I am a new member of the Enterprise data warehouse team and am working on the Lawson Supply Chain project. Prior to my coming on board logic had been written to pull the received date for requisition line items by using the following process: 1. join to polinesrc to get the ponumber\poline number for the requisition line (Join is polinesrc.source_doc_n = reqline.req_number and polinesrc.src_line_nbr = reqline.line_nbr) 2. join to porecline to get the received date for t...
2 1210
by  NormajeanJump to last post
02/19/2013 12:44 PM
1 Replies and 1892 Views Introduction of Lawson Smart Reports  1892  1 Started by  Ruma Malhotra Introducing Infor Lawson Smart Reports Posted: 21 Nov 2012 03:00 AM PST By Matthew Albee I am pleased to introduce a new no charge component, Infor Lawson Smart Reports. Infor Lawson Smart Reports is designed to make Infor Lawson reports beautiful. Infor Lawson Smart Reports enables the configuration of Infor Lawson standard report output to match a customer’s report styling requirements. For example, Infor Lawson Smart Reports enables report styling such as adding a company logo, bold, it...
1 1892
by  George GrahamJump to last post
02/07/2013 11:51 AM
0 Replies and 969 Views LBI  969  0 Started by  thummel1 My LBI report is reading from a Crystal report. The Crystal Report displays the information just fine...There are columns that contain paragraphs of text. When I run this report in LBI it only returns the first two letters of the paragraph. I don't know if this is an LBI Issue or a Crystal reports issue Resources for this kind of issue are limited, so I am hoping to get a couple tips
0 969
02/06/2013 12:24 PM
11 Replies and 1414 Views SQL Expression Changes - Unix Server to Windows  1414  11 Started by  FireGeek21 We are undergoing a change in environments that our Lawson system resides on - moving from a Unix/Oracle environment to a Windows/SQL environment. During testing, I noticed my Crystal Reports that have SQL Expressions in them are no longer working. A sample SQL Expression I have: (SELECT 'LAWSON'.'HREMPUSF'.'A_FIELD' FROM 'LAWSON'.'HREMPUSF' WHERE 'LAWSON'.'HREMPUSF'.'FIELD_KEY = 78 and 'LAWSON'.'HREMPUSF'.'COMPANY' = 'EMPLOYEE'.'COMPANY' and 'LAWSON'.'HREMPUSF'.'EMPLOYEE' = 'EMPLOY...
11 1414
by  RobbyJump to last post
02/06/2013 8:27 AM
16 Replies and 2084 Views Publishing in LBI a Crystal Report reading LTM Database via LAWSON OLEDB Connector  2084  16 Started by  ric9d I am trying to publish a Crystal Report which used Lawson OLEDB to connect to LTM. This report is different as it is using 'previously built relationships' in LTM. I was able to create a DataSource and tested it to be valid (pointing to correct server). However when I try to publish it and change the datasource (in data setup in LBI) the newly created datasource does not appear as one of the selections. The report itself on a stand alone basis (in Crystal) work fine. Is there any...
16 2084
by  ric9dJump to last post
02/06/2013 8:26 AM
3 Replies and 1140 Views LBI Structure / Framework For Maximum End User Flexibility  1140  3 Started by  Eric D I know lengthy posts often get glossed over so I tried to provide the quick, to the point post and then if needed, the background for the much appreciated person that responds. THE PROBLEM: Looking for guidance on setting up a framework or structure that will provide non-technical users flexible and 'unmanaged' ability to add/edit/remove documents, spreadsheet, and reports. Looking for a high level 'dashboard' to provide the structure / hyperlinks / relationships of more detailed documents....
3 1140
by  Matthew NyeJump to last post
02/05/2013 1:36 AM
5 Replies and 2083 Views HISTORICAL INSTANCE ON LBI DASHBOARD?  2083  5 Started by  Gary Gasta We have created a reporting dashboard for our leadership to roll out monthly reports. The dashboard is updated when the new month is complete/run. Under LBI the admins can get to the 'historical' instances but we are not clear on how to allow the end users with limited rights access to the past reports. Hopefully this is a simple process that we have overlooked. Can anyone help please Thanks. I have attached a .jpg of our dashbaord. Most of the reports on the right have 'historical...
5 2083
by  MelissaJump to last post
01/18/2013 1:07 PM
9 Replies and 5774 Views Crystal reports hyperlinks in LBI  5774  9 Started by  mikeP I have a series of Crystal 10 reports running on an LRS server that contain hyperlinks to other Crystal reports. Our provider is upgrading to LBI 9.0.3 and CR 2008, and I can't get the hyperlinks to work. The hyperlinks are specified as 'A website on the internet' and the URLs are created using a formula like this: formula = 'http://server:port/efs/FSRemotefsid=RS:RS-Lawson LRS/LBI Server:543&Loc=' & {Command.CODE} In this example, 543 is the ID assigned to the target report wh...
9 5774
by  JillFJump to last post
01/09/2013 10:59 AM
3 Replies and 5023 Views Overcoming the 65,536 row limit in Excel  5023  3 Started by  JonA I'm running Crystal XI and exporting (data only) to Excel 2010 but when the number of records exceeds 65,536 the report gets broken up into multiple sheets. I have to How can I overcome this I'm thinking it's hard coded into Crystal XI and I may need to upgrade to a newer version.
3 5023
by  JonAJump to last post
01/04/2013 2:00 PM
2 Replies and 1601 Views Copying LBI PROD Data to DEV  1601  2 Started by  ric9d Is there a step by step process to copy LBI PROD DATA (settings, reports, definitions, users, etc) to DEV
2 1601
by  ric9dJump to last post
01/03/2013 1:07 PM
2 Replies and 1411 Views How does Crystal determine the rowcount in excel?  1411  2 Started by  imty Hello All, I guess this forum is primarily for LBI questions, but I have a Crystal question that I thought someone may know the answer to. Here's the question: I have a Crystal report that I export to excel 97/2003 xls format. When the report data is exported it encompasses more than one page due to the 65536 row limitation. We have tried to upgrade to Crystal 2010 which allows to export as an xlsx file without the 655236 row limitation being encountered as with 97/2033 xls file format. Un...
2 1411
by  imtyJump to last post
12/26/2012 3:47 PM
10 Replies and 1786 Views crystal reports/LBI dynamic data  1786  10 Started by  DougAB i'm new to crystal and LBI....from initial testing, it seems we only get static data when we run our Crystal Reports. It's my understanding we can schedule times to refresh the data which is nice, but i am looking for a way for our users to get up-to-date data on these reports when they open them. Is there a way to do this using either Crystal or LBI Thanks, Doug
10 1786
by  Matthew NyeJump to last post
12/14/2012 10:28 AM
4 Replies and 2178 Views Crystal Report Drill Down capability from LBI  2178  4 Started by  imty Hello All, We have several Crystal reports published to LBI that currenlty do not have drill down capability. How can we allow drill down capability to the reports that can be drilled down I look forward to your suggestions on how to go about doing this. thanks in advance, imty
4 2178
by  Gary GastaJump to last post
12/13/2012 1:29 PM
5 Replies and 1632 Views Scheduled Crystal Report not be sent out.  1632  5 Started by  Deleted User We just upgraded to Lawson 9.0.1 from 9.0.0. We have a custom Crystal Report that's been running daily out of Reporting Services to a printer. The printer is really a folder for report 2 web. After the go live we noticed the report was not getting sent to the 'printer'/folder. I was able to perform a device test which made it to the folder however even though the report shows it ran nothing is going out to the folder. I checked the systemout.log and found the following message. 'Error prin...
5 1632
by  Matthew NyeJump to last post
12/04/2012 11:54 AM
5 Replies and 1206 Views Import of delivery devices  1206  5 Started by  Greg Moeller Does anyone out there have a process for automating the delivery device import We can create the file(s).... but how do we import automatically from a script Is there a different way to do this Process Flow perhaps Any suggestions TIA, -Greg
5 1206
by  Greg MoellerJump to last post
11/28/2012 9:47 AM
2 Replies and 1138 Views Report runs in TEST but not in PROD  1138  2 Started by  Robby When I upload and run this report (and others, I've even tried re-writing the report to see if that is an issue) in TEST, it runs fine. When I upload and run in PROD (changing the datasource, of course) it will stop and ask for the default user and password. This does not happen for every new report. AND, I tried this: re-wrote one of the reports to limit the output to 4,000 rows, and it ran OK. Then I re-wrote to allow it to output the full report (about 45,000 rows) and it got stuck again...
2 1138
by  RobbyJump to last post
11/26/2012 8:25 PM
19 Replies and 4286 Views Create report based on report user employee hierarchy  4286  19 Started by  agersh I need to create a crystal report of employee related data. The report will be viewed by various levels of management, Managers, Directors, AVP or VP. One of the report criteria requested is that the report only display data for the employees that fall under the user running the report. So for example if a Director is running the report, the report should only include the employees that are under that director’s organization chart hierarchy. Using Lawson LBI Bursting option, the crystal report ...
19 4286
by  WillJump to last post
11/26/2012 7:09 AM
2 Replies and 1219 Views Connection to MS Access 2007  1219  2 Started by  Greg Moeller In this case, I'm trying to hook up an LBI published report to use an Excel 2007 spreadsheet as it's source of data. I keep getting prompted for a default User ID and password when running with a data refresh. Any pointers on how to set this up would be appreciated!!!!
2 1219
by  Greg MoellerJump to last post
11/06/2012 1:23 PM
13 Replies and 3529 Views Schedule sending (not Bursting) a crystal report via Email to report users  3529  13 Started by  agersh I have a crystal report that I would like send/distribute (not Burst) via Email to the Reports Users assigned access to the report. I created a report schedule using the following Bursting and Distribution settings/values. The Report Services Administration->Report Management-> Maintain Report Schedules screen has the schedule listed, Status = SUCCESS and the Last Scheduled Run column show the schedule did run but I did not get an email. Anyone have idea what the issue could be Schedu...
13 3529
by  DeelightJump to last post
11/06/2012 10:23 AM
11 Replies and 4165 Views Back Office Report as source for Crystal  4165  11 Started by  vc727 Can anyone point me in the right direction for plain english instructions on how to use back office reports as a source for a crystal report I have been told it can be done but can't seem to find anyone who can tell me how. I have looked in the LRS manual but it is not clear to me if it is in there. I am trying to take some of the data from PR260 and make some calculations on it for our benefit department.&160;
11 4165
by  gsusnmeJump to last post
10/30/2012 4:22 PM
2 Replies and 1178 Views Output file names for bursted reports  1178  2 Started by  barbs Hi, When a report is bursted, an output file is created in LBI. I believe it uses the report name, and a generated sequential number as part of the output file name. Is there a way to customize the file name In my case, I burst the report by store number. Is there a way to add the store number to the name of the output file Any help would be appreciated. Barb
2 1178
by  barbsJump to last post
10/18/2012 12:21 PM
4 Replies and 2075 Views Any issue using PAEMPPOS table to evaluate FTE?  2075  4 Started by  Sarah Hello. I posted this on another board but realized this may be the better place for this question. I am testing a new eligibility file that will be going to a vendor. We are required to send current employees who are eligible, employees who were eligible but are now ineligible because of a status change (old FTE>=.40 and newFTE<.40), or they termed in our system. The ineligible employees only need to pass on the file once. Below is the criteria in a crystal report I put together (EM...
4 2075
by  Paul BerkowitzJump to last post
10/18/2012 10:24 AM
8 Replies and 3203 Views Create LBI user access rights in Crystal  3203  8 Started by  imty Hello All, I am trying to create a crystal report that shows the users' and their bursting rights. This report is necessary so that payroll reports which are in our AS400 system can be mapped to this crystal report in LBI so that each user has access to the payroll report for their cost center only. I would appreciate if you could kindly enlighen me as to how I can locate the tables in LBI or whereever it may reside that holds the users' and their bursting rights in order to create the Cry...
8 3203
by  ChrisJump to last post
09/27/2012 9:27 AM
5 Replies and 2682 Views Reporting on LTM CLOB field  2682  5 Started by  S Eckerson The users have requested that the comments that are stored in the auditlog field from LTM.workassignment be included in a Crystal Report. Attempts from SQL or Crystal Reports to extract the information needed from the CLOB field have been unsuccessful. Has anyone out there found the key to extracting the data Thanks for any and all ideas!
5 2682
by  NabilJump to last post
09/13/2012 2:58 PM
8 Replies and 3002 Views LBI 500 internal server error  3002  8 Started by  Xin Li We are experiencing following odd error for LBI. if you loggoed out Portal and logged in back, the LBI link in portal does not work again and it gave '500 internal server error'. We have to close all I.E. session and restart I.E., then LBI link in portal works again. We are using IIS as our LBI web server, Anyone has any solution
8 3002
by  Xin LiJump to last post
09/11/2012 4:49 PM
3 Replies and 1579 Views LBI Dashboard Module  1579  3 Started by  imty Hello All, I have four dashboard modules in LBI. Each module represents a payroll period. In some months we have only three payroll periods (two Actual and one Accrual ). In those months where there is only three payrolls, how can I hide the fourth payroll dashboard module. Is there a way to do this Any thoughts on this is much appreicated. Please see attached screen shot. Thanks in advance. Imtiaz.
3 1579
by  imtyJump to last post
09/11/2012 12:38 PM
6 Replies and 3555 Views Create Crystal Report with Excel Data and Upload to LBI  3555  6 Started by  imty Hello Group, I'd like to know if it is possible to Create a Crystal Report that retrives data from an excel spreadsheet via an ODBC connection. Publish the Crytal report into LBI and allow users' access based on their authorization. This data is actually LBP (Lawson Budget Planning) data that is exported to an excel spreadsheet. Any suggestions is much appreicated. Please see attachment of sample data. thanks, Imtiaz.
6 3555
by  imtyJump to last post
09/06/2012 1:13 PM
6 Replies and 1630 Views Events and Crystal Parameter page  1630  6 Started by  KevinH After reading a couple of posts in this forum on how to capture LBI reporting statistics, we decided to experiment with using the events in Reporting Services. We built a server side program and it's working properly -- we have it set to be called on the Report Request Received event for Every Report Request on several of our crystal reports. If the crystal report has no parameter page, everything works smoothly. However, if the report has a Crystal Parameter page (which is the majority of ou...
6 1630
by  KevinHJump to last post
08/30/2012 2:07 PM
13 Replies and 1774 Views Crystal 2008 and LBI Drill Around  1774  13 Started by  Katfra I'm currently publishing a Crystal report to a dashboard and unable to drill around when i click a cell in the report. I'm using Crystal Reports 2008 and receive the following error. - <response version='1.0' status='400'> <message code='505' description='Service ERP-LawsonPortal-login does not exist in FS Respository.' type='ERROR' /> </response> I was able to get the same report to drill around before we upgraded to 2008 by using Crystal XI. I'm using the same ...
13 1774
by  KatfraJump to last post
08/30/2012 6:57 AM
4 Replies and 1599 Views Formula based on the Group Level  1599  4 Started by  David V Below is an example. I do not want to use the Summary function, because in some cases I want to manipulate the data. Table = POLINE Group 1 = Company Group 2 = Vendor Group 3 = Item I want a single formula that can do the following... If (Group Level 1) Sum By Company If (Group Level 2) Sum By Vendor If (Group Level 3) Sum By Item This way I do not have to create 3 seperate formulas.
4 1599
by  David VJump to last post
08/27/2012 10:48 AM
0 Replies and 1169 Views Lawson LDAP Connection from SQL  1169  0 Started by  Layne Does anyone have an example of connecting to ADAM LDAP from SSMS using a SQL Script
0 1169
08/23/2012 12:45 PM
2 Replies and 3277 Views LBI logout  3277  2 Started by  Display Name We are looking to resolve a concern where the LBI dashboard page does not have, nor does it allow for, log out functionality. We are on of LBI running on Windows 2008 server. Previously on 9.0.3, we embedded a call into the webpage so that when the LBI IE window was closed, it would redirect to a link that would allow logout of LBI using the format It no longer will accept that scri...
2 3277
by  Display NameJump to last post
08/23/2012 9:10 AM
0 Replies and 1120 Views Roster for Doctors/Nurses  1120  0 Started by  Vijay S Is there a way to prepare Roster(Time Table) for doctor and nurses in Lawson Thnx, Vijay
0 1120
08/20/2012 10:42 PM
2 Replies and 1434 Views Bursting Multiple Reports with one Report Schedule?  1434  2 Started by  ric9d I have several reports that I burst to the same group of people every month. The way things are currently, they will get 1 email for each report. There bursting rule is one and the same for all these reports. Is there a way to burst the reports in 1 email or in other words, burst several reports in 1 schedule Again, all these reports are using the same bursting rule. Thank you in advance. Ric
2 1434
by  ric9dJump to last post
08/13/2012 8:53 AM
0 Replies and 3150 Views Lawson Smart Reports  3150  0 Started by  jay69277 Hello Lawson Community, I have a couple of questions regarding Smart Reports or LSR which ever you prefer. My question is that when I publish a report using LSR it just disappears, and I can't find the report. I am not sure if I have a wrong setting any help with this would be great. My next question is the LDAP query I have it configured using the same setting that I used in LBI minus the LDAP stings for the server name. I used the server name :389 and the LDAP username, and used the f...
0 3150
08/03/2012 3:51 PM
5 Replies and 1831 Views Reporting Services database  1831  5 Started by  Robby I was sure this would have been discussed somewhere on this board, but all I could find were references to the tables and building reports from the RS or FS database. I personally do not have access to the reporting server, so I will need to be able to explain the connection process to another person (at our technology partner). Can someone help me with this Thanks in advance :D
5 1831
by  Greg MoellerJump to last post
08/03/2012 3:29 PM
9 Replies and 2388 Views LBI Report Users II  2388  9 Started by  Greg Moeller Hey all: I think I need to start a new post, to get back to the original question asked by Jan. Where to find the Report Users I've been able to find the Report Users that are configured on the main Report screen, but when you go to set up a schedule, these (can be) a different set of report users. My PM really needs the set of report users associated with the schedule to do an efficient job of cleaning up our reports. Which tables can I (an possibly Jan) look to find this informatio...
9 2388
by  ric9dJump to last post
07/30/2012 1:30 PM
9 Replies and 1923 Views Create a reporting data store with production data  1923  9 Started by  mwilliamson We are wanting to create a sql server data store pumping production data to if for reporting purposes. I know I will need to change the LBI datasources to point to the new server and the published Crystal Reports data sources will need to be changed to point to the new server. Amy I missing anything We have all 3 application suites, not sure how often to refresh the data, more than once per day Has anyone had any experience with this
9 1923
by  Greg MoellerJump to last post
07/30/2012 10:47 AM
1 Replies and 2476 Views IE9 with LBI 904  2476  1 Started by  KevinH Although I see that Internet Explorer 9 is not listed on the compatibility matrix for LBI 904, just wondered if anyone has tried using IE9 with that release.If so, did you encounter any issues
1 2476
by  WillJump to last post
07/24/2012 2:31 AM
1 Replies and 1876 Views Reports timing out in conversion from Oracle to SQL server DB  1876  1 Started by  Margie Gyurisin We are upgrading our Lawson applications from 900 to 901 and are moving from Oracle to SQL server as our DB. We are running into issues with converting our Crystal Reports and Access queries. Some of our Crystal Reports run for over an hour now without returning data - we usually kill them at that point. We have also been receiving errors like this - Databse Connector Errofr '42000:&91;microsoft&93;&91;odbc sql server driver&93;&91;swl server&93; The transaction log for database 'tempd...
1 1876
by  John HenleyJump to last post
06/29/2012 5:40 PM
0 Replies and 1120 Views PSA Data  1120  0 Started by  amynelson Does anyone have any experience writing reports against PSA tables If so, would you be willing to share what you know about the data tables
0 1120
06/25/2012 11:00 AM
2 Replies and 1856 Views Can I reference data in a published LBI spreadsheet in a Crystal report also published in LBI?  1856  2 Started by  Jan Hello I'd like to create a Crystal report that uses dates in another published LBI report in order to select data. The Crystal selection could be done via parameters that are pulled from this separate report. The separate report would be an Excel spreadsheet that I create by hand and upload and publish into LBI. The only purpose for this spreadsheet would be to supply dates to my Crystal report. I'm asking this question because I've been told this is possible but I don't know how to do it...
2 1856
by  ric9dJump to last post
06/25/2012 10:26 AM
1 Replies and 1948 Views Scheduled Reports in Excel Format (via Email)  1948  1 Started by  ric9d I have a report schedule that spits out emails with the report attached in Excel format in lbi. My problem is: the resulting report is only diaplying the page header for the first page. In Crystal Reports stand alone, when you try to export a report into a Excel file, a window will pop up that prompts if you want to 'Display Header in first page only'. this is the default by the way. Since a schedule report in LBI will not prompt the user, it uses the default setting. Is there a way to manip...
1 1948
by  ric9dJump to last post
06/22/2012 10:50 AM
1 Replies and 1712 Views Vendor Address Defaults  1712  1 Started by  dukeslater I'm having trouble figuring out the logic for returning the default addresses for each vendor. For example, in APVENMAST vendor 8 is 3M. Both the REMIT_TO_CODE and PURCH_FR_LOC are null. In APVENADDR vendor 8 has 36 addresses, all have CUR_ADDR = Y. Each has a different location code, but only about 10 of the vendors have an address with the location code I would consider our 'home' location. If the location fields in APVENMAST are null, how would I return the default addresses (fo...
1 1712
by  JonAJump to last post
06/22/2012 10:10 AM
4 Replies and 1937 Views LBI html report  1937  4 Started by  khart Has anyone used a html report in LBI that is updated on a regular basis This html file will be updated daily and I was hoping to access it by LBI instead of a portal bookmark. I have created new LBI reports with a html file but since the html content does not change this has not come up before now. It looks like I would have to republish it daily which is not practical. There is not any syntax hints for the Address field either. From LBI manual: 'URL Reports You can use this feature...
4 1937
by  khartJump to last post
06/15/2012 2:38 PM
0 Replies and 955 Views Panelists wanted for a Focus Group on Performance Management and Continuous Feedback  955  0 Started by  sathiya Synergita is conducting a market research study among HR professionals on Performance Management and Continuous Feedback. The Focus group is scheduled on June 7th 2012, at 1.30 PM US Eastern Time. HR Professionals interested in participating as a panelist, please contact
0 955
06/02/2012 3:45 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 9 << < 12345 > >>

RSS Feed Available