Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 69
	Members: 0
	Total: 69

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

Payroll Reporting

6 Replies

0 Subscribed to this topic

69 Subscribed to this forum

Sort:

Author

Messages

David Newton

New Member

Posts: 1

1/5/2012 3:30 PM

I'll open this discussion with a simple question that has (I believe) a not-so-simple solution... Is there anyway in Lawson to run a report that shows a list of available reports with description? I find the Lawson canned reports to be lacking, but if I could just see the available reports, I might find some of the things I'm looking for!

Any help is greatly appreciated!!

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

1/5/2012 3:58 PM

Have your admin (or you if you have access to LID)... do this.
rngdbdump -cnt gen screen

Or to create a file rngdbdump -cnt gen screen > ~/filename.csv

It will give you a brief description of what each screen (and report) does.

You can then import this file into Excel, and go from there.

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

1/5/2012 4:00 PM

To get the column headers leave the n off of the switches.
rngdbdump -ct gen screen

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

1/5/2012 4:04 PM

More for the Lawson group, the command would be:
rngdbdump -ct gen screen | lashow from LID

stephanie

New Member

Posts: 0

1/5/2012 4:23 PM

Hi Dave - if you want to contact me off line (stephanie.harris@mail.house.gov) I have an excel spreadsheet that I created manually that lists form number, name, and a brief description of the data within the report. It's only updated up to v8.1 apps, but it's a good start. Steph

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

1/5/2012 5:56 PM

Interestingly, Lawson used to publish these and even included samples! Just my opinion, but I think keeping it updates as new versions were released, combined with the proliferation of Crystal and other reporting solutions as well as the HR report writer, made Lawson's canned reports look very limited.

stephanie

New Member

Posts: 0

1/5/2012 7:10 PM

Thanks John, for allowing me to REALLY feel my age, because when I counted back how many years ago it was that Lawson provided that info, I almost fainted that I've been alive that long.... I agree, though - with the advent of the other reporting tools and options, as handy as the standard reports can be, other tools allow so much more flexibility.