Relationship Between .rpt Form and Create CSV in Portal

 4 Replies
 0 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
Preston Burdwell
Advanced Member
Posts: 33
Advanced Member
New Poster
New Poster
Congrats on posting!
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: 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!
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
New Poster
New Poster
Congrats on posting!
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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
New Poster
New Poster
Congrats on posting!
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