Search results for query: *

  1. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Here is my final code. Imports System Imports System.Data Imports System.Data.SqlClient Imports Microsoft.Reporting.WinForms Public Class REPORT_monthly_Procurement_goods Dim conn As SqlConnection Dim comm As SqlCommand Private Sub openconnection() conn = New...
  2. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Omg Juggalo, THAT's IT !!!!!! You've done it!!!!! :highly_amused: :highly_amused: I am so grateful to you for all of your help, and especially your patience. :highly_amused: :highly_amused:
  3. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Here's the error. Also I noticed that during runtime the combobox.Month collection items were not available in the pull down. Only the Default of January was there. But when I clicked the pull down there were no months to choose from.
  4. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Hi, I noticed YearStr needs to be declared. Dim YearStr As String ???? YearStr = 2015 ???? .................................... Private Sub REPORT_monthly_Procurement_goods_Load(sender As Object, e As EventArgs) Handles Me.Load 'Select the current year in the ComboBox...
  5. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Thank you ! Imports System Imports System.Data Imports System.Data.SqlClient Imports Microsoft.Reporting.WinForms Public Class REPORT_monthly_Procurement_goods Dim conn As SqlConnection Dim comm As SqlCommand Private Sub openconnection() conn = New SqlConnection...
  6. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    DONE I also declared Counter as INT16 Private Sub REPORT_monthly_Procurement_goods_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DSOURCE_ProcurementGoodsTABLE.procurement_goods' table. You can move, or remove it, as needed...
  7. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Juggalo, I've also sent you a private message that might interest you. You mentioned: just use DateTime.Now.Year <--- Can you show me where this should go?? Here's my code again. Please take a look at the combo box lines where I tried DateTime.Now.Year :)...
  8. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    "Remove the "Me.procurement_goodsTableAdapter.Fill(...)" and "Me.ReportViewer1.RefreshReport()" lines from the Load event." DONE "Have the form automatically set the current Month & Year values in both ComboBox's", DONE "then since those values are known at that point use them in the...
  9. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Will do! I'll report back to you asap!!!!
  10. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    I tried it and failed. But the failure was not due to your example. Upon clicking a button on a previous form that launches the report viewer form. I get the following error. However, I believe the above error is because I'm calling the report viewer form before I have a chance to enter the...
  11. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    Your suggestion has helped !! here is my new line: Me.procurement_goodsTableAdapter.Fill(Me.DSOURCE_ProcurementGoodsTABLE.procurement_goods, ComboBox_MONTH, ComboBox_YEAR) The original error has gone away and now I'm getting an error for 'ComboBox_YEAR' and 'ComboBox_Month' that says the...
  12. C

    Pass user input from form To Report Viewer using SQL SELECT ... @var

    /* SQL 2008 Visual Studio 2013 - Report Viewer My vb skill level: Poor but I'm excited to learn Profession: DBA - Can I set up the sql connection in VB? - YES - Can I set up the NAME, Data Source, and Table Adapter in VB? - YES ERROR: Argument Not Specified For Parameter */ Please guys, I...
Back
Top