Lawson Report - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

ARaja

Advanced Member

Posts: 26

New Poster

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

12/16/2008 2:30 PM

What kind of report? Crystal, 4GL etc. What tables are you using?

ARaja

Advanced Member

Posts: 26

New Poster

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

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

New Poster

12/18/2008 12:13 PM

I'm able to run the report in 5 min.....

k-rock

Veteran Member

Posts: 142

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

New Poster

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