Lawson Reporting

Posted on 2007-10-12
Last Modified: 2008-01-09
I am new to using lawson. I work at a hospital and there are users that currently use the web portal version and the lawon client desktop ver
There is a report that is accessed in the web portal, but my bosses would like for me to write it in crystal.
I have no idea where to look for the tables and how they may be linked or indexed. I was reading the forums on and they mentioned a utility called dbdoc, but I can not figure out how to use it find all the tables I need. Can someone shed some light for me.

Thank you
Question by:metalteck
    LVL 11

    Expert Comment

    you say a web portal? Then is the url pointing to a web server in your network or out on the internet? If out on the internet then you have the wrong type of app to use crystal to get at the data. If on your intranet then go to that server and look for a SQL or MySQL or flatfile db or oracle or SIR or other database files. Then you just need a login to connect your crystal;
    LVL 28

    Accepted Solution


    Search the lawson support site for the Data files.  There is a data file for each lawson module.
    If you want the data file for HR, then the data file is named HRDATA, for Purchasing, it is called PODATA.
    There will be one out there for each of the different builds and then for UNIX/Windows or for ISeries.  So, if you know your version and platform you can find these easily enough.
    The docs will be pdf's, and they contain the same info as dbdoc.  DBDOC can be accessed through LID(client desktop), and your Lawson admin should be able to help you find it.  I prefer the pdf's off the support site as they are much easier to search, naviagte, and don't require you to log into Lawson to access.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    How to increase the row limit in Jasper Server.
    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
    This video shows how use content aware, what it’s used for, and when to use it over other tools.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now