2 Replies Latest reply on Apr 29, 2014 5:18 PM by mayor

    Sub-summary report grouped by month

    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.