We are using attributes defined on every accounting unit to group it as a management heirarchy in the organization. For eg every accounting unit has a Director, Sr. Director, VP and Sr. VP. This helps us to group all accounting units to belong to a director which then falls under a sr director, which falls under a VP and then under a SR VP. Using the consolidated option for report writer we use it to look at the totals for a VP. But the report writer's limitation is you can use it only for one ...

We want to burst a report on our new dashboard. Can anyone give me a clear explanation of what Elements and Structures are/do The documentation is vague. Any replies would be greatly appreciated!!!

I have a report that has several parameters; two of them are Boolean. I set them up with descriptions so they don't just say True or False. If you use it for a while (in testing), when you click the drop-down, you don't just see my 2 descriptions, you see a list of True, False, True, False, etc. Screenshot attached. Has anyone else had this issue and did they find a resolution Thank you.

LBI userid/password question When I develop a Crystal report to later be published into LBI, I use my own user id/password.  When the report is ready to publish, I want to schedule that report to run and publish over the weekend.  When the report is scheduled to run in production, though, I don't want to leave my userid/password in the schedule for various reasons - such as the fact that my password will change periodically, or -- if I leave my position, my userid would be disabled. I'd like t...

Hi, Is there any way of accessing Lawson tables via MS Access Either via DME calls or ODBC/OLE-DB   Petter

I have been searching (if that’s what you can call it) through the MyLawson support pages to no avail! God do I hate that site, I can NEVER find what I am looking for! In LBI I want to display a Crystal report and then have that report only display the current logged on user's data on that report. The field on the report that I want to use for my report filter is 'major purchase class'. I currently have the report setup and displayed on the dashboard, that part works fine. I just need help...

Currently we have a single LRS server with plenty of memory and CPU power but reporting is dismal and takes forever. The server with max users on it only hits 1-3 utilization. Currently we have limited the maximum RAS allowances to 60 reports at once since it crashes the RAS service with anything more. Since I am new to Lawson and just started working on this box yesterday here is what I have done to increase performance- This is CRAS 10, Tomcat 4.06 on a Windows 2003 server SP2. For T...

Has anybody tried to query the invoice comments table to create a report.

Well I have managed to install LBI (efs,ers, and sn) on Websphere 6.1 FP13 with CRAS VI R2. I can login and publish reports, but when I run them I get an error that the file could not be found. Below is my Websphere log- com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready. ---- Error code:-2147467259 Error code name:failed com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready. ---- Error code:-2147467259 Error code n...

We recently installed LBI and I'm looking for a way in LRS / Crystal to create reports that are written to disk. I've heard that some versions of the Crystal server can do this, but I’m told the version of this that Lawson OEM’s with LRS does not have that functionality and that LBI can only publish to a printer or email device. It was my understanding that Lawson was positioning LRS / Crystal  as the “new technology” offering for users who wanted to get away from RW100 and HR Writer. The abilit...

Hi, I originally tried to run with FP 21 from IBM, but there was a change in the ODBC driver that is included with Websphere and it broke ODBC connectivity. I did find that there is a minor rollback, but I find that kind of sloppy and would just like to run with the most current complete FP without having to piece it together. What is the latest-no broken FP available that will run with LBI Are you running it Thanks.

Has anyone created a RNI aging report can you shaer what is the quickest and easiest way to create this report Thanks, ruma.

Hi, We use bookmarks in Portal to view reports on our old LRS server. They use a link like- http://server.com:18001/efs/FSRemotefsid=RS:RS-Lawson LRS/LBI Server:806 Is the the fsid the SID etc I have tried a similar link to the new LBI box and also used a link like- http://newserver.com:9080/ers/ersRequestHandler.jspDisplayReport=true&CMD=VIEW&REPORTID=25&INSTANCEID=LATEST with different permutations, and still no luck. What am I missing I have been sifting through Lawsons KB and came a...

We are in the process of creating a new environment for LBi. This new environment involved a brand new instal of LBi which was completed and the oracle schemas for reporting services and frameweok services were also copied. We have now noticed that we go into the dashboards it is missing certain modules and reports. So the solution to this issue is to export and import dashboards. When we try to import dashboards, what framewrok services is doing is trying to rename the ids of these contents an...

Is there a way to hide the group tree as the defult when I open a report on a dashboard Also related to that can I set the display to be anything other than 100

I have a Crystal report using OeInvoice (this report also includes oeinvcline & oeinvcmisc)  I need to add the date this was paid in AR and the due date.  I think I need to get from the arapplied table to the oeinvoice table, but I need some common link in between the two. The oeinvoice file has the invoice nubmer in two seperate fileds and the arapplied has them comgined in one field so I can not link on that common field. Has anyone linked these tables or know if I am not looking at the corr...

I have a series of reports which I want to run following each of our biweekly payrolls.  However, the LBI scheduler only has monthly and single week scheduling options.  I don't see any way I ran run a report every other Friday, for example.  Does anyone have a workaround for this, or is there something I'm missing here

Has anyone applied the Daylight Savibng patches for LBI yet If so, what option(s) did you select  We are on IBM WebSphere Application Server - ND, 6.0.2.11 and version 9.0.10 of LBI.  The IBM site is a bit confusing and it appears that we have multiple choices. Any suggestions would be welcome. Thanks, Vito.

I am a strong Lawson user, but average when it comes to Crystal.  What is the easiest way to create a Balance Sheet and Cash Flow statement in Crystal using Lawson tables

I have some labor distribution reports I'll be publishing every two weeks and this historical reports will stay in the dashboard.  We'd like the report description to show the reporting period the report is for.  Is it possible to do this without re-creating new portal and LBI jobs each time I run the report

Hello,   Has anyone successsfully linked apdistrib records back to the PO line items that make up that amount specific amount, i.e. Qty X Price = Ext amount  I have had some success, but not consistent success with all PO's.  Just checking to see what level of success others have had. Thanks.

Hello- We are using LRS and Crystal 10. I have a report that is publihsed to a LRS dashboard but I cannot locate the Crystal RPT file. How can I determine the location of the rpt file for this published report

I installed LBI 9.0.3 on our current windows environment running on LSF9.0 and WAS 6.1.17.  I was able to setup datasource in RS but not in SN.  I am using the following for the JDBC connection com.microsoft.jdbc.sqlserver.SQLServerDriver. When I do the test settingsI am getting the following message Test of Data Source Failed! com.microsoft.jdbc.sqlserver.SQLServerDriver. I am also not able to setup data source using DME connection also.  Did I miss anything during the installation

We have LBI version 9.0.1.7.26  that was purchased a while back and we are thinking of implementing this soon. We are currently going through LSF 9 migration on Windows and will be moving to apps 9 by May 2010. Would it matter if we did LBI before we did apps 9 or would it be best to wait until after

We have upgraded LBI 9.0.2.2 to 9.0.3.1. Since we also went from a 32 bit environment to a 64 bit enviroment on oracle I was wondering if anyone has gone through a similar upgrade and what happens to the LBI schema which was previously on 32 bit and now upgraded to 64 bit. Also  is ther any changes on the naming for the instances on 9.0.3.1 and how does this sync up with instances refreshed on 9.0.2.2. tia.