bluerain25 0 Newbie Poster

hello guys is there anyone who can help me with crystal report? im doing a report lke this in crosstab. The report whould be able to accept Date start and end date of the coverage as parameters. the coverage starts with every 16the of the previous month and ends at every 15 of the current month (exmple: May 16, 2008 to June 15, 2008) regardless of the month, the report should display exactly as illustrated below:

Week 1 Week 2 Week 3 Week 4 Total
AA 10 10 10 10 40
AB 20 20 20 20 80
Total 30 30 30 30 120

what i get is the same as above if im going to print the january 1st report but on the succeeding months i got a differrent week .. the report look like this if i print the May to june coverage:

Week 20 Week 21 Week 22 Week 23 Week 24 Total
AA 10 10 10 10 10 50