AnsweredAssumed Answered

How to generate report sorted by month

Question asked by mayor on Jun 1, 2009
Latest reply on Jan 20, 2010 by mrvodka

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

 

 

Outcomes