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 when it wa...

Is there a step by step process to copy LBI PROD DATA (settings, reports, definitions, users, etc) to DEV

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...

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

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...

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

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...

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

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...

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 and...

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...

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.

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[A document must contain exactly one root element.] occured while parsing XML response [1],Col[0]. I don't kn...

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...

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....

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...

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

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...

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

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...

Setting up the LDAP bind with LBI FS. Not using DSSO. Windows 2008 Env = 9.0.1.9 LBI v 9.0.4.x So, in setting up the Authentication Service, I choose LDAP and fill out the LDAP Bind parameters and credentials which I have. Under the 'Administrative Role' what goes in that Thank you, Roger

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

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

Good Afternoon, I am trying to get the date in which an employee entered their current position, whether it be through a transfer or if they were hired into the position. The date can be seen in PA10.1 Length of Service and is called Service Date. I cannot click on it to find out what table and field I can find it in through Crystal. Can anyone help http://img.photobucket.com/albums/v233/Rirruto/image001_zps7e1e0008.png

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...