Relationship Between .rpt Form and Create CSV in Portal

 4 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Preston Burdwell
Advanced Member
Posts: 33
Advanced Member
    Where does Lawson get the field mapping parameters to Create CSV when this button is pushed within the Portal?
    Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR
    John Henley
    Posts: 3353
      When you compile (or run rptgen) a .rmp file is created in $LAWDIR//rptmap/... folder
      Thanks for using the LawsonGuru.com forums!
      John
      Preston Burdwell
      Advanced Member
      Posts: 33
      Advanced Member
        Thanks. So how do you define output to CSV that will be wider than what can print across the .rpt file? I have seen Lawson delivered programs stack the output in .rpt and when Create CSV is pushed in the portal, it outputs the data horizontally into the spreadsheet . . . I am trying to duplicate this type of output with a custom program and I am not able to get the Create CSV option to ouput the data correctly.
        Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
          In the .rpt file, each report group can have multiple lines. Let us say each line has 12 fields, and you have 5 lines in the group, that will translate to a csv row of 60 fields.
          Or if all you want is a csv file, define it in workdef and move the values to the csv fields and do a 800-WRITECSV-filename
          Preston Burdwell
          Advanced Member
          Posts: 33
          Advanced Member
            I wanted to give the end users the ability to click on the Create CSV button in the portal and have them get the output that way . . . I will try your first suggestion and see how that works. Thanks!
            Preston Burdwell Systems Analyst CHRISTUS St. Vincent Med CTR