title: WHERE clause not working with Visual Studio rdlc reports
body: <p>I am having an issue with my one report (Visual Studio rdlc reports) query where there is permanently an issue with the <code>where</code> clause when I try filter the results by date from the Invoice table:</p>
  
  <pre><code>SELECT tblItem.ItemName, tblSale.Qty, tblInvoice.InvoiceID, tblItem.Price * tblSale.Qty
  FROM     tblInvoice INNER JOIN
                    tblSale ON tblSale.InvoiceID = tblInvoice.InvoiceID INNER JOIN
                    tblItem ON tblItem.ItemID = tblSale.ItemID
  GROUP BY tblInvoice.InvoiceID
  
  WHERE tblInvoice.Date &gt;= {^@theDate}
  </code></pre>
  
  <p>This above query runs perfectly in PhpMyAdmin on cpanel with our tables but as I put it into the query in .rdlc reports then it throws the error.</p>
  
  <p>I have another query to populate another report where I use exactly the same where clause and it filters without an issue. The working where clause uses the date column from the same table that the select calls from:</p>
  
  <pre><code>SELECT CustID, FirstName, LastName, Telephone, Email FROM tblCustomer 
  WHERE DateAdded &gt;= @theDate
  </code></pre>
  
  <p>Is there any solution to this? 
  Also are you able to do equations in the query for .rdlc reports?
  I need a "total" column which would be <code>(tblSales.Qty * tblItem.Price)</code> which again works perfectly in PhpMyAdmin but will not display any value when run in the .rdlc report.</p>
  
  <p>Github Link: <a href="https://github.com/byroncoetsee/WIL2014" rel="nofollow">https://github.com/byroncoetsee/WIL2014</a></p>
  
  <p>The set I am having problems with is <code>Dataset3</code> and then <code>frmReportSales</code>, <code>frmShowingSales</code> where the date value is passed across.</p>