title: Monthly report for C# application
body: <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>