Results 1 to 8 of 8

Thread: Suppress Grid line

  1. #1
    New Member
    Join Date
    Jul 2003
    Location
    Selangor, Malaysia
    Posts
    21

    Suppress Grid line

    Dear List,

    Is there a way to suppress grid records based on the value of the previous grid line information.

    For example, from the sales order detail file, there will be multiple line with the same order number. I only want to have one line in the grid. Essentially, what i did is to try suppressing the grid when the order number is equal to the previous grid order number.

    I can't seems to get it to work, i try using the bc order number = gc order number in the write grid line - before event but it seems that the bc and gc value is the same.

    Please help!!!!

    Thanks in advance


  2. #2
    Senior Member
    Join Date
    Jul 2004
    Location
    UK
    Posts
    156

    Re: Suppress Grid line

    Hi limkb

    You need to save the order no as either a variable or as Form Control whenever it appears for the 1st time otherwise suppress the line in your Grid Record is Fetched event.

    The ER shown below should hopefully do it.

    //
    If BC Document (Order No, Invoice, etc.) (F4211) is not equal to FC Saved Order Number
    FC Saved Order Number = BC Document (Order No, Invoice, etc.) (F4211)
    Else
    Suppress Grid Line(FC Grid)
    End If
    //

    Try it and see if it's OK.
    Regards

    Sati

    OneWorld Xe, AS400 V5R4
    Create!form Server 3/Server 6

  3. #3
    New Member
    Join Date
    Jul 2004
    Location
    Spain
    Posts
    27

    Re: Suppress Grid line

    Hi friend,

    You can look at P03B2002 Summarize check box. This check box implements the same as you want to do over F4211 but over F03B11.

    Take a look at this application and let me know if you have enough information to get your application working.

    Best Regards

    Sergio

  4. #4
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,761

    Re: Suppress Grid line

    Which event are you placing your Suppress Grid Write, within?

    Try changing the sequence of which event you are placing you suppress within. I dare not try to suggest which event block, from memory - If it's not in the right event block, it will not work.

    Regards

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  5. #5
    New Member
    Join Date
    Jul 2003
    Location
    Selangor, Malaysia
    Posts
    21

    Re: Suppress Grid line

    Hi,

    Thanks a lot on the suggestion. I finally manage to get it to work by creating a variable in the write grid line - after event to store the document number. Then suppress the when bc document number = variable document number in the grid record is fetch event.

    Thank for all the advice... cheers


  6. #6
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,403

    Re: Suppress Grid line

    system function 'Suppress Grid Line' only works in the Grid record is fetched event
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  7. #7
    Thanks this thread was very useful today in 2019. I was trying to use 'Suppress Grid Line' in Write Grid Line before and it didnot work. I got confirmation here that it works only in Grid Record is Fetched and it worked.
    Thanks & Regards,
    CoolKl
    Oracle PaaS, JDE Enterprise One (9.2,9.1,7.3,XE), World Soft 7.3, AS400
    Success is the Journey From Knowing to Doing

  8. #8
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,403
    Awesome, glad to help. As I totally forgot this myself. Even thought it's my solution
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.