Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Infor / Lawson Platforms
S3 Systems Administration
Hide field from printing on report
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
251
Members:
0
Total:
251
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Systems Administration
Hide field from printing on report
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
andrew
Veteran Member
Posts: 100
5/28/2010 12:53 AM
I am trying to hide a field from printing on a report.
More specifically the bank account field on the PR141 report.
Anyone know how to edit a report (is it the *.rpt file) ?
and would anyone know how to remove this specific information from the pr141 report ?
sql 2005, windows 2003
thanks..
Ragu Raghavan
Veteran Member
Posts: 468
5/28/2010 1:21 AM
The .rpt file is where the report layout is defined. If you just delete the field that relates to Bank-acct, the compiler will errior out.
You will need to edit the PD file.
here is what I would do:
1. make a copy of PR141 (avoid making changes to Lawson code)
2. go to the .rpt file and determine whihc field I want to hide. For instance BNK-ACCT-NBR. The prefix in the .rp file shows AL-.
3. go into the PD of the copy, and lookup all instances in the code where some value is being MOVE'd to AL-BNK-ACCT-NBR. Change this to a INITIALIZE or MOVE SPACES, so the report will show blank in the field.
4. compile the copy
5. Use secuirty to deny access to PR141 and have users run the copy instead.
Good luck
andrew
Veteran Member
Posts: 100
5/28/2010 12:59 PM
Ragu..
thank you for your response, I will give it a try.
have a great weekend.
You are not authorized to post a reply.