Who's On?

	Membership:
	Latest: Pat
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5296

	People Online:
	Visitors: 436
	Members: 0
	Total: 436

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

Create CSV from custom report

7 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Karl Kemp

Basic Member

Posts: 20

5/23/2007 7:49 PM

Has anyone ever ran into an issue similar to this, and if so what did you do?

I have created 2 or 3 "custom" reports. They run fine and generate the desired output. However, when I try to genereate a CSV file from the PRTMGR in LID, the CSV File selection is not "selectable".

I'm thinking there might be a parameter within the report form that has to be set?

This action works fine in the standard Lawson apps, so it must be something that I have omitted.

Thanks!

John Henley

Posts: 3355

5/23/2007 9:24 PM

When you say "custom"...are they "painted" reports or written from scratch in 4GL/COBOL?

Karl Kemp

Basic Member

Posts: 20

5/23/2007 10:10 PM

Hi John,
These are cobol apps (unix).

John Henley

Posts: 3355

5/24/2007 4:36 PM

Hmm... I'm not aware of anything special that you need to do.
I'm assuming you've tried recompiling...

I've also seen this when permsmaint is set too strict, and users can't access the RptMap files...

Karl Kemp

Basic Member

Posts: 20

5/24/2007 5:35 PM

I'm not familiar with, or maybe I know them by another name, the rptmap files etc.

Where would these be, so that I can check the permission thing?

Thanks!

John Henley

Posts: 3355

5/24/2007 5:54 PM

$LAWDIR//rptmap/default/.rmp
Make sure you have one there for your custom program, and if so that it's readable by your users.

Are you familiar with Lawson's 'permsmaint' utility and if so, have you run it recently? I have dealt with some recent cases where it tightens these directories & files down so that the "average user" can't see them!

k-rock

Veteran Member

Posts: 142

5/29/2007 4:00 PM

When you open the report from the print manager, move the cursor down to the first line of detail. The cursor should go from an underline to an highlighted block. When it changes, do your Send To CSV. We have to do that with some regular Lawson reports.

Karl Kemp

Basic Member

Posts: 20

6/1/2007 2:41 PM

I have also noticed that I can't see the reports my custom apps generate via PDF in Portal.

I get the following message: Error: No .dtl file was found.

I verified that I do have a .dtl file in the print directory, everything looks the same as the reports generated by standard Lawson apps.

I can see all the standard Lawson reports.

I verified that my permissions were set correctly

Any ideas?