I was wondering if I can get some expertise and opinion regarding using Crystal Reports. I would like to move away from creating reports using COBOL for obvious reasons. (Our company utilizes crystal reports in other departments and have been told we do have a crystal reports repository.) I have not used crystal reports myself so I am only familiar with what I have seen at CUE this year and I am excited to move forward. I am the programmer analyst for our purchasing department. I have brought u...

Can you go back and update an instance for the period that an adjustment was made in.    Our users had to go back to june and july periods and make adjustments.  Now they want  the June instance and the July instance to reflect the changes in the Crystal reports.  These reports are created  from the tables  through  Crystal and we scheduled them to run when the period is closed on LBI.    These reports are not  OnDemand.

Hello, I am working with a client who we recently migrated and also upgraded from lsf8 to lsf9.  They are running Enterprise CMC version 11.5.10.1263 connecting via OLE DB version 9.0.4.  We are getting lots of cases stating that some of their bigger reports have come to a crawl since upgrading to lsf9.  These reports are running 10-12 hours in some cases and timing out.  They tried increasing 'Connect Timeout' just to see if it will finish, but no luck.  I noticed in the DME call the reports...

Hi and thanks for your help, I am trying to pull information from the Lawson database that will give me a departmental expense report exactly like MM280.  I am using Crystal reports to turn the information into a series of nice looking graphs.  I have to use the accounting-unit to group my data. Unfortunately, I cannot make my data pull equal what MM280 shows.  My management is not too pleased about this I am currently pulling using two tables: the POLINE table (using PURCHORDER.PODATE as the...

Absolute will be hosting an LBI Roundtable Webinar tomorrow (Thursday, Oct 22, 2009 1:00 PM - 3:00 PM CDT). Click here to register

Hi - Not sure this is the correct subforum, but I was wondering if someone could help with a question regarding the options in running and incremental data load in IA150. The options are: Build Cube: Y/N Process Cube: Y/N Fact Table Options: C/I/N (obviously I here) Create All Dimensions: Y/N We've run a complete load with all setting set to Y. We ran an incremental load after entering some changes in Lawson with all options set to Y and Fact Table set to I (Incremental). Problem is alot ...

ado error code 0x80004005 cannot open database requested I have a Crystal report that uses a SQL Server stored procedure as the data source. We have modified the stored proc at times, I've changed the data source on the report and sent it for republishing. Somehow, last week, this all changed and I can no longer change the data source on the report. We checked and I do have EXEC permissions but I still get the error. I have uninstalled and reinstalled Crystal. We are on 8.1 (upgrade not complet...

We were wondering if anyone has integrated Lawson data with a data warehouse and would appreciate any information on how you did it, how it went, what you wish you'd known beforehand, vendors (good or bad), etc. Thank you in advance!

Greetings,   Basics:  Using OLE DB and accessing Lawson tables for a Crystal Report.  Windows, Lawson 9, CR2008 SP2.  From within CR I open the database expert, add command, alias the tables I need, pick the fields...then go on to the next table.  Total joins=4 on 5 tables, all left outer joins with ACTRANS as the 'master'. I'm trying to pull information for budget details based on activities and need to join ACBUDDTL and ACTRANS...and I need all activities from both tables, so need a full ou...

We are upgrading our lawson system on a new lpar.  I need to update all of my reports, smartnotes and links to the new lpar/database. Does anyone have any tips or tricks on the easiest way to accomplish this task

Issue:I need to produce a BL Invoice from Crystal Reports (CR) AND include BL comments to help explain the reason for the invoice to our customers. Using the OLE DB connector within Crystal Reports (CR) 2008, I can pull up the table info with a DME Query, and separately, I can pull up one associated BL Invoice attachment with a getattachrec Query, but I can't seem to put the two together on one report.  Anyone done this before BL recurring invoice comments are stored in (BL30.1 -> BL32....

I'm trying to open an LBI Crystal Report by launching a URL within Design Studio. I thought I understood how to pass the parameters within this URL but I can't get it to work. This is what I used: /efs/FSRemotefsid=RS:RS-ERS:186&POCODE=code&PONUMBER=10&PORELEASE=0 The correct report opens but the parameters aren't being accepted.

Has anybody been able to create the PA100 report straight from the Lawson tables. Our HR dept runs the PA100 everyday to update personnel actions. The PR dept needs this report but in a different format and sorted not by employee but in a different way. The problem in creating this report is changes to an employees record is stored as current on HR11 or the employee table and the previous value is tored in the HR history table. For every personnel action which may be about 70-100 changes each p...

Hola! I'm trying to set up an InfoSet to drive a SmartNote, but the query I'm starting with is based on a SQL 2000 stored procedure (in McKesson MM, actually) that uses a slew of temp tables and IF/logic - and all of that is confusing the InfoSet wizard. When I try and auto-create the InfoSet, I get this error: ADMINUI1010: ... The statement did not return a result set The query runs fine in Toad or Query Analyzer; so obviously rows *are* coming back... just not in a way that the InfoSet Wiz...

Can anyone tell me what 'set to null' on the parameter screen is or does We run Crystal reports from Lawson's dashboard and this 'appears' to serve no purpose and is distracting but I haven't been able to find it any of our books or in my research. I would like to remove it. Any help would be greatly appreciated!!

We are looking to upgrade to LBI 9.0.4 and lookin at the multiple instances of RAS on the same server install. Has anyone implemented this. If so can you find performance, response and throughput increases tia, Ruma.

Our LBI server has windows 2003 as the os. We are looking to upgrade from LBI 903 to LBI 904. At the same time we are looking to upgrade to windows 2008 from windows 2003. Has anybody have this configuration. Any experiences you can share

When I attempt to log in the server using OLE DB to create a report, I get and ADO error: 0x80072ee7 Does anybody know how to work around this issue

We have two reports that are currently set up as a main report (listing employees) and a subreport (a form with detailed information for a specific employee) that is linked on the EMPLOYEE.EMPLOYEE field.  The issue is that while the main report needs to be in Landscape, the subreport form needs to be Portrait.  Apparently Crystal can't handle having the two reports in different orientations. I am trying to instead have them as two separate reports, linked together via the EMPLOYEE.EMPLOYEE fie...

Is it possible to add parameters to a Lawson Back Office Report using LBI I noticed I wasn't able to see 'Add a Parameter' when I published my report in .lxr format Thanks

I have been asked about this a few times recently and wanted to share what we did to make user fields easier in Crystal Reports:   If course, the field_name field should be your field names...  We added the following as a database view: SELECT     COMPANY, EMPLOYEE,                           (SELECT     ufv.A_FIELD AS FIELD_VALUE                             FROM          dbo.HREMPUSF AS ufv INNER JOIN                                                    dbo.HRUSERFLDS AS ufn ON ufv.FIELD_KEY ...

I need help. I have never used Crystal before and I need to create service awards report. We currently have one in place, but the last time I ran it, it gave me incorrect data. So...I thought I would create one myself...I don't know how.  I have managed to learn the basics but nothing else afterwards.Service awards are for the 1st quarter of 2010 for service years as follows:  5 years, 10, 15, 20, 25, 30, 35, 40, 45, and 50 years of service. How do I go about doing this I have been reading, b...

I am new at being an app. admin for LBI. Currently, we have our timeout set at 30 mins, but my concern is that information can be left on the screen and doesn't actually go back to the log in screen after the timeout. What needs to be done to have LBI timeout and send the screen back to the log in screen so no information is left on the screen

Hello.  Has anyone been able to apply a check box feature, to left of an item, on the module list within a Dashboard  So as the user goes through the list of modules in the Dashboard, a check box can be checked off indicating that one has been done, etc.  Thank you, any guidance is greatly appreciated.

Does anyone have the proper joins in Crystal for linking the APVENMAST and the APHOLDCODE  I have attempted multiple scenarios and nothing seems to be working.  Thank you.