Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
Search this forum:
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
10 Replies and 1675 Views LBI v 10.1.x cosmetic change  1675  10 Started by  Greg Moeller In LBI version 10, we are noticing that the dashboards background is a deep blue/navy blue and the selected dashboard text is black. Anyone know which specific file this is controlled from We'd like to change the selected dashboard color.
10 1675
by  Matthew NyeJump to last post
11/11/2013 10:48 AM
3 Replies and 1084 Views LBI Uploading RIGHTS using CSV file --- Description is not uploadable?  1084  3 Started by  ric9d I checked the CSV file format specs to upload rights, it doesn't have one for 'Description'. Does anyone have any idea Thanks in advance.
3 1084
by  JeanneSJump to last post
11/06/2013 12:51 PM
0 Replies and 1061 Views Querying PR35.2 versus PR36  1061  0 Started by  clb393 is there any way i can query the data on each form separately If not, is there a field indicator which would distinguish the two Thanks, Chris
0 1061
11/04/2013 8:13 AM
15 Replies and 3854 Views What to use for reporting financials in S3  3854  15 Started by  Melissa I'm curious what others are using for reporting financials. we have been live on lawson since january and the report writer in lawson is great for the style 1 type balance sheet and P&L reports. However, being in healthcare we have a lot of need for slicing and dicing our accouting unit information and building all the calculations and groups etc that have to go into creating it is tedious. and then keeping track of them all in case something changes is almost impossible. Crystal reports is a ni...
15 3854
by  Chris MartinJump to last post
11/01/2013 12:56 PM
1 Replies and 1290 Views Direct reports in non-Lawson report  1290  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 1290
by  Greg MoellerJump to last post
10/30/2013 3:10 PM
3 Replies and 1335 Views The Value of RW100  1335  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 1335
by  JonAJump to last post
10/30/2013 2:31 PM
2 Replies and 1373 Views LBI back office report error.  1373  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 1373
by  Justin RJump to last post
10/24/2013 9:37 AM
3 Replies and 1572 Views Passing parameters to report through url  1572  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 1572
by  George GrahamJump to last post
10/23/2013 7:06 PM
6 Replies and 1433 Views What table has field SKI_DATE_LST_USED  1433  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 1433
by  DonnaJump to last post
10/08/2013 3:24 PM
3 Replies and 1146 Views Historical Report Instance and bursting  1146  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 1146
by  Greg MoellerJump to last post
10/07/2013 11:10 AM
15 Replies and 4523 Views Scheduled Report - must login to view  4523  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 4523
by  Rob MarshallJump to last post
10/04/2013 12:59 PM
1 Replies and 1180 Views lbi blank rows  1180  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 1180
by  RobbyJump to last post
10/01/2013 10:46 AM
0 Replies and 1111 Views LBI and SSL  1111  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 1111
09/29/2013 4:00 PM
2 Replies and 1165 Views LBI: Report Events  1165  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 1165
by  RobbyJump to last post
09/17/2013 1:09 PM
3 Replies and 1491 Views Reporting Services - Why would you publish a Non-RPT File  1491  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 1491
by  dcaianiJump to last post
09/13/2013 3:25 PM
2 Replies and 1647 Views New service for reports on the dashboard  1647  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 1647
by  NancyJump to last post
09/05/2013 2:32 PM
1 Replies and 1089 Views Scheduling a Group of Reports  1089  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 1089
by  Matthew NyeJump to last post
08/26/2013 12:16 PM
0 Replies and 1070 Views query builder timeout  1070  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 1070
08/14/2013 3:19 PM
3 Replies and 2504 Views LBI crystal report with link to Portal Form  2504  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 2504
by  Nirav BhattJump to last post
07/22/2013 2:01 PM
2 Replies and 1802 Views Cannot update Crystal Report in LBI  1802  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 1802
by  dcaianiJump to last post
07/16/2013 7:58 AM
2 Replies and 1738 Views LBI report prompt for username and password  1738  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 1738
by  imtyJump to last post
07/15/2013 6:11 PM
1 Replies and 1144 Views LBI report output to Excel - unwanted merging of cells  1144  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 1144
by  SimoneJump to last post
07/09/2013 2:34 AM
5 Replies and 1296 Views Help with LBI dashboards and crystal reports  1296  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 1296
by  mark.cookJump to last post
07/08/2013 6:47 AM
3 Replies and 803 Views CR hyperlink opening in same window, window keeps shrinking  803  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 803
by  Matthew NyeJump to last post
07/02/2013 2:25 AM
2 Replies and 2294 Views Crystal 2008-Suppress Group Header 1 based on running total in Group Footer 1  2294  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 2294
by  Matthew NyeJump to last post
06/21/2013 11:43 AM
3 Replies and 1119 Views Suppress distribution of Crystal report through LBI?  1119  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 1119
by  LisaPJump to last post
06/13/2013 4:20 PM
5 Replies and 1881 Views Problem with permissions on report services  1881  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 1881
by  Jerry MaogJump to last post
06/13/2013 11:06 AM
15 Replies and 2636 Views User Ids in a Report Security group in LBI  2636  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 2636
by  DonnaJump to last post
06/12/2013 4:45 PM
2 Replies and 1448 Views Using Crystal Reports 2008 to query LBI Schema  1448  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 1448
by  DonnaJump to last post
06/11/2013 10:01 AM
4 Replies and 2113 Views LBI Crystal Report Hyperlink  2113  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 2113
by  The.Sam.GrovesJump to last post
06/10/2013 4:15 PM
5 Replies and 1709 Views Suggested Crystal reports techinal forums?  1709  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 1709
by  CindyWJump to last post
06/05/2013 3:53 PM
14 Replies and 2637 Views LBI Class  2637  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 2637
by  GeorgetteJump to last post
06/05/2013 9:47 AM
6 Replies and 1748 Views My Reports tab in LBI/Framework Services  1748  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 1748
by  Greg MoellerJump to last post
05/31/2013 1:32 PM
4 Replies and 1166 Views Upgrade LBI 904.2 to 10.1.x  1166  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 1166
by  Greg MoellerJump to last post
05/29/2013 9:18 AM
11 Replies and 2593 Views LBI Schedule runs but report is not produced  2593  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 2593
by  RobbyJump to last post
05/28/2013 6:30 AM
2 Replies and 1282 Views Delivery Device Audit  1282  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 1282
by  Greg MoellerJump to last post
05/24/2013 9:24 AM
5 Replies and 1301 Views Analyzing Report Activity in LBI  1301  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 1301
by  WillJump to last post
05/04/2013 4:52 PM
11 Replies and 3377 Views Page Setup or Print takes over a minute to open in Crystal  3377  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 3377
by  Mary PorterJump to last post
04/29/2013 4:58 PM
1 Replies and 1476 Views Converting Crystal Rpt criteria (sql) over to Lawson 4GL...HELP  1476  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 1476
by  Ragu RaghavanJump to last post
04/29/2013 11:12 AM
3 Replies and 2230 Views Microsoft Reporting Services vs. LRS on LBI  2230  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 2230
by  Joe O'TooleJump to last post
04/23/2013 6:14 PM
3 Replies and 1353 Views Report DataSource Override  1353  3 Started by  Greg Moeller How would one do that
3 1353
by  Greg MoellerJump to last post
04/19/2013 9:48 AM
7 Replies and 1593 Views YTD MM280 to Crystal using Lawson OLE DB  1593  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 1593
by  MichaelJump to last post
04/18/2013 3:58 PM
1 Replies and 1088 Views reporting Services>Delivery Administration  1088  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 1088
by  Greg MoellerJump to last post
04/18/2013 9:26 AM
5 Replies and 1418 Views Suppress the decimal point, keep the decimal numbers  1418  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 1418
by  Mary PorterJump to last post
04/16/2013 12:26 PM
2 Replies and 1027 Views Reporting Services  1027  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 1027
by  RobbyJump to last post
04/11/2013 5:31 PM
3 Replies and 1094 Views Reporting from LBI Data Schemas  1094  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 1094
by  GeorgetteJump to last post
04/04/2013 6:31 AM
1 Replies and 1514 Views Looking for the SQL behind a program in M3  1514  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 1514
by  Ellen BatsJump to last post
04/03/2013 9:10 AM
3 Replies and 1052 Views Server Migration and Report File Reloacation  1052  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 1052
by  Ruma MalhotraJump to last post
03/25/2013 2:24 PM
1 Replies and 981 Views LBI Calendar pop-ups - shows blank page  981  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 981
by  Matthew NyeJump to last post
03/21/2013 2:36 PM
5 Replies and 2014 Views Lawson Crystal Reports and Prod Verses Dev  2014  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 2014
by  Matthew NyeJump to last post
03/21/2013 6:11 AM
3 Replies and 1392 Views Service Date  1392  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 1392
by  RirrutoJump to last post
03/15/2013 2:50 PM
4 Replies and 1347 Views LAWSONRS_CurrentUser can be changed on refresh report  1347  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 1347
by  GeorgetteJump to last post
03/12/2013 7:20 AM
5 Replies and 1411 Views User structure / rights  1411  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 1411
by  Greg MoellerJump to last post
03/08/2013 12:58 PM
6 Replies and 1736 Views Unsubscribed user - how to resubscribe?  1736  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 1736
by  RobbyJump to last post
03/05/2013 3:00 PM
3 Replies and 1532 Views RW100 Report to Crystal via Lawson OLEDB  1532  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 1532
by  Ruma MalhotraJump to last post
03/05/2013 12:41 PM
5 Replies and 1438 Views LDAP Bind with LBI  1438  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 1438
by  Matthew NyeJump to last post
03/05/2013 9:02 AM
6 Replies and 1945 Views Tools dashboard  1945  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 1945
by  GeorgetteJump to last post
03/05/2013 8:38 AM
11 Replies and 1344 Views Disconnect between LBI role and right  1344  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 1344
by  imtyJump to last post
02/26/2013 6:02 PM
2 Replies and 1241 Views Best way to pull accurate received date for Requisition line item.  1241  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 1241
by  NormajeanJump to last post
02/19/2013 12:44 PM
1 Replies and 1940 Views Introduction of Lawson Smart Reports  1940  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 1940
by  George GrahamJump to last post
02/07/2013 11:51 AM
0 Replies and 1011 Views LBI  1011  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 1011
02/06/2013 12:24 PM
11 Replies and 1475 Views SQL Expression Changes - Unix Server to Windows  1475  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 1475
by  RobbyJump to last post
02/06/2013 8:27 AM
16 Replies and 2150 Views Publishing in LBI a Crystal Report reading LTM Database via LAWSON OLEDB Connector  2150  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 2150
by  ric9dJump to last post
02/06/2013 8:26 AM
3 Replies and 1183 Views LBI Structure / Framework For Maximum End User Flexibility  1183  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 1183
by  Matthew NyeJump to last post
02/05/2013 1:36 AM
5 Replies and 2130 Views HISTORICAL INSTANCE ON LBI DASHBOARD?  2130  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 2130
by  MelissaJump to last post
01/18/2013 1:07 PM
9 Replies and 5849 Views Crystal reports hyperlinks in LBI  5849  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 5849
by  JillFJump to last post
01/09/2013 10:59 AM
3 Replies and 5139 Views Overcoming the 65,536 row limit in Excel  5139  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 5139
by  JonAJump to last post
01/04/2013 2:00 PM
2 Replies and 1650 Views Copying LBI PROD Data to DEV  1650  2 Started by  ric9d Is there a step by step process to copy LBI PROD DATA (settings, reports, definitions, users, etc) to DEV
2 1650
by  ric9dJump to last post
01/03/2013 1:07 PM
2 Replies and 1452 Views How does Crystal determine the rowcount in excel?  1452  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 1452
by  imtyJump to last post
12/26/2012 3:47 PM
10 Replies and 1825 Views crystal reports/LBI dynamic data  1825  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 1825
by  Matthew NyeJump to last post
12/14/2012 10:28 AM
4 Replies and 2224 Views Crystal Report Drill Down capability from LBI  2224  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 2224
by  Gary GastaJump to last post
12/13/2012 1:29 PM
5 Replies and 1664 Views Scheduled Crystal Report not be sent out.  1664  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 1664
by  Matthew NyeJump to last post
12/04/2012 11:54 AM
5 Replies and 1237 Views Import of delivery devices  1237  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 1237
by  Greg MoellerJump to last post
11/28/2012 9:47 AM
2 Replies and 1164 Views Report runs in TEST but not in PROD  1164  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 1164
by  RobbyJump to last post
11/26/2012 8:25 PM
19 Replies and 4349 Views Create report based on report user employee hierarchy  4349  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 4349
by  WillJump to last post
11/26/2012 7:09 AM
2 Replies and 1260 Views Connection to MS Access 2007  1260  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 1260
by  Greg MoellerJump to last post
11/06/2012 1:23 PM
13 Replies and 3650 Views Schedule sending (not Bursting) a crystal report via Email to report users  3650  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 3650
by  DeelightJump to last post
11/06/2012 10:23 AM
11 Replies and 4213 Views Back Office Report as source for Crystal  4213  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 4213
by  gsusnmeJump to last post
10/30/2012 4:22 PM
2 Replies and 1214 Views Output file names for bursted reports  1214  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 1214
by  barbsJump to last post
10/18/2012 12:21 PM
4 Replies and 2115 Views Any issue using PAEMPPOS table to evaluate FTE?  2115  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 2115
by  Paul BerkowitzJump to last post
10/18/2012 10:24 AM
8 Replies and 3259 Views Create LBI user access rights in Crystal  3259  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 3259
by  ChrisJump to last post
09/27/2012 9:27 AM
5 Replies and 2738 Views Reporting on LTM CLOB field  2738  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 2738
by  NabilJump to last post
09/13/2012 2:58 PM
8 Replies and 3153 Views LBI 500 internal server error  3153  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 3153
by  Xin LiJump to last post
09/11/2012 4:49 PM
3 Replies and 1614 Views LBI Dashboard Module  1614  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 1614
by  imtyJump to last post
09/11/2012 12:38 PM
6 Replies and 3608 Views Create Crystal Report with Excel Data and Upload to LBI  3608  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 3608
by  imtyJump to last post
09/06/2012 1:13 PM
6 Replies and 1684 Views Events and Crystal Parameter page  1684  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 1684
by  KevinHJump to last post
08/30/2012 2:07 PM
13 Replies and 1806 Views Crystal 2008 and LBI Drill Around  1806  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 1806
by  KatfraJump to last post
08/30/2012 6:57 AM
4 Replies and 1627 Views Formula based on the Group Level  1627  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 1627
by  David VJump to last post
08/27/2012 10:48 AM
0 Replies and 1194 Views Lawson LDAP Connection from SQL  1194  0 Started by  Layne Does anyone have an example of connecting to ADAM LDAP from SSMS using a SQL Script
0 1194
08/23/2012 12:45 PM
2 Replies and 3394 Views LBI logout  3394  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 3394
by  Display NameJump to last post
08/23/2012 9:10 AM
0 Replies and 1153 Views Roster for Doctors/Nurses  1153  0 Started by  Vijay S Is there a way to prepare Roster(Time Table) for doctor and nurses in Lawson Thnx, Vijay
0 1153
08/20/2012 10:42 PM
2 Replies and 1482 Views Bursting Multiple Reports with one Report Schedule?  1482  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 1482
by  ric9dJump to last post
08/13/2012 8:53 AM
0 Replies and 3197 Views Lawson Smart Reports  3197  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 3197
08/03/2012 3:51 PM
5 Replies and 1862 Views Reporting Services database  1862  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 1862
by  Greg MoellerJump to last post
08/03/2012 3:29 PM
9 Replies and 2417 Views LBI Report Users II  2417  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 2417
by  ric9dJump to last post
07/30/2012 1:30 PM
9 Replies and 1967 Views Create a reporting data store with production data  1967  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 1967
by  Greg MoellerJump to last post
07/30/2012 10:47 AM
1 Replies and 2514 Views IE9 with LBI 904  2514  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 2514
by  WillJump to last post
07/24/2012 2:31 AM
1 Replies and 1913 Views Reports timing out in conversion from Oracle to SQL server DB  1913  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 1913
by  John HenleyJump to last post
06/29/2012 5:40 PM
0 Replies and 1173 Views PSA Data  1173  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 1173
06/25/2012 11:00 AM
2 Replies and 1890 Views Can I reference data in a published LBI spreadsheet in a Crystal report also published in LBI?  1890  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 1890
by  ric9dJump to last post
06/25/2012 10:26 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