Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Passing parameters dinamically to Reporting Services report


Passing parameters dinamically to Reporting Services report

Author
Message
Kusno
Kusno
Forum God
Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)Forum God (1.9K reputation)

Group: Forum Members
Posts: 6, Visits: 11
Dear all .Netters,
In my report, I have 3 parametes(Par1,Par2,Par3).
In this case, I only want to give parameter only for Par1,Par2.
I set Par3 as interal and hidden parameter.
In my webform, I write these code :

ReportViewer1.ProcessingMode = ProcessingMode.Local

Dim rep As LocalReport = ReportViewer1.LocalReport
rep.ReportPath = "RptProductPhoto.rdlc"

Dim I As Byte
Dim GetParameter As String = ""
Dim TotalParameter As Byte
TotalParameter = rep.GetParameters.Count
Dim par(TotalParameter - 1) As Microsoft.Reporting.WebForms.ReportParameter
For I = 0 To rep.GetParameters.Count - 1
    GetParameter = rep.GetParameters.Item(I).Name
    Select Case LCase(GetParameter)
         Case "par1"
              par(I) = New Microsoft.Reporting.WebForms.ReportParameter(GetParameter, "Par1")
         Case "par2"
              par(I) = New Microsoft.Reporting.WebForms.ReportParameter(GetParameter, "Par2")
     End Select
Next
rep.SetParameters(par)

The program yields an error.
"Value cannot be null." reffering to "rep.SetParameters(par)" line code.

So, what should I do to remove the error ?

Thanks,

Kusno

Hanzie53
Hanzie53
Supreme Being
Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)Supreme Being (299 reputation)

Group: Forum Members
Posts: 1, Visits: 2
Hi,



When creating the parameters in the report designers you can set then to allow or disallow empty values.



Best regards,



Hanzie
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search