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

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

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

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.

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

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 Below is the criteria in a crystal report I put together (EMPLOYEE table has an outer join with PAEMPPOS so you can get the previous FTE on PAEMPPOS) to test the file...

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

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!

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

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.

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.

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

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. - 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 Lawson IOS Service & Lawson Portal Service strings as i had in Crystal XI. I'm thinking that string may have changed for the upgrade to Crystal 2008 but haven't been able to fin...

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.

Does anyone have an example of connecting to ADAM LDAP from SSMS using a SQL Script

We are looking to resolve a concern where the LBI dashboard page does not have, nor does it allow for, log out functionality. We are on 9.0.4.2 of LBI running on Windows 2008 server. Previously on 9.0.3, we embedded a call into the webpage so that when the LBI IE window was closed, it would redirect to a link that would allow logout of LBI using the format http://www.example.com/sso/logout.htmhttp3A//Fwww.example.com/path/to/page/shown/after/logout/index.htm. It no longer will accept that scri...

Is there a way to prepare Roster(Time Table) for doctor and nurses in Lawson Thnx, Vijay

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

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

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

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

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

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

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:[microsoft][odbc sql server driver][swl server] The transaction log for database 'tempdb' is full. To find out...

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