Filtering Reports from Database information.

private void Form1_Load(object sender, EventArgs e)
      {
          // TODO: This line of code loads data into the 'dEV_ROB_KSWDataSetCountryList.vCustomers' table. You can move, or remove it, as needed.
          this.vCustomersTableAdapter1.Fill(this.dEV_ROB_KSWDataSetCountryList.vCustomers);
          // TODO: This line of code loads data into the 'DEV_ROB_KSWDataSet.vCustomers' table. You can move, or remove it, as needed.
          this.vCustomersTableAdapter.Fill(this.DEV_ROB_KSWDataSet.vCustomers, "GB");
          this.reportViewer1.RefreshReport();
      }
      private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
      {
//I put a try catch in here as it fell over at first using the SelectedItem.ToString() so try Catch saved it falling over in Debug :)
          try
          {
              this.vCustomersTableAdapter.Fill(this.DEV_ROB_KSWDataSet.vCustomers, comboBox1.SelectedValue.ToString());
              this.reportViewer1.RefreshReport();
          }
          catch (Exception)
          {
//I know, bad practice of suppressing exceptions.... :(
          }
      }

SELECT DISTINCT [Default Country Code], [Default Country] FROM dbo.vCustomers