In the Expenes table, define a calculation field cMonth (result is Date) =
invoice_date - Day ( invoice_date ) + 1
Define a sub-summary part (when sorted by cMonth) for your report. Place the cMonth field in this part, and format it to show only the month name.
Thanks a lot, I got it. But I have 1 more question on how to generate numbering for
each month. Let look example below,
No. research_account_no invoive date staff_name invoive_amount
1. abc123 5/7/2009 John $250
2. pqr236 4/7/2009 Robert $370
1. xyz234 2/3/2009 Safina $620
2. frp458 2/9/2009 Michel $980
a. How i want to generate numbering for each month?
b. Numbering for each month start with 1.
Use a summary field defined as Count of [any field that cannot be empty]. In the options, select 'Restart summary for each sorted group' and choose cMonth as the breakfield.
Thanks so much, it works.
Thanks and it helped me a lot.
Pls, How can I format it to show only the month, I failed to make a gouping by a month
Choose the field, then go to the format menu and select Date.