• Search Forums
    Advanced Search
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Hide field from printing on report

 2 Replies
 0 Subscribed to this topic
 29 Subscribed to this forum
Sort:
Author
Messages
andrew
New Member
Posts: 0
New Member
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: 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!
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
New Member
Posts: 0
New Member
5/28/2010 12:59 PM
Ragu..
thank you for your response, I will give it a try.
have a great weekend.