Prev
Next
Forums Integration / Customization S3 Customization/Development

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