Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

Error trying to generate a report with parameters

Posted on 2011-02-22

SSRS
ASP.NET

1 solution

Medium Priority

485 Views

Last Modified: 2012-05-11

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.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://srmha-96648582/ReportServer")
ReportViewer1.ServerReport.ReportPath = "/Report Project6/CCD"
(The message occurs on this next line)
RptParameters(0) = New Microsoft.Reporting.WebForms.ReportParameter("user", txtUserName1.Text)
RptParameters(1) = New Microsoft.Reporting.WebForms.ReportParameter("keyword", txtKeyWord.Text)
RptParameters(2) = New Microsoft.Reporting.WebForms.ReportParameter("userlastname", userLastName)
RptParameters(3) = New Microsoft.Reporting.WebForms.ReportParameter("userfirstname", userFirstName)
RptParameters(4) = New Microsoft.Reporting.WebForms.ReportParameter("custlastname", custLastName)
RptParameters(5) = New Microsoft.Reporting.WebForms.ReportParameter("custfirstname", custFirstName)
RptParameters(6) = New Microsoft.Reporting.WebForms.ReportParameter("startdate", txtStartDate.Text)
RptParameters(7) = New Microsoft.Reporting.WebForms.ReportParameter("enddate", txtEndDate.Text)
ReportViewer1.ServerReport.SetParameters(RptParameters)
ReportViewer1.ServerReport.Refresh()

End Sub

Comment

Question by:mmtcunningham1

[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

Join The Community

12 Comments

LVL 59

Expert Comment

by:HainKurt

ID: 349539502011-02-22

code for setParams() ???

Author Comment

by:mmtcunningham1

ID: 349540132011-02-22

Sub setParams()
Dim i As Integer
If ddlUserName.SelectedValue <> "" Then
i = ddlUserName.SelectedValue.IndexOf(",")
userLastName = ddlUserName.SelectedValue.Substring(0, i)
userFirstName = ddlUserName.SelectedValue.Substring(i + 1, ddlUserName.SelectedValue.Length - (userLastName.Length + 1))
Else
userLastName = ""
userFirstName = ""
End If
If ddlCustomerName.SelectedValue <> "" Then
i = ddlCustomerName.SelectedValue.IndexOf(",")
custLastName = ddlCustomerName.SelectedValue.Substring(0, i)
custFirstName = ddlCustomerName.SelectedValue.Substring(i + 1, ddlCustomerName.SelectedValue.Length - (custLastName.Length + 1))
Else
custLastName = ""
custFirstName = ""
End If
End Sub

LVL 59

Expert Comment

by:HainKurt

ID: 349540362011-02-22

above code is not related :)

how do you define RptParameters?

LVL 59

Expert Comment

by:HainKurt

ID: 349540432011-02-22

try:

RptParameters(0) = New Microsoft.Reporting.WebForms.ReportParameter("user", txtUserName1.Text)
-->
RptParameters.add(New Microsoft.Reporting.WebForms.ReportParameter("user", txtUserName1.Text))

same for all others

Author Comment

by:mmtcunningham1

ID: 349541802011-02-22

I have it defined like this:
Dim RptParameters() As Microsoft.Reporting.WebForms.ReportParameter

Author Comment

by:mmtcunningham1

ID: 349543182011-02-22

RptParameters.add(-----)) is not allowed for system.array is the message i'm getting

LVL 59

Expert Comment

by:HainKurt

ID: 349543582011-02-22

something like this:

Dim RptParameters() As Microsoft.Reporting.WebForms.ReportParameter = new Microsoft.Reporting.WebForms.ReportParameter(7)

LVL 59

Accepted Solution

by:HainKurt

HainKurt earned 2000 total points

ID: 349543702011-02-22

or

Dim RptParameters(7) As Microsoft.Reporting.WebForms.ReportParameter

dont remember the exacts syntax :)

Author Comment

by:mmtcunningham1

ID: 349544022011-02-22

that won't work

LVL 59

Expert Comment

by:HainKurt

ID: 349545292011-02-22

this did not work?

Dim RptParameters(7) As Microsoft.Reporting.WebForms.ReportParameter
RptParameters(0) = New Microsoft.Reporting.WebForms.ReportParameter("user", txtUserName1.Text)
...
RptParameters(7) = New Microsoft.Reporting.WebForms.ReportParameter("enddate", txtEndDate.Text)
ReportViewer1.ServerReport.SetParameters(RptParameters)
...

Author Comment

by:mmtcunningham1

ID: 349545512011-02-22

This worked for me.
Dim RptParameters(7) As Microsoft.Reporting.WebForms.ReportParameter

LVL 59

Expert Comment

by:HainKurt

ID: 349545842011-02-22

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("ReportMonth", "12", False))
paramList.Add(New ReportParameter("ReportYear", "2003", False))
ReportViewer1.ServerReport.SetParameters(paramList)

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)

Open in new window

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Reduce the Page size Asp.Net

Article by: Kumaraswamy

Problem Hi all, While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular. If your ASP.NET page …

ASP.NET

Implementing Data Bars In A Grouped Table

Article by: ValentinoV

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2. In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…

SSRS

How to scan a network for running services?

Video by: AdRem

In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

[Webinar] How Hackers Steal Your Credentials and Why Active Directory Must be Secure to Stop Them

Video by: Experts Exchange

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…