Budget month in labor report

[tav1035]

I'm trying to identify the best way to display the budget month in the details or if it is possible.
When I run my report for August, I use the date range 7/27-8/30.

Our work weeks are Friday -Thurs.
(Last thursday of the month is the end of the Budget Month and the new one begins on Friday).

My details should look like->
BudgetMonth Name Hours EnteredDate
8 John Doe 8.0 7/27/07
8 John Doe 8.0 7/28/07
8 John Doe 8.0 7/29/07
8 John Doe 8.0 7/30/07
8 John Doe 6.0 8/02/07
8 John Doe 2.0 8/02/07
8 John Doe 8.0 8/03/07
8 John Doe 8.0 8/04/07
8 John Doe 8.0 8/05/07
8 John Doe 8.0 8/06/07
etc...
I'm looking for a way to display the budgetmonth as 8 if the details are for August.

One idea I had->
Since the the majority of the entered dates are in August, I built a summary in the footer to show the Most Frequent which is 8. Now I would like to add that to the details, which I'm not sure if that's possible.

Problems:
What if the report is ran for all of 2007, could I still assign the correct Budget Month for every record in the details.

Any ideas would help...
Thanks,
tav

 

[beltmanjr]

It is unclear to me what the issue is. However, if you want to display the month in which the budget closes (in your case 8) just take the month() function and use your closure date as argument (it will give you 8). You could also take ToText(date, 'M') to display the month number.

This will work in the details section.

you wont be able to assign stuff defined in a footer to the sections above

 

[tav1035]

beltmanjr,
The issue is when a person enters their time at the end of the month (7/29/07), they are adding their time against the budget month of 8 not 7... So the "ToText(date, 'M'" won't work for all records.

But the month() function would probably work if I only ran the report for 1 month ranges at a time.

I've never used functions with the closure date (parameters) as an argument. Any tips on how?

tav