Lawson Add-Ins query for RW100 report

 10 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
srikanth
Advanced Member Send Private Message
Posts: 28
Advanced Member

Hello all,

I m new to Lawson Add-Ins..

Any body have an idea on Lawson Add-Ins query for RW100 report?

 

I mean generating  the reports of RW100 using Add-Ins..

 

Thanks in Advance..

 

Srikanth

Norm
Veteran Member Send Private Message
Posts: 40
Veteran Member

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.

k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
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.
John Henley
Send Private Message
Posts: 3351
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.
Thanks for using the LawsonGuru.com forums!
John
mcl
Advanced Member Send Private Message
Posts: 29
Advanced Member
John, or anyone, what is the connection string to open the Lawson OLE DB connect in  .Net C# program?
John Henley
Send Private Message
Posts: 3351
"Provider=Lawson.LawOLEDBC;Password=XXX;User ID=XXX;Data Source=servername:port;Persist Security Info=True"
Thanks for using the LawsonGuru.com forums!
John
mcl
Advanced Member Send Private Message
Posts: 29
Advanced Member
Thanks much.  I had tried many combinations, but not that one.
mcl
Advanced Member Send Private Message
Posts: 29
Advanced Member
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?
John Henley
Send Private Message
Posts: 3351
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...
Thanks for using the LawsonGuru.com forums!
John
helen
New Member Send Private Message
Posts: 1
New Member

Hello,

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

 

Thanks,

Helen

vinay
New Member Send Private Message
Posts: 1
New Member
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