• SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
  • Sales Report for the last 2 years

    I want to run a Sales History Report that contains the last two years of data. I only want to enter the end date and compute the begin date as two years earlier. Can I do that with a parameter or filter?