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 Send Private Message
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
Send Private Message
Posts: 3351
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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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