PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/05/2016 8:49 AM by  vinay
Lawson Add-Ins query for RW100 report
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
srikanth
Private
Private
Advanced Member
(56 points)
Advanced Member
Posts:28


Send Message:

--
01/12/2009 7:35 AM

    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
    Private
    Private
    Veteran Member
    (120 points)
    Veteran Member
    Posts:40


    Send Message:

    --
    01/12/2009 12:11 PM

    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
    Private
    Private
    Veteran Member
    (416 points)
    Veteran Member
    Posts:142


    Send Message:

    --
    01/13/2009 9:52 AM
    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
    Private
    Private
    Senior Member
    (9617 points)
    Senior Member
    Posts:3223


    Send Message:

    --
    01/13/2009 10:23 AM
    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
    Private
    Private
    Advanced Member
    (67 points)
    Advanced Member
    Posts:29


    Send Message:

    --
    02/02/2009 10:14 AM
    John, or anyone, what is the connection string to open the Lawson OLE DB connect in  .Net C# program?
    John Henley
    Private
    Private
    Senior Member
    (9617 points)
    Senior Member
    Posts:3223


    Send Message:

    --
    02/02/2009 1:37 PM
    "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
    Private
    Private
    Advanced Member
    (67 points)
    Advanced Member
    Posts:29


    Send Message:

    --
    02/03/2009 9:05 AM
    Thanks much.  I had tried many combinations, but not that one.
    mcl
    Private
    Private
    Advanced Member
    (67 points)
    Advanced Member
    Posts:29


    Send Message:

    --
    02/04/2009 11:48 AM
    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
    Private
    Private
    Senior Member
    (9617 points)
    Senior Member
    Posts:3223


    Send Message:

    --
    02/04/2009 1:33 PM
    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
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    01/23/2010 5:12 PM

    Hello,

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

     

    Thanks,

    Helen

    vinay
    Software Engineer
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/05/2016 8:49 AM
    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
    You are not authorized to post a reply.