Lawson Add-Ins query for RW100 report

Add-Ins queries can be run against Lawson Tables or against Lawson Online Forms, but I'm not aware of  any capability to query against batch programs or the reports they generate.

Maybe I'm not understanding the question.

You would have to build the table connections and the aggregations within the excel file. If you are new to Lawson, this probably is not something that you will be able to do quickly.

Norm's answer is correct. Add-Ins queries can be run against Lawson Tables or against Lawson Online Forms, but not reports. The Lawson OLEDB provider does, however, have that capability.

John, or anyone, what is the connection string to open the Lawson OLE DB connect in  .Net C# program?

"Provider=Lawson.LawOLEDBC;Password=XXX;User ID=XXX;Data Source=servername:port;Persist Security Info=True"

Thanks much.  I had tried many combinations, but not that one.

Quite a difference in access speed with the Lawson.LawOLEDBC versus ODBC.. WOW! One more question: I can use a "Select Top 100" in the sql statement in ODBC but get an error with the LawOLEDBC. Is there an equivalent for the oledbc?

There is not a "TOP" option, although depending on your requirements, you can limit the number of rows returned by the query wizard.
And depending on your indexes/criteria, that might work for what you're looking for...

Hello,

Do you get any solutions? I have the same question.

 

Thanks,

Helen

Unable to establish a Lawson database connection using ADODB.connection().Open() method. Getting an error while opening the connection System.Runtime.InteropServices.COMException (0x80004005): Unspecified error