• Search Forums
    Advanced Search
Prev
Next
Forums Integration / Customization S3 Customization/Development

Create CSV from custom report

 7 Replies
 0 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
Karl Kemp
Basic Member
Posts: 20
Basic Member
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: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
5/23/2007 9:24 PM
When you say "custom"...are they "painted" reports or written from scratch in 4GL/COBOL?
Thanks for using the LawsonGuru.com forums!
John
Karl Kemp
Basic Member
Posts: 20
Basic Member
5/23/2007 10:10 PM
Hi John,
These are cobol apps (unix).
John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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...
Thanks for using the LawsonGuru.com forums!
John
Karl Kemp
Basic Member
Posts: 20
Basic Member
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: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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!
Thanks for using the LawsonGuru.com forums!
John
k-rock
Veteran Member
Posts: 142
Veteran Member
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
Basic Member
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?