[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

Lawson Reporting

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 support.lawson.com 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
1 Solution
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;

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now