Open Forum

Expand all | Collapse all

Jet Reports - Comparative Prior Period Sales will not show if No Current Sales

  • 1.  Jet Reports - Comparative Prior Period Sales will not show if No Current Sales

    Posted Feb 10, 2020 12:21 PM
    Hello Everyone,

    I'm having trouble with one of my Jet Reports with Current Year vs Prior Year comparative sales data.  If there were no sales in the current year for a specific district, the report will not show sales for that district in the prior year even if there were sales.  This is affecting my totals and my comparative Prior period data is incomplete.

    Has anyone out there had this problem and if so, how can I fix this?

    Thanks,

    Elena

    ------------------------------
    Magneco Metrel
    MAGNECO/METREL INC.
    Addison IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Jet Reports - Comparative Prior Period Sales will not show if No Current Sales

    Posted Feb 11, 2020 06:34 AM
    Hi Elena,

    It's likely because your date range for your initial NL("rows") is for the current year only. You need to expand it to include the prior year.

    I'll be glad to look at this report with you. I've been writing Jet Reports since 2005.

    Please contact me directly at:  Janice@reportsyourway.com


    ------------------------------
    Janice Taylor
    Managing Director
    Reports Your Way Ltd.
    Canada
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role