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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 26
Advanced Member
12/18/2008 12:13 PM
I'm able to run the report in 5 min.....
k-rock
Veteran Member Send Private Message
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 Send Private Message
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