Lawson Add-Ins query for RW100 report

Sort:
You are not authorized to post a reply.
Author
Messages


srikanth











Advanced Member



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



    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



      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











        Senior Member



        Posts: 3348




        Senior Member



          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



          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











            Senior Member



            Posts: 3348




            Senior Member



              "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



              Posts: 29




              Advanced Member



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


                mcl











                Advanced Member



                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











                  Senior Member



                  Posts: 3348




                  Senior Member



                    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



                    Posts: 1




                    New Member



                      Hello,

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

                       

                      Thanks,

                      Helen



                      vinay











                      New Member



                      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
                        You are not authorized to post a reply.