Prev
Next
Forums Integration / Customization S3 Customization/Development

Lawson Report

 6 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
ARaja
Advanced Member
Posts: 26
Advanced Member
12/15/2008 7:28 AM
    Recently i developed a Lawson custom report. The report doesn't have any key parameters. Simply it has years and the periods as it's parameter, so the report runs for longer time.
    Anybody has a suggestion on how to reduce the report processing time?



    Thanks in Advance,
    Raja
    Sam Simpson
    Veteran Member
    Posts: 239
    Veteran Member
    12/16/2008 2:30 PM
      What kind of report? Crystal, 4GL etc. What tables are you using?
      ARaja
      Advanced Member
      Posts: 26
      Advanced Member
      12/17/2008 4:43 AM

        It's a 4GL custom report and the table i'm using is GLTRANS

        k-rock
        Veteran Member
        Posts: 142
        Veteran Member
        12/17/2008 11:51 AM
          Go to the ERD section of this site (link at the top) and select General Ledger. You will see GLTRANS. All of the fields in bold are part of the key index for that table. The more of those you specify, the faster the report will run.

          What else is the report doing? I used to run reports against GLTRANS in Access. I could run a report for a full year of history with no limits, pulling all fields in under 15 minutes. How long exactly is the report running? How many records are in GLTRANS? How many records does your report include? What does your report display?
          ARaja
          Advanced Member
          Posts: 26
          Advanced Member
          12/18/2008 12:13 PM
            I'm able to run the report in 5 min.....
            k-rock
            Veteran Member
            Posts: 142
            Veteran Member
            12/18/2008 3:42 PM
              I wouldn't put 5 minutes in the "long time" category. There are canned lawson reports that take 15 minutes in GL and 24 hours in HR. If you want to improve a report start with an HR Turnover report.
              ARaja
              Advanced Member
              Posts: 26
              Advanced Member
              12/22/2008 4:31 AM
                Initially it ran for around 40 minutes. By using filter API's, the report process time reduces.

                Thank u for all ur suggestions