Okay so I have this query pulled together, but am wondering about the results.  Can someone look over the joins in the query and tell me if I have them correct  SELECT     .GLTRANS.COMPANY, .GLTRANS.ACCT_UNIT, .GLTRANS.ACCOUNT, .GLTRANS.SUB_ACCOUNT,                       .GLTRANS.CURRENCY_CODE, .GLTRANS.TRAN_AMOUNT, .GLTRANS.BASE_AMOUNT, .GLTRANS.POSTING_DATE,                       .GLTRANS.FISCAL_YEAR, .GLTRANS.ACCT_PERIOD, .GLTRANS.UPDATE_DATE, .GLTRANS.OBJ_ID,                      ...

Does any one know of a small Lawson table that contains valid SUB-ACCT values I'm creating a Crystal Labor Utilization Report to be published into LBI.  In my Crystal sql, I'm trying to find a smaller Lawson table where I can query for a list of valid Sub Accounts.  I have to categorize these sub accounts using logic I'll include in the sql.  I could query PRDISTRIB for a unique list DST-SUB-ACCTs but that table is very large.

I recently installed the LBI in my Windows 2003 Server. The server box is physically the same as the Lawson LSF/WebSphere. In other words, LSF 9.0.6, WebSphere 6.0.2.17, and LBI EFS 9.0.1.10.154 are all on the same server. DSSO is not installed because they are all in the same server. The LBI/EFS login without any problem if I specified File-based Authentication in the System Configuration Assistant. But when I changed to Lawson Single Sign-On and enter SSOP for the Server Name, the login will ...

Hi I’m working on an LBI/Crystal report where two of the tables are smaller Excel files (each less than 1,000 lines). I can develop the report in Crystal okay, but once I publish the report onto the LBI server, the report won’t be able to find the network location where the spreadsheets are. Due to limited I.T. resources, I can’t have them create these tables in the database for me. Also, there are issues with having the LBI server map to the network drive where the spreadsheets exist, meaning ...

HI, What is the best way to get Invoice Date added to a report with GLTrans  I have looked at APInvoice and HCHISTDTL with ACHISTHDR. They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period. I am pretty new to this stuff. Thanks!

We have a bunch of RW reports that are data sources for Crystal.  Crystal is then used to write reports such as balance sheet; income statement etc with the RW as the data source.  Modifications are a huge problem and I am proposing that we rewrite the reports in Crystal going directly to LAWSON data specifically the GLAMOUNTS, GLUNITS and FBDETAIL tables.  Most likely to have a view.  However I have noticed that there a bunch of RW data tables in LAWSON such as RWGRPDET and RWROWDET etc.  Could...

I need a report that has current balance (balance sheet accounts) and current year prior quarter balances. I cannot find a data dictionary item for the curr yr prior qtr balances.

Is there a way to make this statement exclude the time SI_STARTTIME I only want the date and no time on it. Thank you. Cindy

I am trying to set up a range in the index or filter options for an ole db report. The range is like (field >= 600 and field =700 and field Has anybody been able to set this up on the filter or index of a table in lawson. i have tried  the , ; & | to give me a combination but oledb is not acceptiony any of these characters. It allows the first part but not the rest. tia.

We are in the process of converting a particular report from 9022 to 9031 that uses the prdistrib table and has been written in oledb. However this report is not completing refreshing and times out after 40 minutes of refreshing. if we break this report to go against a smaller set of data it completes fine. Is anybody willing to share any pointers or tips that I can use to get this report to complete refreshing. Remember this report is written in oledb and I would like to avaoid full table sca...

Hi, We recently just upgraded to the latest LBI and Crystal 2008 (11R3). I have reports that I have fixed so that when the report is run in Crystal Designer you get the option to modify those paramaters on the left-hand side of the screen after the report has been refreshed. The question I have is how to enable this in LBI once the report has been run In theory this is possible according to a couple of co-workers who attended QUE this year and saw this functionality. Any help would be apprec...

When a Crystal Report includes a subreport how can you force the LBI bursting to carry through onton the subreport

Hi, I've got a few crystal reports that are set to open as excel files. however it seems to populate blank rows between the lines of data. I've reduced the line space between the rows in crystal as much as possible. has anyone got any ideas CR XI R2 SP4 LBI 9.0.1.8 Thanks Jon

Does anyone know if it is possible to hide the search box on the right hand side of the dashboard view of LBI We are moving from 8 to 9 and having both the portal search box and the LBI on the right hand side has become confusing. We never use the one in LBI and would be cleaner to just hide it.

I have a year-to-date labor distribution report developed in Crystal that I'm publishing to LBI.  The report is grouped by 1) cost center 2) employee 3) payroll quarter 4) payroll month When originally published, the user will see all data for all pay periods for all the cost centers the viewer has permissions to see.  I'd like the user to filter the data to just see a selected payroll quarter or a selected payroll month.  I've started playing around with parameters but have run into some i...

Hi, We are running into an interesting dilemma in that we run multiple Lawson environments (20) and multiple LBI servers to service these environments. The dilemma we have run into is that we have the same report, but that it needs to be published using different DSN's many times. Everytime the enviroment changes like right now we are going from LRS to LBI, and later from v8 to v9 of Lawson, we have to change all the DSN's etc. What I am curious of is if there is a generic driver or something ...

Is there a way I can suppress the display of Instance Name in one of my dashboard report lists  I'd like to display only Report Name and Created Date since that makes more sense to my end users.  However, I'm unable to remove or even change the position of Instance Name in the list of columns to displayed for this report list. I've checked through the Reporting Services and User Guide doc but don't see any way to suppress instance name, unless that ability is undocumented.

We are working on moving from 8.0.3 to  lsf 9.0 I have the following url on one of our dashboards and it works fine but in the 9.0 version it comes back with the error Error retrieving work units for current task launchForm2('inbasket/inbasket.htm' top.lawsonPortal.profile.getElementsByTagName('TASK')[0].getAttribute('id'))   The inbasket works fine if I click on the link in the portal menu on the left but we need the dashboard link to work because the portal menu is hidden for most users...

I'm developing a Crystal Labor Distribution report.  I've published the report in a test area and have scheduled it to run.  The report completes okay, but when I view it, I get the following error ------------------ A processing limit was reached. Error in File Year to Date Labor Distribution for PNI {A4B16443-FCE1-4671-908E-98DA0E269561}.rpt: Max processing time or Max records limit reached ------------ When I scheduled the report, I set it to cache at creation time.  I'm not sure why the ...

Hello, I've developed a labor distribution report in crystal.  It's grouped by cost center, then employee number beneath that.  When I view the Group Tree in Crystal, the employee number displays with no commas - something I tweaked in the report because it originally displayed with commas - since employee number is numeric. However, when I publish the Crystal report into LBI and view it, the employee number in the group tree shows up with the commas again.  I don't know why LBI is ignoring th...

Hello, I'm developing a Crystal report to be published into LBI.  The report pulls data from Lawson but also from a Kronos database.  I can develop the report in Crystal with both data sources just fine, but my question is - when I publish the report into LBI I currently use the 'Data Settings' tab in the LBI 'Report Settings' screen to override my report's data source.  Our LBI administrators have asked us to do this so they can maintain the data access user-id and password.  However, this ove...

Hello everyone.  I have been reading up on the Crystal Integration Pack for Enterprise Reporting for use here.  However, I can no longer locate the file at support.lawson.com.  We use Crystal XI Report editor and RAS on NT servers from Lawson 9.0.0.2 using LS9. Would any of you be able to point me to where this file is available  According the support.lawson.com, it should be at Product Download Center --> Windows under the Enterprise Performance Management ...

Has anybody accomplished one report executing another crystal report and passing a parameter . I know this can be done by adding an hyperlink to the report and passing a parameter. Can somebody share the excat sysntax after publishing both on lbi.

We are nearing the finish of implementing LBI here in a brand new Lawson setup (version 9.0 for all). We've got everything working up through creating the datacube...almost. Running IA150 will create the .csv's, upload them to the ftp site, and then stop. The installer believes that the issue is that we need to setup IIS on the sql cluster, add the msmdpump.dll, create the application pool, etc, and that should be the end of it. However, our DB and security teams are very much against the idea...

We are currently in the process of moving from 803 to 9.0 and part of that process has been to just buy a whole new server and install from scratch and convert as much as possibe. I built all of our rights management stuff manually in our current production system and want to dump it out so I can load it into the new 9.0 world. I can't seem to find instructions on how to do that just notes that say it is possible. Any suggestions would be very helpful.