title: Specify a "where clause" when using a ReportViewer control and Report w/ Oracle
body: <p>I am attempting to use the ReportViewer control with an Report (RDLC) file in local processing mode using an Oracle DB, and I cannot figure out how to specify a "where clause" in my query. I just want to return 1 row, as my report will be based on just 1 row from the query.</p>
  
  <p>Here is what I have done so far:</p>
  
  <ol>
  <li>I created a C# Windows Form Application (.NET 4.5) in Visual Studio 2013.</li>
  <li>I added a DataSet named DataSet1.</li>
  <li>I added a TableAdapter to the DataSet and created a connection to Oracle added a query. Here is the query "select * from Lei_Defect_Log". (It pulled
  in the column names.) </li>
  <li>I added a Report named Report1 to the project.</li>
  <li>On the "Report Data" window, I set the Dataset to the dataset I added
  above. </li>
  <li>I dragged a few arbitrary columns from the Report Data window
  Dataset1 to the Report1 so I could verify it is working. </li>
  <li>I added a ReportViewer named reportViewer1 to Form1 of the project. I set the
  Report of the reportViewer1 to Report1 created above.</li>
  </ol>
  
  <p>Now, when I run the application, the report displays data from the query (must be the first row returned). But the table I am pulling from (Lei_Defect_Log) has thousands of rows, and I want to specify a where clause in my query to just return 1 specific row. (I want to do this in the code, and not prompt the user for it.)</p>
  
  <p>I tried adding a where clause in the TableAdapter query as follows "select * from Lei_Defect_Log where RA_SN = :RA_SN_PARAM" which would be a correct query for Oracle, but I received the following error:</p>
  
  <blockquote>
    <p>The wizard detected the following problems when configuring the TableAdapter: "Fill":
    Details:
    Generated SELECT statement.
      Specified argument was out of the range of valid values.</p>
  </blockquote>
  
  <p>It would allow me to click OK, but if I clicked OK my DataSet would not populate the column names. So no go.</p>
  
  <p>I have been at this for many hours...and am stuck.</p>
  
  <p>Everything I have seems to work, but I just need to be able to add a where clause to specify the row I need.</p>
  
  <p>So how do I specify a where clause (in the code or designer, I don't want the user to be prompted for it) so my query returns just one row/record?</p>