Quarterly Report - Calculating For Each Of The Next Four Months?

RE: Quarterly report - calculating for each of the next four months?



As I play with joins and functions to help mold my data.. I'm
thinking
about options.


I have a status table with termination status entries that will
dictate participation spans for members.. a member can have multiple
stop and start status entries in that status table. I've built an
sql function that given a member's ID and a month/year will return the
number of days the member particpated in the month.


I need to produce an SSRS report that given a starting month/year
will report days of activity for every member for the next four months.


So my report will look like this:
memberid 2007/06 2007/07 2007/08 2007/09
001 10 0 20 5
002 0 2 55 1


Should I build a view that given the starting yearmonth returns
month1 - 4's data in a row?

or is there a smarter design? Possibly a row for each month? or SSRS
formulas? Maybe the formula is gonna be a performance killer.


Thanks for any help or information!!!