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...
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:
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.
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...
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...
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...
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 :)...
"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...
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...
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...
/*
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.