I'm able to generate reports in Crystal using the Lawson Connector (not by choice, but it's the way the client wants me to connect). Couple of issues: 1. When I first run the report I am prompted that the table isn't recognized and I have to respond 'No' to 'do you want to remove the table from the report'. However, the report runs successfully. Why is it that Crystal doesn't think it's a valid table 2. When I view the SQL (Database/Show SQL Query) I get just a list of the tables w...

We are Lawson 8.03, Oracle. Recently we applied CTP 45859, and program PA702 - Updates Next Review dates, and Scheduled dates. However, I have a lot of 01/01/1700 dates showing up in the Next Review, and Last Review date fields. Obviously this impacts the several Joint Commision reports that I have, so I am wondering is ther a way in Crystal that I can get the best sequenced record fromt hat REVIEW table Ex: Employee 359323 has 3 records on the table. First one is blank on N...

I need to write a report against the security tables, but I can't seem to find the names/locations of the security tables. I am very new to Lawson (and Crystal), so I hope that this isn't a stupid question. Specifically, I need to compare security class against the employee's RD30 record, which I've found on DBLOWUR. We're running an I-Series/AS400 on the back-end if that makes any difference. Thanks in advance for your help.

I know there was no repository in LRS1.3 is there one in the 9.0 version. We want to have a central place to store formulas, logos etc. I know it exists in Crystal Enterprise but is there such a thing in the new LBI/LRS 9.0 or are the still only using RAS Thanks Kate Liamero kliameroedisonschools.com

Is there a way to control access to reports I create. People use them and throw off my formatting. I would also like to limit access to certain acct groups. Thanks Nigel

We have crystal reports designed using data direct ODBC driver to oracle database 10G. The datasource that we are using to design the reports are also setup on our LBI/LRS servers exactly the same way. We have PROD TEST and DEV environments. PROD and TEST are remote installs with the db, apps and lbi/lrs residing on 3 different servers. DEV is all on one box. DB and APP boxes are Unix/Sun. LBI/LRS Windows Version 9 for everything. We are saving the login information with the ...

Crystal XI using Oracle ODBC driver. When I create a new ODBC connection to a Lawson environment and I select a data area within that environment, only the tables that start from AC to MM (including all the L_) show up. Anything past MM does not. If I use the same ODBC connection and use Access instead of Crystal, I can see all the tables beyond those that start with MM. Has anyone else had this issue

Lawson 8.03 I wrote a report using PATRNHIST, EMPLOYEE to capture the Employee Training/Course history. There are a few Mandatory Courses that encompass several Course Numbers - For example: BLS Course is select {PATRNHIST.COURSE} case '2C00000001': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') Case '2C00000002': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') case'2C00000003': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/y...

I installed Framework Services 1.2 and the install validator passes all tests with flying colors. Next, I installed Reporting Services, ran the install validation process and again, every passes with flying colors. I've Registered Reporting Services/Framework Services, and again, no problems. I can publish any type of report that I want and during the publication process, the report loads and displays just fine. The problem that I am experiencing is that when I mount a published report on a dash...

We are currently using version 8.0.3 Applications, 8.0.29 Environment and Crystal Enterprise 8.5. We will be upgrading soon and I am trying to find out if anyone knows what versons of Crystal are compatible with the Lawson 8.0.3 Environment. We will be moving to the Lawson 8.0.3 environment later this summer, with a move to 9.0.0 sometime next year. So that is two Environment upgrades and I am only looking to make one upgrade of Crystal to the highest version available that is compatible with...

I really enjoyed the series on reporting. Let me make sure that I understand XI's limitations with Lawson's OLEDB connector. While you get the benefit of security, you have the disadvantage of reporting on only 'Lawson-approved' relationships). As a result, more complex reports aren't possible without some creativity. You wrote about the benefits of doing Crystal Reports based on SQL queries. For this to work through Crystal Enterprise for light users (i.e., not hard core developers on t...

I use ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI

Hello I seem to recall that you can point previously-created .dme's to different product lines so you don't have to recreate them. Any idea about how to do this Also, I also vaguely recall that you can create a .dme and use that as the basis for a Crystal report. We're running Crystal XI off of LSF on SQL Server 2005. For some reason, I thought that you could cut and paste it but can't for the life of me remember how to do that. Thanks.

Hello Can anyone provide experiences with publishing (in LBI) using ODBC vs. OLEDB I am finding that I'm getting some different results based on the type of conenction used in CRXI developing the report. Part of me thinks that this shouldn't matter but I've seen some discrepancies even in CR using ODBC vs. OLEB. Is LBI agnostic or pro-OLEDB Thanks. ps

Hello I was wondering if anyone cared to share his/her thoughts on using Query Builder vs. Views. I know that QB has the built-in Lawson security but am wondering if reporting performance will suffer as more than a handful of tables are added for Crystal Reports (deployed via LBI). In some cases, the way that the data is stored in different tables (PRSAGDTL, for example) isn't ideal for the way that 'normal' end-users look at it. Using SQL server to create a view in the dB wouldn't by ...

We would like to know how much is involved in implementing the LBI module. We would do this minus the process flow for starters. Can anyone offer insight on the complexity involved Did you utilize outside consultants or Lawson for the implementation

Hello All It doesn't appear that Lawson will let you do this easily. I have a CRXI rpt via an OLEDB command in Query Builder linked to a TEST product line. I want to switch it to an ODBC connection to a different product line, obviously without the command. Changing the data source in CR doesn't seem to let me do this. It's not a big deal but I'm curious to see if any of you have been able to figure that one out. Thanks.

Hello I saw the KB article on Crystal Parameters called: Passing parameters from Crystal to OLE DB Object Services Description: How do I pass a Crystal Parameter to an OLE DB Object Services DME query **** A few things here: Note: Date fields and certain conditional fields cannot be used. *** I was able to add a date prompt and it worked like a charm. Is this simply a matter of Lawson's documentation not being updated ...

Hello I was wondering if anyone figured out how to do this. I have a parameter at the command level for PRTIME that will limit the records pulled, since that table gets to be big. TR-DATE = To compare paychecks, I have another command set to PRTIME with the same parameters: TR-DATE = Ideally, someone can put in parameter 1 = 7/1/07 and parameter s 7/15/07 so you can compare both paychecks. However, OLEDB's command builder isn't liking adding the...

Hello CRXI OLEDB 9.0.3 I doubt that the answer is 'yes', but can you create views in SQL Server 2005 and link them on the same report to OLEDB commands If you do this, then are there any visibility issues with the data Thanks. ps

Report Bursting..... I have a bunch of Crystal Reports that I wanted to be able to group by manager and send automatically (by email) to 200 different managers. However, I have always needed to print the report and interoffice mail it. I found a tool called PDF-eXplode that allows me put a simple tag in the header and it will send the report to the managers by email... all from one report I have done a couple simple tests and they worked - tomorrow I am sending my first produc...

Hello.. I need help. I am having problem creating sql expression). When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. Also when I use sql command to pull all the data that I need, the report runs very..very..very slow…. Please help… Thanks Error in compiling SQL Expression: Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'select'.[Database...

Thanks in advance... I have a manually written query I'm testing to join 3 name fields into one field. Here's what I have which needs to output in a format like 'Doe, John M.': SELECT EMPLOYEE.EMPLOYEE, ([EMPLOYEE.LAST_NAME] & ', ' & [EMPLOYEE.FIRST_NAME] & [EMPLOYEE.MIDDLE_INIT] &'.') AS FULLNAME, FROM EMPLOYEE I get an Oracle 936 'missing operation' message. Any clues

Thanks in advance... I have this query below, which was working fine till I added 'DEPTCODE.DEPARTMENT, DEPTCODE.NAME' and included 'DEPTCODE' in the FROM clause... this was to pick up the department name associated with the employee... I'm guessing I need an additional JOIN clause (nested) SELECT EMPLOYEE.EMPLOYEE, EMPLOYEE.LAST_NAME, EMPLOYEE.DEPARTMENT, EMPLOYEE.POSITION, EMPLOYEE.FIRST_NAME, DEPTCODE.DEPARTMENT, DEPTCODE.NAME, PAYDEDUCTN.EMPLOYEE, PAYDEDUCTN.CHECK_ID, PAYDEDUCTN.WAGE...

Does anyone have a recommendation for the setup of the Repository Database used with LBI. Our Lawson databases exist on a remote Sun Solaris box seperate from the Lawson application box. Do we have to use Oracle as our repository database Does it have to be on the same box as the Lawson database Or, could we use SQL Server as the repository database and the OLAP Analysis and place it on the LBI box