Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Hide field from printing on report

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