Monthly report for C# application
<p>I am building a report for my application using VS2010.  </p>

<p>The data for the application is stored in a SQL Server 2008 R2 database.  </p>

<p>The columns are </p>

<pre><code>DateCreated (DateTime)
CardPrinted (bit)
DatePrinted(DateTime)
</code></pre>

<p>I want to create a report that will show, for each month starting from January 2012,</p>

<ol>
<li>Total Number of <code>CardPrinted</code> for week1</li>
<li>Total Number of <code>CardPrinted</code> for week2</li>
<li>Total Number of <code>CardPrinted</code> for week3</li>
<li>Total Number of <code>CardPrinted</code> for week 4  </li>
</ol>

<p>NB: If a card is printed, it is Marks 1 in the database, so that the <code>CardPrinted</code><br>
column is either 1 or 0.  </p>

<p>Please I need someone to to help with the query I needed to achieve this.</p>
