Is anybody aware of Data File Text-like documentation for PLM tables

Does anyone use LBI as their enterprise reporting repository I know Lawson sells it this way but does anyone use it for Cerner, McKesson or EPIC reporting as well Thanks

I am using smart notifications to query LDAP and am able to get data. However I need certain fields in a container and I am not able to write the right syntax to query LDAP to get data for only certain fields. Has anyone able to get this to work and can share the exact syntax for those queries. I believe there are also certain oracle commands to query LDAP but I cannot get any to work and I am sure that the syntax is not right. Has anyone got this to work and willing to share the queries as w...

Hello, I need to write a Crystal report that is similar to the AP265 but with some adjustments. I was wondering where you could find the SQL behind the existing Lawson report to use as my begining point. Is this how you would start Thank you, Wade

have a report which runs in crystal i run the report, it prompts for my stored proc parameters when it gets to the parameters that are in the report which are dynamic i get this error com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Missing parameter values.---- Error code:-2147217394 Error code name:missingParameterValueError

I am a crystal advanced user(using since 1987 every version) i have an issue with 2008 and the parameters it appears that i have to use dynamic paramters, but concerned there will be rpt maintennace when not useing a lookup table to retrieve the values(datasets are sql stored procedures) i would like to be able to use a static parameter where i can use and ALL option or the user can enter a value or multiple with the dynamic parameters i can only use what is from the database values an...

Has anybody encountered an issue where smart notes content on the email is coming out with only the word 'PROD' in it

I used a RW100 report i created and moved it over to crystal. However, i'm missing 2 lines that are on my RW report so my numbers don't tie out. If i go to the specific data field and browse the data, i can see the data i'm missing. I've tried going to the select expert to specify that data but nothing comes up. Did i do somethign wrong or is something switched to prevent that data from showing

Does anyone know of any way to lock down Crystal Security so that the end user can only see the departments they have access to in Lawson Or a way to give the end user view only access within Crystal Then we could write the reports with the limits behind the scenes and have them refresh them only. Thanks!!!

I need to create a report in crystal that will read a file with many invoices in it. I then need to create a report for each invoice, that will be it's own file. For example, read 20 invoice. Create 20 files with 1 invoice each. Thanks...

I have been working with LBI for the past year and a half developing and mainting HR specific reports. We are looking to expand into supply chain. I am completely new to supply chain, so I do not know the data structure or the key metrics related to this division. I was hoping I can find some help here. Maybe see some example reports related to materials management, purchasing, buyers, inventory, etc. Any help is greatly appreciated.

Hi All We have a set of Excel files refreshed every week by a job. I would like to place a link to those file in the Dashboard. Is this possible or does the LBI dashboard only allow either a 'web address' link or a published Crystal Report This is on LSf9.0.0.4 on Windows 2003 with SQL2005 backend Thanks Saurabh

Hi All, I am newbie to LBI, as we faced ERROR500 while brusting reports with details option, we advised for FSupdate to 9.0.3.1.151 and RS 9.0.3.1.156. But after updates the LBI install validator itself not working'page cannot find' error, and LBI application also the same error, but In WAS, FS,SN,RS every thing working fine, can any one help me where to look Regs, Chitta

I am building a report that shows current pay rates, effective date, reason for the change, as well as the previous rate. I have everything except the previous rate working, and I keep hitting the wall. My logic has been to use a nthLargest=2 on the PRRATEHIST.BEG_DATE field. To pull the previous pay rate I then use the formula: if {PRRATEHIST.BEG_DATE} = NthLargest (2, {PRRATEHIST.BEG_DATE}, {EMPLOYEE.EMPLOYEE}) then {Pay Rate} Even though the {NthLargest (2, {PRRATEHI...

Our company is very new to Lawson (9.0.1.5..still currently not live), and I've been looking at Crystal Reports 2008 through LBI. Most of our reports need to be filtered based off what facility the current user is a part of. How do I go about pulling user's Facility Group and pass it as a parameter Or, I suppose I should as a more general question of how do I pull a user's 'anything' to pass as a parameter

We are trying to create a Crystal report to create more meaningful invoices to our locations. The GL120/121 does not give enough details. I want to be able to somehow tie back to the PO line Descriptions. I am not sure if these are the correct files, but I see the information I need on ACHISTDTL for hte BR side and I have linked the PURCHORDER, POLINE & MMDIST tables to get what I need on that side. I am looking for the bridge to get me from one to the other. Has anyone created a report to ...

I have been asked to add a link to a Crystal report that will open up the image from Webnow.  The link would need to use informaion from the line of the report that you want to see the image for.  Has anyone done this or know where I can find information on how to do it.  I don't even know where to begin, so any help on where to find out the 'how to' would be greatly appreciated. Thanks

I am trying to create a report for all employees for their PTO hours, sick leave etc but for a month. Since this report should show me all the pto time taken by the employee for a months and all payroll tables store hours by pay period end date I would like to find out if anybody has created anything like this. This would mean that the pay period end date may fall on the first of the next month but have hours that belonged to the last 2 weeks of the previous month. Is there a formula that i...

Hi, Can some one recommend a solution that can be used to publish crystal reports other than LBI We have third party software that needs some crystal report development and these users should not be a Lawson user. We need to publish the reports to some kind of dashboard for the users to generate the reports. Any ideas and suggestions most appreciated. Thanks, Thomas.

how can I get the maximum check date while creating a query in Lawson Query Builder, where I have informations about employee, employee status, process level, company and paymastr only. Please help.

I am creating a smart notification which works like a parent-child but both parent and child are derived from 2 different infosets instead of the same. The parent notification is delivered and the child is not delivered as the case would be. I am trying to schedule both the parent and child infosets to update and wondering whether they should be scheduled at the same time or whether the child before the parent. The logic for this is if the parent and child infosets update on the same ...

I am working on a report and looking to pull in the comments added from the PO20 screen. Originally I thought that they would be stored in either L_HPCR or L_DPCR but that turned out not to be the case. I am hoping that someone can point me to the table these comments are stored in.

I have an id field in which the same id may exist multiple times for an employee. I have another field whose values are true or false. How can I count the number of true/falses for each unique id

Hi, I am planing to upgrade our Lawson LSF 9.0.1.2 to 9.0.1.5, being the part of it, i have to upgrade LBI as well, but i have no idea where to download DSSO 9.0.1.5, i cannot found in Products download page in LGS. can any one please provide me the steps and for upgrade DSSO

How can I get the max value of check-date in lawson 9 with crystal reports9. I created a report how ever it is not showing the correct value. Please help. The condition I need is the max( check-date)