Is this possible? - dates grouping

[YA]

I need to create a report to show concurrent usage of resource. The senario is like this:

Resource A is assigned to a class that occurs 10/16 - 10/18.
I need to make a group by each day. (10/16,10/17,10/18)But the class dates are stored in the database with startdate and enddate. Is there any way I can list these 3 days separately as group?

Any help would be appriciated.
Thanks!

 

[Guest_imported]

The only way I can think of that you could try would be to:-

- create a formula field (independent of the db) to represent every day
- group by this
- show your db fields only where the above formula field falls within the start/end dates specified in the db
- i.e. if formula field between start date & end date then db value

 

[YA]

Thanks for your reply Matt!

I am wondering how I can create a formula field (independent of the db) to represent every day..If I can create this formula, I can use conditional suppressing..

Thanks in advance