ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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
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
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
something like this:
Dim RptParameters() As Microsoft.Reporting.WebFor
Dim RptParameters() As Microsoft.Reporting.WebFor
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 :)
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
...
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
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …
Suggested Courses
Course of the Month9 days, 11 hours left to enroll
606 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.