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 2 of 5 << < 12345 > >>
 Last Post
3 Replies and 2200 Views LBI Current User Formula???  2200  3 Started by  DanH I am publishing an EE roster of 6000 people. I need the Manager running the report to only view employees they have access to. I concatenated a few fields where the IDs are to make the field i want touse to check the manager . i already tried the formula below: CurrentCEUsername in {Manager String} in lbi and crystal but it did not pull the data. In LBI, it kept asking the users for a default ID and PW. Can someone please assist Thanks!
3 2200
by  Greg MoellerJump to last post
01/02/2014 1:39 PM
2 Replies and 1403 Views Burting by LBI Report content  1403  2 Started by  Ruma Malhotra We have several reports that are needing to be bursted by a field on the report and we are on version 10 of LBI but we are experiencing that bursting is not working right and wanted to check with anybody out there what their experiences have been Thanks in advance.
2 1403
by  Susan PrenticeJump to last post
12/23/2013 3:24 PM
6 Replies and 1675 Views Refreshing server for LBI  1675  6 Started by  Ronnie I have a question and I am getting no where currently with infor support. I just want information from them but they are not getting anywhere with me and just wanting me to run fiddler etc. I feel this is an easy solution. Here is the issue. In our portal we have an area that uses xml pages. I have made a change to one of the xml files where it now uses a fully qualified URL instead of a short URL name. example...inside the XML file there is host=''><URL><!&91;CDATA&91;...
6 1675
by  Alex TsekhanskyJump to last post
12/22/2013 4:50 PM
3 Replies and 1350 Views LBI without Lawson Portal  1350  3 Started by  Kate Liamero We are having our systems moved and I want LBI to be available longer than lawson. We usually log into lbi via a link in the lawson portal but I do have the direct url for lbi. I am being told they are not sure if LBI can be up without the portal We don't want to allow users to log into the portal because we don't want any data changed. Our LBI is strictly reports only. As long as the database is up can users log directly into LBI and run their reports without the portal also being accessib...
3 1350
by  Kate LiameroJump to last post
12/13/2013 9:14 AM
0 Replies and 1289 Views LBI RFP  1289  0 Started by  Daniel Does anyone have an example RFP for implementation of Lawson Business Intelligence that they could share. Thanks for any assistance.
0 1289
12/09/2013 11:16 AM
38 Replies and 4432 Views Upgrading to LBI 10  4432  38 Started by  ric9d Has anyone here upgraded from LBI 9.05 to 10 I called Infor Support and was told that it would take 1-2 hours, maybe even less. And that it would just be an install on top of the existing one. Is it really that easy What should I look out for We are only upgrading LBI to 10. None of the other Lawson apps would be upgraded. Is that possible recommended Thanks!
38 4432
by  Chris MartinJump to last post
12/05/2013 11:45 AM
1 Replies and 1148 Views Lawson report AM260 to Crystal cannot use csv  1148  1 Started by  Donna The AM260 report is still in the user's print manager and he needs an excel file created. I just received this call 5 minutes ago. I used to 'crystallize' Lawson standard reports10 years ago but have not done it in recent memory. I rarely use OLEDB although I have it on my computer. Of course the users needs it tomorrow and I was going to be on PTO but I would still like to help if at all possible. I am searching for documentation on this that is newer than the article posted in the...
1 1148
by  DonnaJump to last post
11/27/2013 10:04 AM
4 Replies and 1407 Views Default dashboard view  1407  4 Started by  Ronnie Ok...So I am setting up our Lawson dashboards for our Lawson 10 we are going to implement. We are coming from 9. Is there a way to set individual portal roles to have a certain dashboard tab show up as the main home tab that opens when they log in I have two created for our regular employees, but the additional tab is the one that is defaulting when they open up lawson. I have a main one created that I would like to default open when they log in. Where is this set
4 1407
by  RonnieJump to last post
11/12/2013 2:51 PM
10 Replies and 1895 Views LBI v 10.1.x cosmetic change  1895  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 1895
by  Matthew NyeJump to last post
11/11/2013 10:48 AM
3 Replies and 1283 Views LBI Uploading RIGHTS using CSV file --- Description is not uploadable?  1283  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 1283
by  JeanneSJump to last post
11/06/2013 12:51 PM
0 Replies and 1212 Views Querying PR35.2 versus PR36  1212  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 1212
11/04/2013 8:13 AM
15 Replies and 4544 Views What to use for reporting financials in S3  4544  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 4544
by  Chris MartinJump to last post
11/01/2013 12:56 PM
1 Replies and 1486 Views Direct reports in non-Lawson report  1486  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 1486
by  Greg MoellerJump to last post
10/30/2013 3:10 PM
3 Replies and 1524 Views The Value of RW100  1524  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 1524
by  JonAJump to last post
10/30/2013 2:31 PM
2 Replies and 1565 Views LBI back office report error.  1565  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 1565
by  Justin RJump to last post
10/24/2013 9:37 AM
3 Replies and 1784 Views Passing parameters to report through url  1784  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 1784
by  George GrahamJump to last post
10/23/2013 7:06 PM
6 Replies and 1723 Views What table has field SKI_DATE_LST_USED  1723  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 1723
by  DonnaJump to last post
10/08/2013 3:24 PM
3 Replies and 1347 Views Historical Report Instance and bursting  1347  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 1347
by  Greg MoellerJump to last post
10/07/2013 11:10 AM
15 Replies and 4914 Views Scheduled Report - must login to view  4914  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 4914
by  Rob MarshallJump to last post
10/04/2013 12:59 PM
1 Replies and 1395 Views lbi blank rows  1395  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 1395
by  RobbyJump to last post
10/01/2013 10:46 AM
0 Replies and 1292 Views LBI and SSL  1292  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 1292
09/29/2013 4:00 PM
2 Replies and 1428 Views LBI: Report Events  1428  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 1428
by  RobbyJump to last post
09/17/2013 1:09 PM
3 Replies and 1684 Views Reporting Services - Why would you publish a Non-RPT File  1684  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 1684
by  dcaianiJump to last post
09/13/2013 3:25 PM
2 Replies and 1864 Views New service for reports on the dashboard  1864  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 1864
by  NancyJump to last post
09/05/2013 2:32 PM
1 Replies and 1241 Views Scheduling a Group of Reports  1241  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 1241
by  Matthew NyeJump to last post
08/26/2013 12:16 PM
0 Replies and 1199 Views query builder timeout  1199  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 1199
08/14/2013 3:19 PM
3 Replies and 2700 Views LBI crystal report with link to Portal Form  2700  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 2700
by  Nirav BhattJump to last post
07/22/2013 2:01 PM
2 Replies and 2014 Views Cannot update Crystal Report in LBI  2014  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 2014
by  dcaianiJump to last post
07/16/2013 7:58 AM
2 Replies and 1967 Views LBI report prompt for username and password  1967  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 1967
by  imtyJump to last post
07/15/2013 6:11 PM
1 Replies and 1276 Views LBI report output to Excel - unwanted merging of cells  1276  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 1276
by  SimoneJump to last post
07/09/2013 2:34 AM
5 Replies and 1489 Views Help with LBI dashboards and crystal reports  1489  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 1489
by  mark.cookJump to last post
07/08/2013 6:47 AM
3 Replies and 950 Views CR hyperlink opening in same window, window keeps shrinking  950  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 950
by  Matthew NyeJump to last post
07/02/2013 2:25 AM
2 Replies and 2665 Views Crystal 2008-Suppress Group Header 1 based on running total in Group Footer 1  2665  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 2665
by  Matthew NyeJump to last post
06/21/2013 11:43 AM
3 Replies and 1298 Views Suppress distribution of Crystal report through LBI?  1298  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 1298
by  LisaPJump to last post
06/13/2013 4:20 PM
5 Replies and 2055 Views Problem with permissions on report services  2055  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 2055
by  Jerry MaogJump to last post
06/13/2013 11:06 AM
15 Replies and 2937 Views User Ids in a Report Security group in LBI  2937  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 2937
by  DonnaJump to last post
06/12/2013 4:45 PM
2 Replies and 1578 Views Using Crystal Reports 2008 to query LBI Schema  1578  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 1578
by  DonnaJump to last post
06/11/2013 10:01 AM
4 Replies and 2394 Views LBI Crystal Report Hyperlink  2394  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 2394
by  The.Sam.GrovesJump to last post
06/10/2013 4:15 PM
5 Replies and 1985 Views Suggested Crystal reports techinal forums?  1985  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 1985
by  CindyWJump to last post
06/05/2013 3:53 PM
14 Replies and 2908 Views LBI Class  2908  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 2908
by  GeorgetteJump to last post
06/05/2013 9:47 AM
6 Replies and 1937 Views My Reports tab in LBI/Framework Services  1937  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 1937
by  Greg MoellerJump to last post
05/31/2013 1:32 PM
4 Replies and 1316 Views Upgrade LBI 904.2 to 10.1.x  1316  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 1316
by  Greg MoellerJump to last post
05/29/2013 9:18 AM
11 Replies and 2932 Views LBI Schedule runs but report is not produced  2932  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 2932
by  RobbyJump to last post
05/28/2013 6:30 AM
2 Replies and 1459 Views Delivery Device Audit  1459  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 1459
by  Greg MoellerJump to last post
05/24/2013 9:24 AM
5 Replies and 1481 Views Analyzing Report Activity in LBI  1481  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 1481
by  WillJump to last post
05/04/2013 4:52 PM
11 Replies and 3866 Views Page Setup or Print takes over a minute to open in Crystal  3866  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 3866
by  Mary PorterJump to last post
04/29/2013 4:58 PM
1 Replies and 1686 Views Converting Crystal Rpt criteria (sql) over to Lawson 4GL...HELP  1686  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 1686
by  Ragu RaghavanJump to last post
04/29/2013 11:12 AM
3 Replies and 2477 Views Microsoft Reporting Services vs. LRS on LBI  2477  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 2477
by  Joe O'TooleJump to last post
04/23/2013 6:14 PM
3 Replies and 1530 Views Report DataSource Override  1530  3 Started by  Greg Moeller How would one do that
3 1530
by  Greg MoellerJump to last post
04/19/2013 9:48 AM
7 Replies and 1789 Views YTD MM280 to Crystal using Lawson OLE DB  1789  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 1789
by  MichaelJump to last post
04/18/2013 3:58 PM
1 Replies and 1263 Views reporting Services>Delivery Administration  1263  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 1263
by  Greg MoellerJump to last post
04/18/2013 9:26 AM
5 Replies and 1577 Views Suppress the decimal point, keep the decimal numbers  1577  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 1577
by  Mary PorterJump to last post
04/16/2013 12:26 PM
2 Replies and 1169 Views Reporting Services  1169  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 1169
by  RobbyJump to last post
04/11/2013 5:31 PM
3 Replies and 1261 Views Reporting from LBI Data Schemas  1261  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 1261
by  GeorgetteJump to last post
04/04/2013 6:31 AM
1 Replies and 1721 Views Looking for the SQL behind a program in M3  1721  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 1721
by  Ellen BatsJump to last post
04/03/2013 9:10 AM
3 Replies and 1216 Views Server Migration and Report File Reloacation  1216  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 1216
by  Ruma MalhotraJump to last post
03/25/2013 2:24 PM
1 Replies and 1118 Views LBI Calendar pop-ups - shows blank page  1118  1 Started by  DeannaP 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 1118
by  Matthew NyeJump to last post
03/21/2013 2:36 PM
5 Replies and 2247 Views Lawson Crystal Reports and Prod Verses Dev  2247  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 2247
by  Matthew NyeJump to last post
03/21/2013 6:11 AM
3 Replies and 1589 Views Service Date  1589  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 1589
by  RirrutoJump to last post
03/15/2013 2:50 PM
4 Replies and 1569 Views LAWSONRS_CurrentUser can be changed on refresh report  1569  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 1569
by  GeorgetteJump to last post
03/12/2013 7:20 AM
5 Replies and 1567 Views User structure / rights  1567  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 1567
by  Greg MoellerJump to last post
03/08/2013 12:58 PM
6 Replies and 1989 Views Unsubscribed user - how to resubscribe?  1989  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 1989
by  RobbyJump to last post
03/05/2013 3:00 PM
3 Replies and 1684 Views RW100 Report to Crystal via Lawson OLEDB  1684  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 1684
by  Ruma MalhotraJump to last post
03/05/2013 12:41 PM
5 Replies and 1614 Views LDAP Bind with LBI  1614  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 1614
by  Matthew NyeJump to last post
03/05/2013 9:02 AM
6 Replies and 2139 Views Tools dashboard  2139  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 2139
by  GeorgetteJump to last post
03/05/2013 8:38 AM
11 Replies and 1507 Views Disconnect between LBI role and right  1507  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 1507
by  imtyJump to last post
02/26/2013 6:02 PM
2 Replies and 1396 Views Best way to pull accurate received date for Requisition line item.  1396  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 1396
by  NormajeanJump to last post
02/19/2013 12:44 PM
1 Replies and 2182 Views Introduction of Lawson Smart Reports  2182  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 2182
by  George GrahamJump to last post
02/07/2013 11:51 AM
0 Replies and 1150 Views LBI  1150  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 1150
02/06/2013 12:24 PM
11 Replies and 1663 Views SQL Expression Changes - Unix Server to Windows  1663  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 1663
by  RobbyJump to last post
02/06/2013 8:27 AM
16 Replies and 2480 Views Publishing in LBI a Crystal Report reading LTM Database via LAWSON OLEDB Connector  2480  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 2480
by  ric9dJump to last post
02/06/2013 8:26 AM
3 Replies and 1383 Views LBI Structure / Framework For Maximum End User Flexibility  1383  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 1383
by  Matthew NyeJump to last post
02/05/2013 1:36 AM
5 Replies and 2291 Views HISTORICAL INSTANCE ON LBI DASHBOARD?  2291  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 2291
by  MelissaJump to last post
01/18/2013 1:07 PM
9 Replies and 6175 Views Crystal reports hyperlinks in LBI  6175  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 6175
by  JillFJump to last post
01/09/2013 10:59 AM
3 Replies and 5698 Views Overcoming the 65,536 row limit in Excel  5698  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 5698
by  JonAJump to last post
01/04/2013 2:00 PM
2 Replies and 1824 Views Copying LBI PROD Data to DEV  1824  2 Started by  ric9d Is there a step by step process to copy LBI PROD DATA (settings, reports, definitions, users, etc) to DEV
2 1824
by  ric9dJump to last post
01/03/2013 1:07 PM
2 Replies and 1623 Views How does Crystal determine the rowcount in excel?  1623  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 1623
by  imtyJump to last post
12/26/2012 3:47 PM
10 Replies and 2009 Views crystal reports/LBI dynamic data  2009  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 2009
by  Matthew NyeJump to last post
12/14/2012 10:28 AM
4 Replies and 2460 Views Crystal Report Drill Down capability from LBI  2460  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 2460
by  Gary GastaJump to last post
12/13/2012 1:29 PM
5 Replies and 1780 Views Scheduled Crystal Report not be sent out.  1780  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 1780
by  Matthew NyeJump to last post
12/04/2012 11:54 AM
5 Replies and 1349 Views Import of delivery devices  1349  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 1349
by  Greg MoellerJump to last post
11/28/2012 9:47 AM
2 Replies and 1302 Views Report runs in TEST but not in PROD  1302  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 1302
by  RobbyJump to last post
11/26/2012 8:25 PM
19 Replies and 4694 Views Create report based on report user employee hierarchy  4694  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 4694
by  WillJump to last post
11/26/2012 7:09 AM
2 Replies and 1387 Views Connection to MS Access 2007  1387  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 1387
by  Greg MoellerJump to last post
11/06/2012 1:23 PM
13 Replies and 4040 Views Schedule sending (not Bursting) a crystal report via Email to report users  4040  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 4040
by  DeannaPJump to last post
11/06/2012 10:23 AM
11 Replies and 4545 Views Back Office Report as source for Crystal  4545  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 4545
by  gsusnmeJump to last post
10/30/2012 4:22 PM
2 Replies and 1412 Views Output file names for bursted reports  1412  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 1412
by  barbsJump to last post
10/18/2012 12:21 PM
4 Replies and 2337 Views Any issue using PAEMPPOS table to evaluate FTE?  2337  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 2337
by  Paul BerkowitzJump to last post
10/18/2012 10:24 AM
8 Replies and 3520 Views Create LBI user access rights in Crystal  3520  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 3520
by  ChrisJump to last post
09/27/2012 9:27 AM
5 Replies and 2996 Views Reporting on LTM CLOB field  2996  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 2996
by  NabilJump to last post
09/13/2012 2:58 PM
8 Replies and 3839 Views LBI 500 internal server error  3839  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 3839
by  Xin LiJump to last post
09/11/2012 4:49 PM
3 Replies and 1766 Views LBI Dashboard Module  1766  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 1766
by  imtyJump to last post
09/11/2012 12:38 PM
6 Replies and 3852 Views Create Crystal Report with Excel Data and Upload to LBI  3852  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 3852
by  imtyJump to last post
09/06/2012 1:13 PM
6 Replies and 1893 Views Events and Crystal Parameter page  1893  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 1893
by  KevinHJump to last post
08/30/2012 2:07 PM
13 Replies and 2004 Views Crystal 2008 and LBI Drill Around  2004  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 2004
by  KatfraJump to last post
08/30/2012 6:57 AM
4 Replies and 1807 Views Formula based on the Group Level  1807  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 1807
by  David VJump to last post
08/27/2012 10:48 AM
0 Replies and 1316 Views Lawson LDAP Connection from SQL  1316  0 Started by  Layne Does anyone have an example of connecting to ADAM LDAP from SSMS using a SQL Script
0 1316
08/23/2012 12:45 PM
2 Replies and 3733 Views LBI logout  3733  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 3733
by  Display NameJump to last post
08/23/2012 9:10 AM
0 Replies and 1312 Views Roster for Doctors/Nurses  1312  0 Started by  Vijay S Is there a way to prepare Roster(Time Table) for doctor and nurses in Lawson Thnx, Vijay
0 1312
08/20/2012 10:42 PM
2 Replies and 1638 Views Bursting Multiple Reports with one Report Schedule?  1638  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 1638
by  ric9dJump to last post
08/13/2012 8:53 AM
0 Replies and 3447 Views Lawson Smart Reports  3447  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 3447
08/03/2012 3:51 PM
5 Replies and 2076 Views Reporting Services database  2076  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 2076
by  Greg MoellerJump to last post
08/03/2012 3:29 PM
9 Replies and 2605 Views LBI Report Users II  2605  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 2605
by  ric9dJump to last post
07/30/2012 1:30 PM
9 Replies and 2216 Views Create a reporting data store with production data  2216  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 2216
by  Greg MoellerJump to last post
07/30/2012 10:47 AM
1 Replies and 2672 Views IE9 with LBI 904  2672  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 2672
by  WillJump to last post
07/24/2012 2:31 AM
1 Replies and 2086 Views Reports timing out in conversion from Oracle to SQL server DB  2086  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 2086
by  John HenleyJump to last post
06/29/2012 5:40 PM
0 Replies and 1356 Views PSA Data  1356  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 1356
06/25/2012 11:00 AM
2 Replies and 2058 Views Can I reference data in a published LBI spreadsheet in a Crystal report also published in LBI?  2058  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 2058
by  ric9dJump to last post
06/25/2012 10:26 AM
1 Replies and 2107 Views Scheduled Reports in Excel Format (via Email)  2107  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 2107
by  ric9dJump to last post
06/22/2012 10:50 AM
1 Replies and 1965 Views Vendor Address Defaults  1965  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 1965
by  JonAJump to last post
06/22/2012 10:10 AM
4 Replies and 2198 Views LBI html report  2198  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 2198
by  khartJump to last post
06/15/2012 2:38 PM
0 Replies and 1185 Views Panelists wanted for a Focus Group on Performance Management and Continuous Feedback  1185  0 Started by  sathiya Synergita is conducting a market research study among HR professionals on Performance Management and Continuous Feedback. The Focus group is scheduled on June 7th 2012, at 1.30 PM US Eastern Time. HR Professionals interested in participating as a panelist, please contact
0 1185
06/02/2012 3:45 AM
23 Replies and 4445 Views LBI Back Office Reports, publish more than 1 rpt from same job  4445  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 4445
by  Elizabeth ArditoJump to last post
05/30/2012 11:26 AM
2 Replies and 1800 Views Specific AU's not showing in Crystal Reports  1800  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 1800
by  Ruma MalhotraJump to last post
05/24/2012 4:14 PM
10 Replies and 2620 Views LBI/crystal issue  2620  10 Started by  tstanley I keep getting the following message ran running a crystal report from LBI. Can anyone tell me how to resolve this error. Thank you. Error message: SystemErr R The table 'v' could not be found.
10 2620
by  Matthew NyeJump to last post
05/24/2012 7:05 AM
5 Replies and 5655 Views Locating DB Tables/Fields  5655  5 Started by  dukeslater Somewhat new to Lawson, and so far I've been able to find all the fields needed for reporting (Crystal - native connection to Oracle). But now I'm having some trouble locating these two fields: IC12 - Expense account IC12 - Purchase From Location TIA for any help you can provide, specific to this problem or for locating db fields in general.
5 5655
by  dukeslaterJump to last post
05/17/2012 3:18 PM
3 Replies and 2112 Views Developing a rolling 12 month P&L in RW  2112  3 Started by  Whitney Johnson Has anyone developed or can you tell me if I can create in RW a rolling 12 month P&L for finance only showing the Actual amount column for each month The report would need to run for the current month, but then show the previous actual amounts for the other 11 months. Thanks, Whitney
3 2112
by  Whitney JohnsonJump to last post
05/15/2012 2:23 PM
8 Replies and 5413 Views Lawson printing  5413  8 Started by  JimMNH For the time being we have asked users to open LBI reports as PDF and then print them. We would like to setup Lawson printing of these reports but this requires the setup and maintenance of printers, drivers, and user access to printers on the server itself. Since we have a hosted Lawson environment this is not trivial. I was wondering what sorts of solutions administrators in this community have utilized for printing of LBI reports that offers the easist setup/access for their user base
8 5413
by  Ruma MalhotraJump to last post
05/11/2012 11:32 AM
3 Replies and 2153 Views Crystal Reports broken after 9.0.1 upgrade  2153  3 Started by  JonA We upgraded from to at the end of March and since then I've noticed several of my Crystal reports are not pulling the same data as they were before. For instance, I have a Contract Spend report that pulls from PURCHORDER, POLINE, MMDIST and MAINVDTL. I only want supply expense data so I'm filtering the data so the report only shows PO line info for certain accounts. The problem is that no inventory lines are in the report now. I think it has something to do with the fact that...
3 2153
by  JonAJump to last post
05/07/2012 12:57 PM
12 Replies and 3583 Views LBI login and dashboard loading getting slower all the time...  3583  12 Started by  mjcindc I know this is a terrible description of my problem, but I'm a database guy not an engineer.&160; I don't really know our environment all that well.&160; I am, however, responsible for LBI&160;reports and our LBI&160;site is getting slower by the day.&160; The app server and db server are not showing any extradinary resource usage and I'm really not sure what suggestions I can make to our engineer.&160; He's a bit less concerned than I am.&160; It can take 30-40 seconds between clicking t...
12 3583
by  Chris MartinJump to last post
05/04/2012 7:36 AM
1 Replies and 1413 Views A link to change parameters for all reports on a tab?  1413  1 Started by  MCordero I have a dashboard tab with 5 different reports, all with the same parameter, Location. I heard it was possible to have a single link that updates all reports in the tab with a new location instead of having to fill out the parameter in each report.separately. Has anyone done this that can point me in the right direction on how to accomplish this Also, what about a list of links in one module that could change the report that is viewed in a second module
1 1413
by  Matthew NyeJump to last post
05/02/2012 3:17 PM
10 Replies and 1974 Views Schedule report users *Share* ??  1974  10 Started by  Greg Moeller Does anyone have a report of the report users that are attached to the schedules that they would be willing to share I'm being asked to develop one, and I really don't have the time. I've got one that has the main report users, (and I'd be willing to share that) but not one that ties the report to the schedule to the report users on the schedule. Anyone Thanks much, -Greg
10 1974
by  Greg MoellerJump to last post
05/02/2012 2:52 PM
1 Replies and 1828 Views LBI text datasource question  1828  1 Started by  thanef I have a Crystal report that uses a text data source housed on my LBI server. It runs successfully in Crystal on my LBI server but I can not create the correct data source in LBI Report Services. Has anyone done this There is not a text type data source to choose from in LBI. Thanks.
1 1828
by  Greg MoellerJump to last post
04/30/2012 8:31 PM
15 Replies and 4681 Views Setting LBI timeout params  4681  15 Started by  jeff-lbi I have seen the postings on modifying the LBI timeout params for session and portal, etc However, I have yet to discover where this is done In the LBI app itself or a table value or on the hosting server, etc
15 4681
by  Greg MoellerJump to last post
04/27/2012 11:16 AM
7 Replies and 3562 Views Export a scheduled LBI report to excel DATA ONLY format  3562  7 Started by  jeff-lbi There are only options for CSV, xls, pdf, etc. I do not see an option for DATA ONLY excel. How can this be accomplished on the scheduled LBI reports (It IS an option on the on demand report configurations, but not scheduled. Why And is there a work around
7 3562
by  jeff-lbiJump to last post
04/26/2012 12:58 PM
5 Replies and 1877 Views Scheduled report no longer runs after new report user added  1877  5 Started by  jeff-lbi Has anyone encountered this I assume we are missing some other change that must be done after a new Report user is added to a Scheduled delivery for a report. Here is the scenario : (Note that any user we're adding in this scenario DOES have an email device set up, etc, etc) 1) Set up a schedule for a report, set the effective start date, etc, etc and a couple of users. It runs fine, no problems, all the users get their email. 2) The next day we add 1 new user to the schedule (wh...
5 1877
by  jeff-lbiJump to last post
04/26/2012 12:26 PM
1 Replies and 1707 Views Login to LBI Using Domain Account  1707  1 Started by  Layne We are using a domain account called LBICrystalReports to attempt to login a LBI Crystal Report. Going into MY REPORTS and editing the Data Settings \ Default User ID, we add the account using the following format for the Default User ID: GCSD\lbicrystalreports. GCSD is our domain. It will not work and the SQL log error shows that the report is attemping to login using SQL Server Authentificaiton even though the account is a domain account. The permission in SQL Server is sufficient for th...
1 1707
by  Matthew NyeJump to last post
04/11/2012 3:19 PM
6 Replies and 2056 Views Dashboard Tabs - making multiple rows  2056  6 Started by  dcaiani Last year at CUE I saw a customer presentation (I wish I could remember who it was) and they had more dashboard tabs than would fit in a single row. They were able to make multiple rows of dashboard tabs rather than have to click on the 'additional tabs' arrow or use the drop down to view the additional dashboard. Does anyone know how to do this
6 2056
by  Xin LiJump to last post
04/02/2012 3:36 PM
6 Replies and 2007 Views Report Tooltip in underlying data table?  2007  6 Started by  David Levine Hello, The report Tooltip - the report description that appears as you hover your mouse cursor over the report name is derived from the 'Description' text box in the 'Main' tab, when selecting 'Edit...' from the report. Does anyone know where this description can be found in the underlying table structure By the way, I've determined that it's NOT rsuserprd.ers_reports.description - this is the report description derived from Tools-->Reporting Services Report Administration-->...
6 2007
by  Chris MartinJump to last post
03/30/2012 11:56 AM
1 Replies and 2141 Views LBI bursting rights  2141  1 Started by  imty Hello Group, We have a clinic user group with bursting rights in LBI. Some of the financial reports are currently being burst based on the user's assigned to the clinic user group. We have created a Crystal payroll report and would like to create a payroll user group. Right now we have say center 1001001 that has two users attached to it. Now for payroll only one of the user's would have access to the report. If we attach the payroll report to the payroll user group would that control or over...
1 2141
by  Matthew NyeJump to last post
03/22/2012 10:27 AM
2 Replies and 2887 Views HRHISTORY table compare date rows  2887  2 Started by  Sarah How do I use the HRHISTORY table to look at the most recent (fld nbr 51)ADJ_HIRE_DT - (fld nbr 27)LAST TERM DT and if it's less than 365 days take the (fld nbr 26)PREVIOUS SENIORITY DT and add those days to the PREV SENIORITY DT to identify what the employees TRUE SENIORITY DT should be. Example: Employee is rehired with an adj_hire_dt = 02/19/2012. Their previous term date = 02/22/2011 so 02/19/2012-02/22/2011=362 days Their previous seniority date = 03/09/2001362=03/06/2002. I've been...
2 2887
by  SarahJump to last post
03/19/2012 2:20 PM
1 Replies and 1568 Views REPORT server.  1568  1 Started by  MARCO3535 Two of the our crystal users opened up standard crystal reports as they have run (as report refresh) many times in the past, Usually, it will open up to the proper environment, (oldproduction1) and prompt them for a password. This time, however, when they refresh for current data, instead of being prompted for a login in they are being asked to chose what server the report should point to. So they have to point to the server they want. This has occurred for each report they...
1 1568
by  Matthew NyeJump to last post
03/19/2012 1:07 PM
17 Replies and 3543 Views LBI Connection to AS400 Server failure  3543  17 Started by  imty :confused:Hello All, I have a crystal report that I created where it pulls data from the AS400 system via an ODBC driver. The report in Crystal works fine. I have published this report to LBI and in the DATA SETINGS i used INFINIUM as the data source and the following user id and password which works from Cyrstal. Infinium User Profile for ODBC connect. User Profile: LAWPAY Password: PASSLAW Library (Directory) USLAWSON Table (File) ...
17 3543
by  imtyJump to last post
03/15/2012 7:02 PM
4 Replies and 1548 Views Updated to on Thursday in PROD  1548  4 Started by  Greg Moeller Updated on Thursday and now gettting repetitive errors in the log about ReportEngine not compatible with CrystalEngine. Lawson has a JT opened for it, JT-293938, but we are wondering what we can do in the meantime. Can I downgrade LBI by applying a 'Update' Hesitant to upgrade to v because of all of the zeros. Error involves the scheduling and emailing of reports.. coming out corrupt, or prompting for an Oracle database id/password which MANY users do not have. Any though...
4 1548
by  ElenaJump to last post
03/01/2012 11:21 AM
34 Replies and 10219 Views MM280  10219  34 Started by  Chris Martin Has anybody had any success reverse engineering MM280 (ie using sql/crystal)
34 10219
by  SPJump to last post
02/24/2012 11:20 AM
4 Replies and 3306 Views LBI Crystal Reports behavior with Adobe  3306  4 Started by  MHRoy We have recently installed LBI. We have been able to publish 'home-grown' crystal reports and they run fine. When selecting print in the Crystal Reports 2008 viewer a 'Print to PDF' box appears with a Page Range section and information that the viewer must export to PDF to print. If we click on the Export button a File Download box appears. Choosing Open will bring up the local PCs version of Adobe and one can either print or export. Is this the correct behavior for LBI/Crystal Reports ...
4 3306
by  MHRoyJump to last post
02/16/2012 1:32 PM
1 Replies and 2486 Views What's New in LBI 10 document published on  2486  1 Started by  Ruma Malhotra I just found the what's now for LBI 10 document present on Looks like all the auditing related to reporing services and smart notifications have been added to this version. This will be a huge plus for all customers wanting to find out security,render times etc on LBI for a long time.
1 2486
by  mark.cookJump to last post
02/16/2012 11:22 AM
2 Replies and 3082 Views Crystal/Xcelsius and LBI Bursting  3082  2 Started by  Dave Curtis We are currently working on rolling out LBI for our leadership team. One of the things I would like to do is utilize the functionality of Crystal Reports and Xcelsius to develop some interactive charts of employee reviews, certifications, turnover etc. I am not having very good luck with it at this point and before I spend money and time trying to learn more about Xcelsius I wanted to ask the group here if anyone has been succesful at publishing a Crystal Report with an embeded Xcelsius .S...
2 3082
by  Dave CurtisJump to last post
02/09/2012 10:32 AM
3 Replies and 2361 Views Max export to excel ?  2361  3 Started by  jeff-lbi I recently ran a report where the result set was close to 200,000. I know this would require excel to have 4 sheets. Instead of finishing it prompted for a login information and asked for a refreshed data set Does LBI start to have a problem exporting to excel after so many records
3 2361
by  Matthew NyeJump to last post
02/08/2012 3:10 PM
0 Replies and 1401 Views Is there a way to get the user_id name to print on a Crystal rpt?  1401  0 Started by  Deleted User I'm looking to create a report that would show the date and name of the user who added or changed PA59 records within a 24hr window. Is there any way to use the User_ID from the PAGRDI file to get the employees name who add/changed the records
0 1401
02/08/2012 10:50 AM
5 Replies and 3008 Views Open Crystal Report Hyperlink using updateModule in LBI  3008  5 Started by  Daksha Desai I have a Crystal Report open in a module on the dashboard. It has a hyperlink which opens in a new window but I want it to open in the same module. I tried adding updateModule to the link but a url appears before the updateModule and it does not work. Can anyone help please
5 3008
by  Matthew NyeJump to last post
02/07/2012 3:11 PM
4 Replies and 2928 Views Portal Field Descriptions  2928  4 Started by  Layne In the Portal on say Screen HR11.1, there is a field desciption called 'Social Number.' Does anyone know where this field description can be found in the GEN database. I was looking at Docfld and DocScrFld, but they do not seem to contain of them.
4 2928
by  Jim Van ZummerenJump to last post
02/01/2012 8:03 AM
2 Replies and 2483 Views GEN Database Programs and Screens  2483  2 Started by  Layne I am running the following query on GEN. I wanted to see what fields are being used by a certain Program and Screen. SELECT * FROM dbo.PGMFLD WHERE PROGRAMCODE = 'HR11' AND SCRNBR = 1 AND PRODUCTLINE = 'LAWPROD' What is the prefix field used for. Is there a list of the defintions of these fields Let's say I was in the Lawson Portal on Screen HR11.1. I want to know what tables and fields that this form uses, so I can write a report. I am not worried about how to connect back to o...
2 2483
by  Greg MoellerJump to last post
01/31/2012 8:44 AM
3 Replies and 3573 Views Link to Webinar?  3573  3 Started by  Greg Moeller Does anyone have the link to the LBI version 10 Webinar handy The Webinar started 15 minutes ago, and I can't locate the link.
3 3573
by  SPJump to last post
01/27/2012 3:40 PM
4 Replies and 1793 Views No recipients to whom to send the content  1793  4 Started by  Greg Moeller In my SystemOut.log file for LBI, I get a failed delivery 'No recipients to whom to send the content.' message when there is no delivery device set up for a particular report user. Is there a way to associate to which report this user belongs from the rather lengthy error in the log file For example: &91;11/11/11 8:30:21:879 CST&93; 0000005a SystemOut O Email Delivery Status: <delivery-response version='1.0' status='500'><message code='303' description='No recipients to wh...
4 1793
by  Greg MoellerJump to last post
01/27/2012 2:33 PM
3 Replies and 2758 Views Crystal Slow Loading in LBI  2758  3 Started by  jeff-lbi We've been using LBI for almost a year. We have crystal 2008, and we develop front ends using .NET. Never had any problems. However, suddenly with a few new employees we have seen .rpt files take MUCH longer to upload during the re-publish process......and then furthermore take MUCH longer to load the .aspx front end called from the report Events in LBI. I have already ruled out EVERYTHING, and isolated the problem to the .rpt files themselves....but there has to be a LBI component here, b...
3 2758
by  MHRoyJump to last post
01/25/2012 12:25 PM
7 Replies and 5041 Views Crystal Report Viewer Erroring out in 1 IE User Workstation  5041  7 Started by  jeff-lbi First I will preface by saying I've already uninstalled and re-installed Internet Explorer 8 on this machine. It is the only machine we have this issue with. I have not seen this with any of our other users. Basically when a crystal report is run from the LBI interface the window opens but IE bombs out with errors such as : (Related to crv.js) Message: 'Image' is undefined Line: 271 Char: 13 Code: 0 (Related to crv.js) Message: Object doesn't support this property or method Lin...
7 5041
by  jeff-lbiJump to last post
01/25/2012 11:25 AM
1 Replies and 2193 Views Printing Lawson Report Number on Report  2193  1 Started by  Layne I'd like to print the Lawson Assigned Report Number on the report. In Crystal, I tried using the Special Field called File Path and Name, but apparently Lawson copies the rusults report over to a temp folder on the local PC running the report. There is no report number on the file name at this point. Any ideas on how I can do this without running another query to the GEN database.
1 2193
by  John HenleyJump to last post
01/25/2012 9:29 AM
13 Replies and 3876 Views Fields restricted? Excel pull of Lawson data through OLEDB  3876  13 Started by  BertNeu... So, built a DME using Lawson Query builder (LQB), (Employee table, fields = Employee, Pay-rate); execute gives expected fields. Pasted the LQB DME text into the Excel Data -other sources routine results: only the employee field was returned. Hmmm, went back to LQB, and specified the entire employee table, copied the DME, and in Excel all fields came back except anything to do with pay. Same thing when pulling from Timerecord table - only non-pay fileds returned to Excel, despite all fields sh...
13 3876
by  BertNeu...Jump to last post
01/11/2012 3:17 PM
6 Replies and 3691 Views Crystal Reports How to determine frequency of RUNS  3691  6 Started by  Layne Does anyone know the tables in the LawsonRS database that would tell me when the last time a report was run, how often its being run, and who is running it. I see a started and finished field in the ERS_REPORTSTATUS Database, but it does not appear to be correct based on reports I have run.
6 3691
by  LayneJump to last post
01/09/2012 3:19 PM
6 Replies and 3090 Views Oracle odbc drivers for RS ODBC on LBI 904 Win 2008 64bit  3090  6 Started by  Deleted User We are doing a fresh LBI 904 install on a Windows 2008 64bit server. We will need a Reporting Services ODBC data source for Crystal ODBC reports pointing to an Oracle 11g database (Lawson app server running on AIX 6.1 Oracle 11g). Anyone know what Oracle client we should run on the Win 2008 64 bit server; example Oracle 11g client for 32bit or 64bit
6 3090
by  RobbyJump to last post
12/19/2011 12:31 PM
2 Replies and 2174 Views Crystal and .csv table linking  2174  2 Started by  Katfra I've linked a .csv file as my table in crystal. I have a debit, credit, and difference colum in the file which shows in the crystal report, except where anything has a negative value. I've tried creating calculted fields to produce the credit balance in crystal, which worked in my credit column. However, if I create a formula Debit-Credit where my debit might be a zero balance, my result is blank in the difference column. Anyone have any ideas I've tried a running total as well with no luck...
2 2174
by  KatfraJump to last post
12/05/2011 2:40 PM
10 Replies and 3165 Views LBI report users  3165  10 Started by  Jan I haven't found this issue in this forum so I'll post it now. I apologize if this was addressed earlier and I missed it. As employees terminate or transfer, I need to determine if I need to adjust LBI report distributions. Which LBI tables do I need to access to see which reports (or smartnotes) an employee has been a recipient for I have quite a few reports built up, so doing this by hand is getting to be unworkable. thanks in advance for any help you can throw my way
10 3165
by  Greg MoellerJump to last post
11/15/2011 4:34 PM
8 Replies and 2473 Views FS page goes off line with Portal integration (efsrole.xml)  2473  8 Started by  Deleted User I have a single server LBI test system running on WebSphere 6.1.13 Win 2003 Sever SP2 and LBI902.  I integrated Portal a while back with dsso and a PortalRole efsrole.xml file.  My FS page goes off line sometimes when I log into my Portal Test system profile.  The page seems to stay up if I access FS outside of Portal using dsso security.  I'm working a case with Lawson but I thought I would post in the LBI forum to see if anyone else has encountered this behavior.  Ther...
8 2473
by  Massimo EmilioneJump to last post
11/15/2011 4:16 PM
4 Replies and 2817 Views LBI Synchronizing User and Groups  2817  4 Started by  Vito Amatulli Does any one know if it is possible to automate the Synchronize User and Roles fuinction from LBI&160; We re trying to automate adding of Lawson users to security and want to be able to sync the user to LBI.
4 2817
by  Massimo EmilioneJump to last post
10/08/2011 11:33 PM
11 Replies and 2201 Views Scheduled report to be emailed to a directory instead of an email device ?  2201  11 Started by  Ruma Malhotra I would like to find out whetherwe can email a report to a directory instead of an email device Can this be done in LBI We have a report that is scheduled manually every day to refresh. This report needs to be imported to a tool used for budgeting. Can I set a report to refresh on a schedule and then email the scheduled report to go to a directory instead of an email device
11 2201
by  Ben CoonfieldJump to last post
10/07/2011 2:23 PM
5 Replies and 2190 Views Scheduled LBI report to a constant server location  2190  5 Started by  Deleted User We would like to be able to have scheduled LBI reports go to a constant server location so that they can be picked up by a later scheduled process (a ProcessFlow). The LBI analyst tells me that when the report runs it is written to a unique folder for every date with a unique instance number. That will make it difficult for the Process Flow to FTP 'get' the reports. Has anyone found a way to write the report to the same location each time
5 2190
by  Greg MoellerJump to last post
10/07/2011 11:22 AM
5 Replies and 1859 Views Importing Rights with multiple users: Is is possible?  1859  5 Started by  ric9d I have successfullt imported a right file into LBI. However I wanted to assign a right to several users. Of course you could do this manually, however, Im trying to find out if anyone out there has uploaded an imports file with several users. Thanks and any ideas will be appreciated.
5 1859
by  Greg MoellerJump to last post
09/28/2011 3:49 PM
6 Replies and 4084 Views Occassional blank LBI report  4084  6 Started by  des123 We are having an annoying problem with running LBI reports. They will occasionally display blank output. The workaround is to clear out the temporary internet files, cookies, etc... in the IE web browser (Tools -> Options). I thought it might be due to not enough space allocated for temporoary internet files and cookies so I increasing the amount of allocated space to 1024 MB but this did not help. This happens on various reports so we know that it is not report-specific. One moment a ...
6 4084
by  des123Jump to last post
09/28/2011 3:47 PM
4 Replies and 2532 Views Not valid for List error message when trying to access LBI report list  2532  4 Started by  Louise I Help! This was working yesterday and stopped working today. Also yesterday another analyst and I were looking at setup screens but do not recall clicking or changing anything. There have been other Lawson issues and a company firewall change that went in. Also, the custom group that these employees are members of was strangely missing from all the reports that used to have it in the Users lists. I added it back and that did not resolve the problem. There's also an attribute called HR that wa...
4 2532
by  Louise IJump to last post
09/28/2011 3:40 PM
2 Replies and 1447 Views Only Crystal?  1447  2 Started by  mcarlson maybe a really dumb question....or maybe one that has been covered out here before....but here it is... Can SSRS (SQL Reporting Services) be used with LBI or is it required that you use Crystal Any success or failure stories using something other than Crystal Thanks!
2 1447
by  WRBJump to last post
09/27/2011 3:57 PM
11 Replies and 7978 Views Is there a way to execute a program from within Crystal Reports 2008?  7978  11 Started by  C Fritz Hello - I am trying to find out if its possiblet execute a Windows batch file from within Crystal Reports. Does Crystal reports have the capacity to make a system call to the OS and execute a command outside itself If it does can you please explain the syntax or point me to a source that enables this Thank you.
11 7978
by  C FritzJump to last post
09/23/2011 2:31 PM
3 Replies and 3548 Views The maximum report processing jobs limit configured by your system administrator has been reached.  3548  3 Started by  Xin Li We have a crystal bursting to hundreds of users every month. It worked before we upgraded to LBI and CRAS Now report bursting was crashed and user got pdf file unopenable. The error is 'The maximum report processing jobs limit configured by your system administrator has been reached.' It looks like LBI just overloaded CRAS server when brusting rendering report.Google the whole internet universe and change PrintJoblimit in registry, no luck so far. Any help appreciated.
3 3548
by  Greg MoellerJump to last post
09/16/2011 5:08 PM
3 Replies and 2977 Views LBI Email Delivery Scheduling  2977  3 Started by  jeff-lbi I have set up my email device in LBI, and perform a test delivery (we have also scheduled deliveries but have yet to get them) I have activated my email device as well. Which is through email, so why we don't get any other emails is confusing. When we do a test we get the following error: Unable to send content to host {0}. Simple and broad message, but just wondering if anyone had any insight Thx
3 2977
by  Ruma MalhotraJump to last post
09/15/2011 2:59 PM
1 Replies and 1407 Views Assigned role not stick with user in LBI  1407  1 Started by  Xin Li After we upgraded LBI to We found another crazy issue with LBI. In Lawson security we assigned four roles to a users. IF we go to manage users and roles it sometime show the user has four correct roles. After a while, two role disappeared from this users. Sync user and roles they may show up with four roles or only two roles. Anyone had such issue What are the solution
1 1407
by  Xin LiJump to last post
09/13/2011 2:03 PM
2 Replies and 2472 Views LBI timedout issue  2472  2 Started by  Xin Li We open LBI by click link in Lawson portal. However, we encounter page cannot display error everywhere in LBI after a period of time. We have to logout Portal and login back then reopen LBI. Even if portal prompt us to login again, it still have the same issue. This problem occured after we upgraded to LBI
2 2472
by  mark.cookJump to last post
09/09/2011 7:37 AM
6 Replies and 3780 Views LBI report field overlapping  3780  6 Started by  Xin Li We have a crystal report that has a longer field that is overlapping the field to its right. We shrank this field so that it will not overlap in crystal designer. However, when we publish the report to LBI, the report is displaying field overlapping. Anyone experienced this and any suggestiion
6 3780
by  Xin LiJump to last post
09/08/2011 10:20 AM
0 Replies and 2131 Views Budget Actual Reporting (K12)  2131  0 Started by  amynelson Has anyone had to create Crystal Reports to show Budget Actual for a K12 or similar customer This particular situation is that at Year End when the GL198 is run it shows all open PO's no longer as an commitment, but as an expense. So when they run budget analysis reports for period 12, prior fiscal year all Encumbrances and Commitments are zero and Expenses are increased and Budget remaining is reduced. The problem that I am finding is that when the GL198 is run, the commitment year and ...
0 2131
08/26/2011 10:09 AM
1 Replies and 1380 Views Solution Set for Reports - Report ID?  1380  1 Started by  George Graham How is anyone else handling this: Report is created on test LBI and validate by users. Report is attached to a dashboard - therefore the link in the dashboard has the ID of the report in the URL. The desire is to be able to make test and prod LBI identical - and utilize automated procedures to migrate stuff from test to prod. But when creating a solution set from test and then loading it on prod, when the report is loaded on prod it loads it as a new report with new ID. So for new reports ...
1 1380
by  Ruma MalhotraJump to last post
08/24/2011 11:26 AM
0 Replies and 2401 Views Reporting Services: Saved Parameters Option  2401  0 Started by  WRB Has anyone used the Reporting Services Option 'View with Saved Parameters' I am attempting to actually save a parameter but not having any luck. 1. I mark the option under Maintain Parameters 2. I run the report that has parameters 3. I complete the required parameters 4. I name the parameter set. 5. The report runs but when I go in the 'View with Saved Parameters' there is nothing there. Once I get the 'View with Saved Parameters' option to work how do I show it on the Dashbo...
0 2401
08/24/2011 10:13 AM
1 Replies and 1492 Views LBI Uploading Rights  1492  1 Started by  ric9d I had several RIGHTS uploaded to LBI. Then I scheduled bursted (crystal) report. However all users are getting a 'File is corrupted of damaged' error message. Interestingly, if I manually create a RIGHT and schedule the report, bursted and all that, it works! If anyone has any idea or has encountered this issue, please, please let me know. I have created a ticket for this with Lawson Global Support, however, sad to say, they are as CLUELESS as me!
1 1492
by  George GrahamJump to last post
08/23/2011 10:37 PM
0 Replies and 2278 Views Publishing a Crystal Report with a SubREport  2278  0 Started by  ric9d Can anybody tell me how to publish a Crystal report with a subreport in it If you could do it on a numbered step by step process then I would greatly appreciate it. Thanks.
0 2278
08/17/2011 8:42 AM
0 Replies and 1993 Views Options for saving Report output (file name) from LBI Dashboard  1993  0 Started by  Daksha Desai I have a link on a dashboard that creates a report in csv so that the user can save it. How can I set a file name with a type of txt for this Location (url) is: http://vmlbisrv.domain.corp:9080/ers/ersRequestHandler.jspCMD=VIEW&INSTANCEID=LATEST&OuterWrapper=true&NewReport=true&REPORTID=35&OutputType=csv
0 1993
08/16/2011 9:14 AM
4 Replies and 2015 Views Publishing ReportWriter Reports  2015  4 Started by  ric9d Is it possible to Publish reports written in report Writer I have been searching the web for a while and I havent a clue. If it is possible Can anybody tell me how to a step x step procedure will be most welcome. Thanks!
4 2015
by  Greg MoellerJump to last post
08/11/2011 8:23 AM
1 Replies and 1750 Views Bursting in LBI; user is noted as <device only user>  1750  1 Started by  ric9d I uploaded a bunch of users into LBI using import files. Some of them, those who has NEVER login to LBI (even if they were given access to it) would have their user id with '<device onlyuser>'. I bursted the report to 2 people, one who had accessed LBI before and the other never had. IT did not work, the former got his report but the latter didnt. Does anybody have any idea Do users HAVE TO HAVE lbi access to get an bursted/emailed report Thanks in advance.
1 1750
by  Greg MoellerJump to last post
08/10/2011 12:48 PM
3 Replies and 1793 Views Unable to export LBI report  1793  3 Started by  TBonney OK, this is a wierd one... I have a user who is attempting to export the output of a Crystal report run from an LBI dashboard. The report runs fine, but just won't export for her. Also, other users are able to successfully run and export the same report & save their results locally. However, when this particular user hits the export icon, the cursor simply displays this wierd little yellow icon that looks like some sort of sunburst with a squigley red outline. But, there is no text displa...
3 1793
by  mark.cookJump to last post
08/05/2011 1:11 PM
3 Replies and 1627 Views Search box in framework services?  1627  3 Started by  George Graham Anyone know how to remove the search box that shows up for LBI Since this is linked into portal both search boxes are showing up and confusing users. I'm sure I can dig and find it but thought I would see if anyone has already done the leg work. Thanks.
3 1627
by  Chris MartinJump to last post
08/01/2011 1:27 PM
4 Replies and 2152 Views Options for export?  2152  4 Started by  Greg Moeller Just asking a question (at least for now). Is there any option available to export an LBI report automatically to a file share  We'd like to keep a couple reports, and don't want to have the manual task of daily saving the emailed versions. Thanks for any suggestions, -Greg
4 2152
by  Greg MoellerJump to last post
07/12/2011 2:43 PM
6 Replies and 2902 Views RW100 copy to Crystal  2902  6 Started by  BShort I was just at CUE and heard that we can take the RW100 and have it copied into Crystal without rebuilding the report in Crystal after all the work was completed in RW100. How do I do accomplish this task Thank you.
6 2902
by  AmyVJump to last post
06/29/2011 2:19 PM
1 Replies and 1282 Views LBI 902 compatibility with Lawson S3 901  1282  1 Started by  Deleted User Greetings Gurus! Is anyone running LBI version 902 with S3 Lawson Apps 901  We are preparing for an apps upgrade from Apps 9msp6 to Apps 901.  Anyone have any input on the required changes for LBI  Your input as always is much appreciated! Joanna
1 1282
by  George GrahamJump to last post
06/22/2011 1:36 PM
1 Replies and 1543 Views Filter a Smart Notification on a Dashboard Tab  1543  1 Started by  MCordero I've created a  Smart Notification with the username field set as a parameter. I can manually add the parameters to the URL to filter it with http://.....&paramcount=1&param0=&91;username&93;  What are the steps I need to take to dynamically show the information on a dashboard to filter according to the user viewing it  If not with username, then employeeID or possibly a specific Security Group
1 1543
by  Matthew NyeJump to last post
06/22/2011 12:27 AM
6 Replies and 4585 Views Drill Around question  4585  6 Started by  George Graham I know in Crystal Reports I can create a hyperlink using drill.jsp. And I can use query builder to get the specific drill strings. However, is there a way to do a full drill around similar to what pulls up in portal I.E., when I'm on the Employee field in HR11 and select drill I the menu of all drill arounds. I've tried capturing the calls from within portal but those calls are simply generating the drill lists and I assume the servlet is then building the form displayed....
6 4585
by  Fernando LabradaJump to last post
06/14/2011 4:53 PM
2 Replies and 2911 Views QuickStep Crystal Reports - How to view data  2911  2 Started by  ErikaS Hello, For the life of me, I cannot successfully connect a Lawson QuickStep Crystal Report to my data source. Out of the box, the data source is set to I preview the data, it prompts for parameters (which I fill out) then it prompts for data source, username and password.  I fill in the data source credentials that I want to use and I get the following: 'Failure to retrieve data from the database. A failure occurred  during the generation of schema inf...
2 2911
by  Ruma MalhotraJump to last post
06/14/2011 4:38 PM
3 Replies and 3056 Views RW100 for Crystal Report  3056  3 Started by  wintergreen I'm trying to do a RW100 as a data source to Crystal Report for budget report. How do you define a RW report which includes all the account units Currently we have one RW report for one account unit in RW100.  So we have 50 RW100 reports for each account unit for its budget report.  Is it supposed to have all the account units in one RW when you want to use it as a data source for Cystal Report ( Each account units have the same account number for salaries, bene...
3 3056
by  wintergreenJump to last post
05/26/2011 9:29 AM
3 Replies and 1606 Views email bursting  1606  3 Started by  wintergreen I am able to burst smart note by process levels through email.  I created a list which mapping the pocess levels and users's email addresses. The question I have is if someone has multiple process levels,  he will receive multiple emails; each email is for each process level's data.  I wonder if there is a way to put all his process levels' data into one email only Any input will be much appreciated.  Thanks!
3 1606
by  Matthew NyeJump to last post
05/24/2011 2:51 AM
1 Replies and 2106 Views Other BI tools Compatible with LBI  2106  1 Started by  Ruma Malhotra I am just curious to find out if anybody is using other BI tools that are non lawson supplied especially the analytics suite and whether you were sucessful in deploying thes BI enabled graphs, grids etc to LBI. I am particluarly interested in finding out more about microstrategy and silver light. Would love to hear about your experiences with these tools not for only reporting but for analytics. Thanks in advance.
1 2106
by  Matthew NyeJump to last post
05/20/2011 12:57 AM
2 Replies and 2159 Views 3 Tools dashboards ?  2159  2 Started by  Greg Moeller Hi, All! Here's the issue:  The other day, I started seeing 2 Tools dashboards.  (I'm basically the guy that takes care of the technical stuff with LBI). I have a user here in IT that sees 3 Tools dashboards.  They are all identical (as far as I can tell). How do I differentiate between them to tell which is the 'real' tools dashboard and delete the other 2 Anyone ever had this happen to them Thanks in advance, -Greg
2 2159
by  Greg MoellerJump to last post
05/19/2011 12:04 PM
4 Replies and 2507 Views LBI security / users  2507  4 Started by  Chris - MIBH Created a new list with a couple filters and loaded to the module on the dashboard.  We are using Lawson security groups for access and bursting.  When user click on the link in the module they are converetde to my, or the list/report ownwers log in and security.  Anyone seen this before  We syncronized users but it did not fix the problem.  We are on Help
4 2507
by  Chris - MIBHJump to last post
05/18/2011 12:08 PM
8 Replies and 1793 Views Unable to view Framework Services System Adimin Tools with DSSO - Pls help  1793  8 Started by  Ganesh R Hi I've installed LBI, DSSO & have intergrated with existing LSF 9 Portal. However, after logging in, I noticed that the Framework Services System Admin Tool is missing. This happens when I login as Framework services (like http://hostname:9080/efs) as well as in Portal. However, if I change the authentication to File Authentication, this issue does not appear I see complete menu. Has anyone come across this type of error earlier Any input is appreciated. Tks.
8 1793
by  Ganesh RJump to last post
05/16/2011 11:42 AM
5 Replies and 1904 Views On Demand Crystal Reports in Reporting Services  1904  5 Started by  WRB We have several reports published in Reporting Services ( all of the reports are written in Crystal 2008 and have parameters.  When I request the report(in LBI) (on demand) it takes 30 seconds to return the parameter screen.  Does anyone have suggestions on how to speed this up  This is a new install so any fine tuning suggestions is much appreciated. Thanks
5 1904
by  WRBJump to last post
05/05/2011 5:27 PM
1 Replies and 1618 Views Array Summaries that will not Print  1618  1 Started by  Donna I have been working on an Employee Position Report and created an array for all the departments to roll up into the union and report summaries. The array is capturing all the departments and printing them individually but it will not print them all simultaneously in the format we need for the Union Group Summary. The issue is not documented on the Lawson forums. Some Crystal internet forums documented the issue as a Crystal 2008 issue. I employed their print suggestions but none of them work wit...
1 1618
by  DonnaJump to last post
05/02/2011 7:25 PM
6 Replies and 3765 Views LBI authentication against ADAM  3765  6 Started by  Anne-Marie hi, We try to setup LBI authentication against ADAM. We use advanced ldap/msad settings. Our ADAM contains groups and members for example G_LBIAdmins. After making the changes in the configurationAssistant, we restart IBM websphere.  The next step is to do an Authentication test in the InstallValidator. But we never pass this test. Always the same error : (security:3004) Login failed. The userid or password entered is not valid, or the specified user does not have access to thi...
6 3765
by  Anne-MarieJump to last post
04/29/2011 4:04 PM
0 Replies and 1858 Views Lawson Webinar today at 10:00 AM and 1:00 AM on LSO  1858  0 Started by  Ruma Malhotra Topic: Constructing Efficient Data Queries Using Lawson Add-Ins for Microsoft Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 10:00 am, Central Daylight Time (Chicago, GMT-05:00) Event Number: 665 619 705 Event Password: This event does not require a password Registration ID: This event does not require an enrollment ID Topic: Work Smarter with Lawson Smart Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 1:00 pm, Central Daylight ...
0 1858
04/28/2011 9:19 AM
5 Replies and 3103 Views On Demand Reports in Reporting Services  3103  5 Started by  ISO Dan Does anyone know how to run an on demand Crystal report in reporting services without scheduling it and retain its history We just want to be able to run the report and not have to go through the set up of scheduling it.
5 3103
by  Matthew NyeJump to last post
04/28/2011 12:50 AM
1 Replies and 1391 Views Add Parameter Values to Instance Name or Description  1391  1 Started by  ISO Dan Does anyone know how to add parameters to the instance name or description automatically  We want our cost center managers to be able to easily tell which period the report is run  (older periods sometimes need to be rerun and it sometimes get confusing) instead of them having to go into each report. I know you can edit the instance name but we have over 50 reports and it would be a pain to have to edit 50 instance names.  Is there a way to display the parameters or append to ...
1 1391
by  Matthew NyeJump to last post
04/27/2011 8:22 AM
6 Replies and 3856 Views Can you join PRDISTRIB to PRTIME?  3856  6 Started by  Gail Can you join the PRDISTRIB table to PRTIME I need to join the PRDISTRIB table to PRTIME so that I can get the hours from PRTIME. The reason I'm using PRDISTRIB is we have pr23 records therefore the distribution accounting unit is different in prdistrib then what is in prtime. I need to create a report that shows where the amount landed in GL and the associated hours (which do not write to gl). Thank you for your assistance in advance!
6 3856
by  Carolyn LeeJump to last post
04/26/2011 1:51 PM
0 Replies and 1436 Views Viewing a work file in LBI  1436  0 Started by  maryclare hi all - i am wondering if anyone has used webrpt.exe to display files in LBI  i have done this before to display a print manager file, but i would now like to be able to display a work file (csv format) in LBI.  i am unable to use webrpt.exe, since the file path does not exist in the USERRPT table.  is there another way to display a file from the server (unix server) through a link in portal or - maybe there is a way to 'register' the work file in the USERRPT table th...
0 1436
04/20/2011 11:01 AM
0 Replies and 2460 Views Suppress Crystal Viewer Error messages?  2460  0 Started by  George Graham Have a report link on a dashboard that provides users with only access to report instances - i.e., if no instance has been created it does not run on demand. This gets controlled with permissions properly. However, when users click this link - since they do not have data refresh permission - it gives them a 'somewhat' cryptic page stating: Message: This report doesn't have saved data, it can't be viewed, exported or printed without invoking a data...
0 2460
04/19/2011 10:19 PM
4 Replies and 1460 Views SmartNotes to open Crystal and jump to a page  1460  4 Started by  David Williams Can you set up a Crystal Report with links (in our case to an Activity value) and open the report to that point in the report If you can, can you open a Crystal Report from a URL link in SmartNotes If yes to both, can you pass the Activity number as a parameter in this SmartNote URL link so the Crystal Report opens and jumps to that Activity
4 1460
by  David WilliamsJump to last post
04/13/2011 2:30 AM
1 Replies and 1327 Views Displaying Reports on Dshaboards - CR2008 LBI9041  1327  1 Started by  Nick We upgraded LBI to a few weeks ago and just upgrade Crystal RAS to CR 2008 this morning.  One change we noticed is that CR 2008 now has tabs along the tops of the reports.  My guess is that any expanded groups will open in new tabs like they do in the Designer. This will be nice for those type of reports.  However, our problem is that there are a few reports that we have displayed directly in dashboard modules.  We hide the Group Tree and Toolbar so they just show ...
1 1327
by  George GrahamJump to last post
04/12/2011 10:09 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 2 of 5 << < 12345 > >>

RSS Feed Available