There ia a current report in crystal 10 that was made by the Lawson Query Builder that is not currently working. I was told that it worked at one time, but it doesn't now. I tried re-creating the report, but got the same error. I know that lawson uses the OLE driver for data checking, so using ODBC is out of the question.
Here is the sql code: dme:PROD=WEBUSER.PRODLINE&FILE=POLINE&FIELD=PO-NUMBER;PO-RELEASE;PO-CODE;ITEM;ITEM-DESC-1;EBUY-UOM-MULT;ENT-BUY-UOM;ENT-UNIT-CST;EXTENDED-AMT;MMDIST.ACCOUNT;MMDIST.ACCT-UNIT;MMDIST.SUB-ACCT;RQSRC-MACHINE;RQSRC-MACHINE,xlt;QUANTITY;PURCHORDER.PO-DATE&SELECT=PURCHORDER.PO-DATE%3E12%2f31%2f05%26MMDIST.ACCT-UNIT%3D92000
Here is the error I get: Failed to open a rowset
Failed to open a rowset Details: ADO Error Code: 0x80004005 Source: Rowset Description: An error message was returned from DME. The m essage is Invalid number of columns in output.
SQL Server is even easier, I was just using Oracle as as example since that is what most of the Lawson implementations that I haev worked with are using. You will need to know the SQL Server name, the actual database name on that server, and then a valid user name and password for the database. Once you have that, you can navigate down to Create New Connection in the Database Expert, go to OLEDB, then New Connection. Pick the Microsoft OLEDB Driver for SQL Server ( I think that is the name, but if not, it should be very similar), and then provide the values when prompted.