In Version 904 any LBi roles defined at the dashboard levels is cascading down to the modules and indiviual links on the modules when any new role is added to the dashboards and saved. We have different levels of security set up for different modules and even links on the module. As an example if we have the HR dashboard, we may have all of the roles defined but we have modules where we have compensation, termination and not everybody on the HR dashboard should have access to these modules...

Hi All, I have a request to calculate the length of time an employee has been in his/her position. I need to consider promotions, demotions, new hires. I am not sure which table(s) to start with... Could someone point me in the right direction Thanks in advance, CW

i have a report which i added to the lbi. i can run the report when i log in as the admin, no problem. when i log in as a specific group i get this error message You do not have access to view the latest instance of this report. the sharing on the report is set up to view all and i even added the group to the view users. do you think it may be a permission thing on the backend package

We did an LBI upgrade, amking copies of the LawsonFS, LawsonRS and LawsonSN SQL Server databases, installed LBI 90110154 which matched our current production LBI version, then upgraded to 9.0.3.2. We also migrated our Lawson Documents and Archive files from the current prod server to our new server. We pointed LBI to our new 9.0.1 Lawson apps product line database. We expected these reports to come up with the parameters we had set in our current production. We can go in and make the correct sel...

Hi everyone, I'm trying to filter a job description to include only people with certain stings. For example: If Employee A job title includes 'Manager' then include it Usually Job title fields would contain a long description like 'AS0 HR Manager 2 Loc' I'm only interested in the 'Manager' part. I tried using like '' but that didn't work. Regards,

I am working on creating a report that extracts various information on the PO based on the comment code. The code can be attached at the header or the line level. While I can see information on the comment code on table STCOMMCODE(PO). Unfortunetly this table has no links to a specific PO. in looking in various table like POLINE or PURCHORDER I have hade no luck in tracking the field to a specific table. Has anyone out there had any luck tracking down the table the comment code resides in...

Can anyone give me examples of items to place on a Dashboard for Human Resources Thanks

Can anyone provide some examples of items they have on their Finance Dashboard in LBI Thanks.

Has anyone created a Crystal Report using Account Attribute Lists I want to use the GLAMOUNTS table but don't know how to join the account attributes to this table.

Hello all, I need to place a filter in my Command using OLE DB Query builder for the following: BENEFIT.STOP-DATE equal date(1800,1,1) or actually: BENEFIT.STOP-DATE is Null Does anyone know the syntax for Query builder to have this criteria I want to report to only output records with a null BEN-STOP-DATE... Thank you much,

I need to setup SSO for an LBI 9.0.4.1 install with LSF 9.0.1.5. I see that now we have to create a direct IOS service to do this. The documents state that the Websphere service needs to run as a named user. Has anyone done this before I have 3 total service one for the Node Agent one for the Cell manager and one for the application server. Do I need to set this account for all 3 When I try this the services start and then stop. I am running Websphere 7.0.0.9.

Hi We've a requirement to use 'OLE DB Connector for Lawson OLE DB Object Services' along with LBI for Reporting Services. Appreciate, if someone can throw some light on how we can get this driver installed using Lawson support site. Thanks.

I have a client implementing ML and I've written a few dozen GL reports for them. It appears I'd simply replace the GL Tables with ML tables for MLAmounts and MLTrans. I don't have an operational database yet and I'm trying to scope the effort so if anyone can confirm that, I'd appreciate it. Thanks!

Has anyone had problems keeping the formating of your report when exporting it to PDF and figured out the solution My Finance department has requested their reports be a specific font (Arial), fontsize, margins and fixed dollar sign. I coded the Crystal to their exact specs and when I print it directly from Crystal, it is just what they are looking for. However, when I export it to a PDF format, the fontsize shrinks, the margins change and the dollar sign floats. My manager insists that I fi...

Is anyone else occasionally having an LBI report delivered to a users delivery device as an attachment that they cannot open because of 'Adobe Reader could not open because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded). This has been plaguing our users occasionally just about since we came up on LBI. Anyone have any suggestions as to how to solve it I've reported it to GSC now ...

I am trying to define a link to AP10 in smart notifications. Everything works fine. When I get the email alert and I am trying to click on the field to go to the application form in this case AP10, I get an error : 'The link to the Lawson form AP10.1 has not been defined.' How can I resolve this

Anyone done a connection (data source) from Smart Notifications to a MS Access DB Could you provide me examples of what should be populated in the fields on data source creation Thanks in advance, -Greg

Can I create a query that will pull data based on a date calculation I want to pull monthly purchase order information but only for 1 year back from the current date. So I can schedule the report to run at the end of each month and not have to change the date range every time. Something like - 365.

1) Can you use Crystal XI to create Pivot tables 2) If you can create Pivot tables in Crystal can you use LBI to Burst the table

Hello, I am using Crystal to write our annual Benefit Statement. One of the sections is related to 'Paid Time Off.' An example is 'Based on your xx years of service you accrue xx hours per year.' We have one for Holidays to...and we have several employee groups who earn a different number of holidays. I want to be able to use Lawson fields/tables to create this formula (showing how much they accrue per year) but I don't know how to do this. The employee/plan/structure gr...

Is there a way to force an RW100 report to run for a previous period without having to manually input the period number We publish the rw100 reports in LBI and have to manually run them for the previous period after the period is closed and I am trying to automate the process. Thanks

Is it possible to have report parameters that are selected by the report user to limit the output for the dispplayed report from a historical instance. For instance, if we have a termination report for the entire company that is scheduled to run every Monday, is possible to add a parameter (e.g department) that the user would be prompted for the further filter/select data from the historical instance If so, how would this be accomplished

Hello, I'm trying to burst a report to supervisors based on the departments they cover. In Reporting Services Administration, I've been able to set this up by using Import Rights, linking the supervisors user name to a specific department. Since supervisors change and employees change departments, is it posible to automate the process of uploading user rights with a CSV file Thanks in advance for any input, Carl Seay

I have written several Oracle stored procedures for our production and test Lawson DB. When I connect via ODBC within Crystal, I see the Stored Procedure in production, but I can not see the ones in Test. Any ideas why I am not able to see them in test

I have crystal reports in the LBI. When the report is run it goes to the crystal viewer. when you select print it gives the option to export to pdf file. when export is chosen i get DOWNLOAD ACTIVE X prompt from the web. it then requires the user, after it is installed, to re run the report. how can this be fixed change permissions