AnsweredAssumed Answered

Sub-summary report grouped by month

Question asked by mayor on Apr 28, 2014
Latest reply on Apr 29, 2014 by mayor

Title

Sub-summary report grouped by month

Post

     Hello, I design inventory system, the table as bellow;

     stock ( stock_id, stock_name, category ....)

     stock_count ( stock_id, qty_in, qty_out, date_inout .....)

     relationship : stock_id.

     Table stock_count is to store the transactions of stock in and out.

     I want to generated report that grouped by month of the transaction which is based on the date_inout, sorted by this date field, descending.

     Attached my screenshot.

inventory

     I want the report as below:

May

Stock Name              Date InOut

     1. A4 paper                3 May 2014

     2. A3 paper                1 May 2014

April

     1. Pencil                     25 April 2014

     2. Pocket file              13 April 2014

      

     How to make this kink of report, please help.

     Many thanks in advance.
      

      

Outcomes