Forums
 Topics
 Replies
 Last Post
179 Topics and 618 Replies Smart Notification  179  618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
179 618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
Search this forum:
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 3 of 9 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
2 Replies and 1284 Views LBI back office report error.  1284  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 1284
by  Justin RJump to last post
10/24/2013 9:37 AM
3 Replies and 1489 Views Passing parameters to report through url  1489  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 1489
by  George GrahamJump to last post
10/23/2013 7:06 PM
6 Replies and 1340 Views What table has field SKI_DATE_LST_USED  1340  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 1340
by  DonnaJump to last post
10/08/2013 3:24 PM
3 Replies and 1034 Views Historical Report Instance and bursting  1034  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 1034
by  Greg MoellerJump to last post
10/07/2013 11:10 AM
15 Replies and 4333 Views Scheduled Report - must login to view  4333  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 4333
by  Rob MarshallJump to last post
10/04/2013 12:59 PM
1 Replies and 1045 Views lbi blank rows  1045  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 1045
by  RobbyJump to last post
10/01/2013 10:46 AM
0 Replies and 1016 Views LBI and SSL  1016  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 1016
09/29/2013 4:00 PM
2 Replies and 1065 Views LBI: Report Events  1065  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 1065
by  RobbyJump to last post
09/17/2013 1:09 PM
3 Replies and 1391 Views Reporting Services - Why would you publish a Non-RPT File  1391  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 1391
by  dcaianiJump to last post
09/13/2013 3:25 PM
2 Replies and 1533 Views New service for reports on the dashboard  1533  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 1533
by  NancyJump to last post
09/05/2013 2:32 PM
1 Replies and 1010 Views Scheduling a Group of Reports  1010  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 1010
by  Matthew NyeJump to last post
08/26/2013 12:16 PM
0 Replies and 998 Views query builder timeout  998  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 998
08/14/2013 3:19 PM
3 Replies and 2410 Views LBI crystal report with link to Portal Form  2410  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 2410
by  Nirav BhattJump to last post
07/22/2013 2:01 PM
2 Replies and 1714 Views Cannot update Crystal Report in LBI  1714  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 1714
by  dcaianiJump to last post
07/16/2013 7:58 AM
2 Replies and 1633 Views LBI report prompt for username and password  1633  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 1633
by  imtyJump to last post
07/15/2013 6:11 PM
1 Replies and 1087 Views LBI report output to Excel - unwanted merging of cells  1087  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 1087
by  SimoneJump to last post
07/09/2013 2:34 AM
5 Replies and 1194 Views Help with LBI dashboards and crystal reports  1194  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 1194
by  mark.cookJump to last post
07/08/2013 6:47 AM
3 Replies and 760 Views CR hyperlink opening in same window, window keeps shrinking  760  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 760
by  Matthew NyeJump to last post
07/02/2013 2:25 AM
2 Replies and 2145 Views Crystal 2008-Suppress Group Header 1 based on running total in Group Footer 1  2145  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 2145
by  Matthew NyeJump to last post
06/21/2013 11:43 AM
3 Replies and 1035 Views Suppress distribution of Crystal report through LBI?  1035  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 1035
by  LisaPJump to last post
06/13/2013 4:20 PM
5 Replies and 1791 Views Problem with permissions on report services  1791  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 1791
by  Jerry MaogJump to last post
06/13/2013 11:06 AM
15 Replies and 2524 Views User Ids in a Report Security group in LBI  2524  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 9.0.4.2. Previously these values were stored in a table called ENPUSERGROUPLIST. Does anyone k...
15 2524
by  DonnaJump to last post
06/12/2013 4:45 PM
2 Replies and 1388 Views Using Crystal Reports 2008 to query LBI Schema  1388  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 1388
by  DonnaJump to last post
06/11/2013 10:01 AM
4 Replies and 1988 Views LBI Crystal Report Hyperlink  1988  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 1988
by  The.Sam.GrovesJump to last post
06/10/2013 4:15 PM
5 Replies and 1520 Views Suggested Crystal reports techinal forums?  1520  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 1520
by  CindyWJump to last post
06/05/2013 3:53 PM
14 Replies and 2478 Views LBI Class  2478  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 2478
by  GeorgetteJump to last post
06/05/2013 9:47 AM
6 Replies and 1640 Views My Reports tab in LBI/Framework Services  1640  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 1640
by  Greg MoellerJump to last post
05/31/2013 1:32 PM
4 Replies and 1078 Views Upgrade LBI 904.2 to 10.1.x  1078  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 1078
by  Greg MoellerJump to last post
05/29/2013 9:18 AM
11 Replies and 2491 Views LBI Schedule runs but report is not produced  2491  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 2491
by  RobbyJump to last post
05/28/2013 6:30 AM
2 Replies and 1186 Views Delivery Device Audit  1186  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 1186
by  Greg MoellerJump to last post
05/24/2013 9:24 AM
5 Replies and 1204 Views Analyzing Report Activity in LBI  1204  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 1204
by  WillJump to last post
05/04/2013 4:52 PM
11 Replies and 3212 Views Page Setup or Print takes over a minute to open in Crystal  3212  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 3212
by  Mary PorterJump to last post
04/29/2013 4:58 PM
1 Replies and 1413 Views Converting Crystal Rpt criteria (sql) over to Lawson 4GL...HELP  1413  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 1413
by  Ragu RaghavanJump to last post
04/29/2013 11:12 AM
3 Replies and 2137 Views Microsoft Reporting Services vs. LRS on LBI  2137  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 2137
by  Joe O'TooleJump to last post
04/23/2013 6:14 PM
3 Replies and 1265 Views Report DataSource Override  1265  3 Started by  Greg Moeller How would one do that
3 1265
by  Greg MoellerJump to last post
04/19/2013 9:48 AM
7 Replies and 1502 Views YTD MM280 to Crystal using Lawson OLE DB  1502  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 1502
by  MichaelJump to last post
04/18/2013 3:58 PM
1 Replies and 1004 Views reporting Services>Delivery Administration  1004  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 1004
by  Greg MoellerJump to last post
04/18/2013 9:26 AM
5 Replies and 1345 Views Suppress the decimal point, keep the decimal numbers  1345  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 1345
by  Mary PorterJump to last post
04/16/2013 12:26 PM
2 Replies and 960 Views Reporting Services  960  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 960
by  RobbyJump to last post
04/11/2013 5:31 PM
3 Replies and 1014 Views Reporting from LBI Data Schemas  1014  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 1014
by  GeorgetteJump to last post
04/04/2013 6:31 AM
1 Replies and 1401 Views Looking for the SQL behind a program in M3  1401  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 1401
by  Ellen BatsJump to last post
04/03/2013 9:10 AM
3 Replies and 964 Views Server Migration and Report File Reloacation  964  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 964
by  Ruma MalhotraJump to last post
03/25/2013 2:24 PM
1 Replies and 900 Views LBI Calendar pop-ups - shows blank page  900  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 10.1.0.0.76 Thanks
1 900
by  Matthew NyeJump to last post
03/21/2013 2:36 PM
5 Replies and 1909 Views Lawson Crystal Reports and Prod Verses Dev  1909  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 1909
by  Matthew NyeJump to last post
03/21/2013 6:11 AM
3 Replies and 1303 Views Service Date  1303  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 http://img.photobucket.com/albums/v233/Rirruto/image001_zps7e1e0008.png
3 1303
by  RirrutoJump to last post
03/15/2013 2:50 PM
4 Replies and 1281 Views LAWSONRS_CurrentUser can be changed on refresh report  1281  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 1281
by  GeorgetteJump to last post
03/12/2013 7:20 AM
5 Replies and 1328 Views User structure / rights  1328  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 1328
by  Greg MoellerJump to last post
03/08/2013 12:58 PM
6 Replies and 1645 Views Unsubscribed user - how to resubscribe?  1645  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 1645
by  RobbyJump to last post
03/05/2013 3:00 PM
3 Replies and 1437 Views RW100 Report to Crystal via Lawson OLEDB  1437  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 1437
by  Ruma MalhotraJump to last post
03/05/2013 12:41 PM
5 Replies and 1342 Views LDAP Bind with LBI  1342  5 Started by  Roger French Setting up the LDAP bind with LBI FS. Not using DSSO. Windows 2008 Env = 9.0.1.9 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 1342
by  Matthew NyeJump to last post
03/05/2013 9:02 AM
6 Replies and 1829 Views Tools dashboard  1829  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 1829
by  GeorgetteJump to last post
03/05/2013 8:38 AM
11 Replies and 1264 Views Disconnect between LBI role and right  1264  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 1264
by  imtyJump to last post
02/26/2013 6:02 PM
2 Replies and 1177 Views Best way to pull accurate received date for Requisition line item.  1177  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 1177
by  NormajeanJump to last post
02/19/2013 12:44 PM
1 Replies and 1847 Views Introduction of Lawson Smart Reports  1847  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 1847
by  George GrahamJump to last post
02/07/2013 11:51 AM
0 Replies and 947 Views LBI  947  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 947
02/06/2013 12:24 PM
11 Replies and 1372 Views SQL Expression Changes - Unix Server to Windows  1372  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 1372
by  RobbyJump to last post
02/06/2013 8:27 AM
16 Replies and 2045 Views Publishing in LBI a Crystal Report reading LTM Database via LAWSON OLEDB Connector  2045  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 2045
by  ric9dJump to last post
02/06/2013 8:26 AM
3 Replies and 1120 Views LBI Structure / Framework For Maximum End User Flexibility  1120  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 1120
by  Matthew NyeJump to last post
02/05/2013 1:36 AM
5 Replies and 2058 Views HISTORICAL INSTANCE ON LBI DASHBOARD?  2058  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 2058
by  MelissaJump to last post
01/18/2013 1:07 PM
9 Replies and 5724 Views Crystal reports hyperlinks in LBI  5724  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 5724
by  JillFJump to last post
01/09/2013 10:59 AM
3 Replies and 4940 Views Overcoming the 65,536 row limit in Excel  4940  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 4940
by  JonAJump to last post
01/04/2013 2:00 PM
2 Replies and 1572 Views Copying LBI PROD Data to DEV  1572  2 Started by  ric9d Is there a step by step process to copy LBI PROD DATA (settings, reports, definitions, users, etc) to DEV
2 1572
by  ric9dJump to last post
01/03/2013 1:07 PM
2 Replies and 1375 Views How does Crystal determine the rowcount in excel?  1375  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 1375
by  imtyJump to last post
12/26/2012 3:47 PM
10 Replies and 1756 Views crystal reports/LBI dynamic data  1756  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 1756
by  Matthew NyeJump to last post
12/14/2012 10:28 AM
4 Replies and 2149 Views Crystal Report Drill Down capability from LBI  2149  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 2149
by  Gary GastaJump to last post
12/13/2012 1:29 PM
5 Replies and 1610 Views Scheduled Crystal Report not be sent out.  1610  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 1610
by  Matthew NyeJump to last post
12/04/2012 11:54 AM
5 Replies and 1187 Views Import of delivery devices  1187  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 1187
by  Greg MoellerJump to last post
11/28/2012 9:47 AM
2 Replies and 1121 Views Report runs in TEST but not in PROD  1121  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 1121
by  RobbyJump to last post
11/26/2012 8:25 PM
19 Replies and 4256 Views Create report based on report user employee hierarchy  4256  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 4256
by  WillJump to last post
11/26/2012 7:09 AM
2 Replies and 1194 Views Connection to MS Access 2007  1194  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 1194
by  Greg MoellerJump to last post
11/06/2012 1:23 PM
13 Replies and 3435 Views Schedule sending (not Bursting) a crystal report via Email to report users  3435  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 3435
by  DeelightJump to last post
11/06/2012 10:23 AM
11 Replies and 4143 Views Back Office Report as source for Crystal  4143  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 4143
by  gsusnmeJump to last post
10/30/2012 4:22 PM
2 Replies and 1163 Views Output file names for bursted reports  1163  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 1163
by  barbsJump to last post
10/18/2012 12:21 PM
4 Replies and 2032 Views Any issue using PAEMPPOS table to evaluate FTE?  2032  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 2032
by  Paul BerkowitzJump to last post
10/18/2012 10:24 AM
8 Replies and 3153 Views Create LBI user access rights in Crystal  3153  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 3153
by  ChrisJump to last post
09/27/2012 9:27 AM
5 Replies and 2640 Views Reporting on LTM CLOB field  2640  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 2640
by  NabilJump to last post
09/13/2012 2:58 PM
8 Replies and 2926 Views LBI 500 internal server error  2926  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 2926
by  Xin LiJump to last post
09/11/2012 4:49 PM
3 Replies and 1558 Views LBI Dashboard Module  1558  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 1558
by  imtyJump to last post
09/11/2012 12:38 PM
6 Replies and 3531 Views Create Crystal Report with Excel Data and Upload to LBI  3531  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 3531
by  imtyJump to last post
09/06/2012 1:13 PM
6 Replies and 1610 Views Events and Crystal Parameter page  1610  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 1610
by  KevinHJump to last post
08/30/2012 2:07 PM
13 Replies and 1756 Views Crystal 2008 and LBI Drill Around  1756  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 1756
by  KatfraJump to last post
08/30/2012 6:57 AM
4 Replies and 1579 Views Formula based on the Group Level  1579  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 1579
by  David VJump to last post
08/27/2012 10:48 AM
0 Replies and 1148 Views Lawson LDAP Connection from SQL  1148  0 Started by  Layne Does anyone have an example of connecting to ADAM LDAP from SSMS using a SQL Script
0 1148
08/23/2012 12:45 PM
2 Replies and 3222 Views LBI logout  3222  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 9.0.4.2 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 http://www.example.com/sso/logout.htmhttp3A//Fwww.example.com/path/to/page/shown/after/logout/index.htm. It no longer will accept that scri...
2 3222
by  Display NameJump to last post
08/23/2012 9:10 AM
0 Replies and 1093 Views Roster for Doctors/Nurses  1093  0 Started by  Vijay S Is there a way to prepare Roster(Time Table) for doctor and nurses in Lawson Thnx, Vijay
0 1093
08/20/2012 10:42 PM
2 Replies and 1410 Views Bursting Multiple Reports with one Report Schedule?  1410  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 1410
by  ric9dJump to last post
08/13/2012 8:53 AM
0 Replies and 3111 Views Lawson Smart Reports  3111  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 3111
08/03/2012 3:51 PM
5 Replies and 1805 Views Reporting Services database  1805  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 1805
by  Greg MoellerJump to last post
08/03/2012 3:29 PM
9 Replies and 2368 Views LBI Report Users II  2368  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 2368
by  ric9dJump to last post
07/30/2012 1:30 PM
9 Replies and 1889 Views Create a reporting data store with production data  1889  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 1889
by  Greg MoellerJump to last post
07/30/2012 10:47 AM
1 Replies and 2458 Views IE9 with LBI 904  2458  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 2458
by  WillJump to last post
07/24/2012 2:31 AM
1 Replies and 1856 Views Reports timing out in conversion from Oracle to SQL server DB  1856  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 1856
by  John HenleyJump to last post
06/29/2012 5:40 PM
0 Replies and 1082 Views PSA Data  1082  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 1082
06/25/2012 11:00 AM
2 Replies and 1835 Views Can I reference data in a published LBI spreadsheet in a Crystal report also published in LBI?  1835  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 1835
by  ric9dJump to last post
06/25/2012 10:26 AM
1 Replies and 1930 Views Scheduled Reports in Excel Format (via Email)  1930  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 1930
by  ric9dJump to last post
06/22/2012 10:50 AM
1 Replies and 1676 Views Vendor Address Defaults  1676  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 1676
by  JonAJump to last post
06/22/2012 10:10 AM
4 Replies and 1922 Views LBI html report  1922  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 1922
by  khartJump to last post
06/15/2012 2:38 PM
0 Replies and 922 Views Panelists wanted for a Focus Group on Performance Management and Continuous Feedback  922  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 rsrsynergita.com
0 922
06/02/2012 3:45 AM
23 Replies and 4011 Views LBI Back Office Reports, publish more than 1 rpt from same job  4011  23 Started by  Elizabeth Ardito We only have the 'free' LBI product that replaced E-Broadcast from years ago. I have a new cobol program that produces 2 output files in the print manager (a .prt and the other file is called listing). Is it possible to publish the listing file I have all the necessary coding in the program to include the tags on both reports. I have had a case open with Lawson for the last 2 weeks and today they came back after they tried some 'canned' reports but determined they were not burstable tha...
23 4011
by  Elizabeth ArditoJump to last post
05/30/2012 11:26 AM
2 Replies and 1501 Views Specific AU's not showing in Crystal Reports  1501  2 Started by  Whitney Johnson I have two separate Crystal reports, report (A): is pulling AU’s by Attribute and report (B): is a P&L pulling revenue and expense accounts. For some strange reason I’m not able to get data for two specific accounting units to pull into these reports. Does anyone have an idea what may be causing this Could it be the setup of these AU's in Lawson All other AU data is being captured in the reports.
2 1501
by  Ruma MalhotraJump to last post
05/24/2012 4:14 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 3 of 9 << < 12345 > >>


RSS Feed Available