• Filtering products supplied to a customer

    Hi, I'm looking to write a report in Report Designer which gives me information on the products that we supply to our customers. I think there may already be a standard report that shows this but as far as I can see it lists sales to the customer…
  • Setting a date range for a report

    Hello, I have a "previous 12 months stock usage" report that I use to help with predicting stock reorder levels. Its set up with a pre-set date range that I have to change every so often to reflect usage of items that fall outside of the original…
  • Using IF statement to select a delivery date?

    Hello, I have a Sales Order confirmation form set up so that each line on the order can show its own delivery date. This calls on SOP_ITEM.DUE_DATE and has to be manually input. Should any line contain a blank SOP_ITEM.DUE_DATE then I want to be able…
  • How to make Group Header / Footer not appear on report when no values to show?

    Hi, I've have tried a few expressions and filters to figure this out, but I can't seem to crack it. I want the group header and footer to not show if there are no values in the details section within the group. See image below. For reference, this…