On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Course Of The Month
9 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Error trying to generate a report with parameters
Posted on 2011-02-22
I have created a report that contains parameters. I set it up so that the parameters would be hidden. I am trying to run this report and have it displayed in a report viewer on an asp page that I have. I basically created a page that will accept the parameters and then click a button to generate the report based on the parameters the user enters. Some of the parameters will be null at times.
I am running the program and I get a message. Can anyone please tell me what my problem is?
The message is: Object reference not set to an instance of an object.
Here's the code too:
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
setParams()
ReportViewer1.ProcessingMo
ReportViewer1.ServerReport
ReportViewer1.ServerReport
(The message occurs on this next line)
RptParameters(0) = New Microsoft.Reporting.WebFor
RptParameters(1) = New Microsoft.Reporting.WebFor
RptParameters(2) = New Microsoft.Reporting.WebFor
RptParameters(3) = New Microsoft.Reporting.WebFor
RptParameters(4) = New Microsoft.Reporting.WebFor
RptParameters(5) = New Microsoft.Reporting.WebFor
RptParameters(6) = New Microsoft.Reporting.WebFor
RptParameters(7) = New Microsoft.Reporting.WebFor
ReportViewer1.ServerReport
ReportViewer1.ServerReport
End Sub
I am running the program and I get a message. Can anyone please tell me what my problem is?
The message is: Object reference not set to an instance of an object.
Here's the code too:
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
setParams()
ReportViewer1.ProcessingMo
ReportViewer1.ServerReport
ReportViewer1.ServerReport
(The message occurs on this next line)
RptParameters(0) = New Microsoft.Reporting.WebFor
RptParameters(1) = New Microsoft.Reporting.WebFor
RptParameters(2) = New Microsoft.Reporting.WebFor
RptParameters(3) = New Microsoft.Reporting.WebFor
RptParameters(4) = New Microsoft.Reporting.WebFor
RptParameters(5) = New Microsoft.Reporting.WebFor
RptParameters(6) = New Microsoft.Reporting.WebFor
RptParameters(7) = New Microsoft.Reporting.WebFor
ReportViewer1.ServerReport
ReportViewer1.ServerReport
End Sub
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
7-
5
12 Comments
Sub setParams()
Dim i As Integer
If ddlUserName.SelectedValue <> "" Then
i = ddlUserName.SelectedValue.
userLastName = ddlUserName.SelectedValue.
userFirstName = ddlUserName.SelectedValue.
Else
userLastName = ""
userFirstName = ""
End If
If ddlCustomerName.SelectedVa
i = ddlCustomerName.SelectedVa
custLastName = ddlCustomerName.SelectedVa
custFirstName = ddlCustomerName.SelectedVa
Else
custLastName = ""
custFirstName = ""
End If
End Sub
Dim i As Integer
If ddlUserName.SelectedValue <> "" Then
i = ddlUserName.SelectedValue.
userLastName = ddlUserName.SelectedValue.
userFirstName = ddlUserName.SelectedValue.
Else
userLastName = ""
userFirstName = ""
End If
If ddlCustomerName.SelectedVa
i = ddlCustomerName.SelectedVa
custLastName = ddlCustomerName.SelectedVa
custFirstName = ddlCustomerName.SelectedVa
Else
custLastName = ""
custFirstName = ""
End If
End Sub
Active today
try:
RptParameters(0) = New Microsoft.Reporting.WebFor
-->
RptParameters.add(New Microsoft.Reporting.WebFor
same for all others
RptParameters(0) = New Microsoft.Reporting.WebFor
-->
RptParameters.add(New Microsoft.Reporting.WebFor
same for all others
Active today
something like this:
Dim RptParameters() As Microsoft.Reporting.WebFor
Dim RptParameters() As Microsoft.Reporting.WebFor
Active today
or
Dim RptParameters(7) As Microsoft.Reporting.WebFor
dont remember the exacts syntax :)
Dim RptParameters(7) As Microsoft.Reporting.WebFor
dont remember the exacts syntax :)
Active today
this did not work?
Dim RptParameters(7) As Microsoft.Reporting.WebFor
RptParameters(0) = New Microsoft.Reporting.WebFor
...
RptParameters(7) = New Microsoft.Reporting.WebFor
ReportViewer1.ServerReport
...
Dim RptParameters(7) As Microsoft.Reporting.WebFor
RptParameters(0) = New Microsoft.Reporting.WebFor
...
RptParameters(7) = New Microsoft.Reporting.WebFor
ReportViewer1.ServerReport
...
Active today
or use this syntax (from MS - Generic List approach)
Dim paramList As New Generic.List(Of ReportParameter)
paramList.Add(New ReportParameter("EmpID", "288", False))
paramList.Add(New ReportParameter("ReportMon
paramList.Add(New ReportParameter("ReportYea
ReportViewer1.ServerReport
http://msdn.microsoft.com/en-us/library/ms252663(v=vs.80).aspx
in your case:
Dim paramList As New Generic.List(Of ReportParameter)
paramList.Add(New ReportParameter("EmpID", "288", False))
paramList.Add(New ReportParameter("ReportMon
paramList.Add(New ReportParameter("ReportYea
ReportViewer1.ServerReport
http://msdn.microsoft.com/en-us/library/ms252663(v=vs.80).aspx
in your case:
Dim RptParameters As New Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)
RptParameters.Add(New Microsoft.Reporting.WebForms.ReportParameter("user", txtUserName1.Text))
...
RptParameters.Add(New Microsoft.Reporting.WebForms.ReportParameter("enddate", txtEndDate.Text))
ReportViewer1.ServerReport.SetParameters(RptParameters)
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 1 hour left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.