Questions GI Sales Order History - by any given timeframe - end user filter Date Range
I am trying to do a GI for Sale Order History - by date range (this needs to be able to be a filter for what was sold in specified period of time, day, month, week, etc.)
These are my tables. I have them Grouped by Inventory ID. The filter needs to be the SO Date and the results should be the Sum of QTY. How do I get this filter to work, if I take the date range out of the results grid? I tried doing it in the parameter but that isn't pulling anything when I enter dates.
This is the end results but I need to have a date filter by either ARTrans or Shipment Date.
How can I make this be a Filter on the front end of the GI instead of hard coded in the Result Grid
I want the end user to be able to filter by date's they choose...
I got this figured out...thanks