Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Crystal Suppression formula

  • 1.  Crystal Suppression formula

    Posted 08-06-2020 17:58
    Client just upgraded from 2017 to 2019.  On a S/O form, they want to suppress the Order date when it is 7/7/1977.  In 2017 (Crystal 2011), this syntax works.  In 2019 (Crystal 2016), it doesn't suppress.  Does anyone know how to change the syntax?  It doesn't like quotes.
     

    Crystal Suppression formula
    Interestingly, the text field next to it has the same suppression formula, and it suppresses.


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:08
    year(shipexpiredate) = 1977 ...?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:12
    Normally after the equal I would use     date(1977,7,7)

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 4.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:17
    Beth's answer is better (and what I would normally do for exact date matching).  I use the year() strategy for blank SQL dates because it is faster to type.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:19
    I'm striking out.  Did I capture the syntax the way you intended?

    None of these work:
    //{SO_SalesOrderWrk.ShipExpireDate} = #7/7/1977#
    //year({SO_SalesOrderWrk.ShipExpireDate}) = 1977
    {SO_SalesOrderWrk.ShipExpireDate} = date(1977,7,7)

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 6.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:21
    Are you sure of the field value?  SQL dates are technically date/time and won't match exactly when the time is not 00:00:00.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 7.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:30
    date
    I've printed several orders with the same date value and get the same results. (fyi:  the form is a S/O form used as a proforma invoice, which is why the S/O number field is labeled as "Invoice Number".  The date 7/7/1977 has meaning for them, but I don't recall what it is).
    ​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 8.  RE: Crystal Suppression formula

    Posted 08-06-2020 18:56
    Double-check the raw work table data?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 9.  RE: Crystal Suppression formula

    Posted 08-06-2020 19:16
    Yes, darn it

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 10.  RE: Crystal Suppression formula

    Posted 08-07-2020 11:47
    Turns out the formula is fine.  Mysteriously, the conditional suppression formula "jumped" to the "Suppress If Duplicated" field in the Format Editor from the "Suppress" field. I'm going to blame MASCRCW.EXE.

    Thanks to @Dan Burleson for finding it for me.​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 11.  RE: Crystal Suppression formula

    Posted 08-07-2020 11:49
    I was going to mention checking where the suppression formula was, but thought it should be in the right place for a converted report.  Very odd!

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content