Creating a report from MS Access

Author
Messages


Bridgette











New Member



Posts: 3




New Member



    Hi

    I am new to using Lawson and have not been trained on the software. I am used to using Peoplesoft. I have access to the back tables to run queries in MS Access.

    That ebing said,  I was told by Lawson support that there is not a report that will produce this report.  The report need to include a breakdown of the unemployment report breaking it down by worksite location which is the location code located on the HR11 Assignment tab.

    The report need to reflect by company, by location the employee count by the 12 (that untilemately equal to the over 3 month employee count thats on the unemployment report. and the taxable wages it reflect.

    The information is similar to the PR291 detail but it need to include the location address to put on the form.

    Does anyone know if there is an MS Access template I should use or the tables that i can you to get this result.

    I am not a Lawson Guru so if you know what i can do please explain in lame terms.

    Thanks for your responding to my post.


    Carolyn Lee











    Veteran Member



    Posts: 53




    Veteran Member



      hi, i'd begin by going to the data dictionary to find out what the pr291 references (tech-> data dictionary-> forms) or download off lawson. looks like you'll need to link a few tables to get what you need. the work locat code is in PAEMPLOYEE so link that too. but i think it'll be easier to build via crystal than access.


      Phil Simon











      Veteran Member



      Posts: 135




      Veteran Member



        This one sounds straightforward in either application.  Don't forget the Add-ins/control-shift-o trick to figure out tables and fields if you're new. 

        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
        ---