Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 188
	Members: 0
	Total: 188

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

Payroll Reporting

6 Replies

0 Subscribed to this topic

68 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

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

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

1/5/2012 4:04 PM

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

stephanie

Veteran Member

Posts: 330

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: 3353

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

Veteran Member

Posts: 330

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.