Failure to Add Rowset

[Hashiba14]

Fisrt off, I was given this report to see why its not working and I can't figure it out. Hopefully you guys can shed a little bit of light on it for me.

I am using Crystal 10 and when I try to run this report, I get the following error:

Failed to open a rowset.
Details: ADO Error Code: 0x80004005
Source: Rowset
Description: An error message was returned from DME. The message is Invalid number of columns in output.

|109|-214767259|80004005|Rowset|dmecoldvr.cpp|1204|-1|-1|-1||
Native Error:109

Here is the sql code for the report:

dmeROD=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

Is there anything you guys can see that would enable me to run this report.

Thanks

 

[synapsevampire]

Please post your database type and it's version.

ADO is a form of connectivity, not a database.

Where did you pull this SQL from?

Try doing a Database->Verify Database.

-k

 

[Hashiba14]

The information is coming from a SQL Server.
The sql code was pulled when I went to Database->Show SQL Code.

When I try doing a verify database, I get the same error.

 

[Hashiba14]

Can anyone help me with this?

 

[Madawc]

Do a one-for-one check for the field definitions and the use you make of them. That's probably the meaning of

Invalid number of columns

I'm not an SQL expert, but I remember getting something like that when I had left something out.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Gesrix]

What Data Access Provider did you use, ODBC or OLEDB?

Are you reporting from a Lawson Application database? If so, you can try upgrading your OLEDB version to at least 4.0.7. Let me know if that helps.