6 Replies Latest reply on Jan 20, 2010 10:08 AM by mrvodka

    How to generate report sorted by month

    mayor

      Title

      How to generate report sorted by month

      Post

      Hello,

       

      I facing a problem how to generate the report by month.

      I got 2 tables, research and expenses

       

      Research ( research_account_no, researcher_name, amount ....)

      Expenses (research_account_no, invoice_no, invoice_date ....)

       

      Relational field : research_account_no

       

      I intend to generate report in 1 layout as below:

       

      January

      -------

      research_account_no            invoive date      staff_name       invoive_amount...

       

       

      February

      ---------

      research_account_no            invoive date      staff_name       invoive_amount...

       

      and so on...

       

      Each month is sorted by invoice_date. Please advive me how to do that.

       

      TQ