Hi,

I'm using ReportViewer control to show report on a page. Report has one parameter. Report succesfully generated by clicking on control's "Report View" button.

However, i want to generate report automaticaly with predefined parameter on page load, but the code below does not generate report:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      
        Dim objParameter1 As ReportParameter
        objParameter1 = New ReportParameter("Status", "A, C")
        Dim paramList As New Generic.List(Of ReportParameter)
        paramList.Add(objParameter1) 
        Me.ReportViewer1.ServerReport.SetParameters(paramList)
        Me.ReportViewer1.ServerReport.Refresh()
END Sub

Seems that i miss function that actually generates report.

All replies appreciated

Thanks! 

lastoneleft:

Hi,

I'm using ReportViewer control to show report on a page. Report has one parameter. Report succesfully generated by clicking on control's "Report View" button.

However, i want to generate report automaticaly with predefined parameter on page load, but the code below does not generate report:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      
        Dim objParameter1 As ReportParameter
        objParameter1 = New ReportParameter("Status", "A, C")
        Dim paramList As New Generic.List(Of ReportParameter)
        paramList.Add(objParameter1) 
        Me.ReportViewer1.ServerReport.SetParameters(paramList)
        Me.ReportViewer1.ServerReport.Refresh()
END Sub

 

Seems that i miss function that actually generates report.

All replies appreciated

Thanks! 

  

Hi, your code looks ok. It works on my web site.

Alexei Cioina.

http://www.californiadreamhomesandland.com/Pages/ReportExplorer.aspx?ItmPath_25B7ED104E83=/English/Web%20Master/Web%20Site%20Statistics

I've just added ReportViewer1.ServerReport.Render function and it works for now!

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim objParameter1 As ReportParameter
        objParameter1 = New ReportParameter("Status", "A, C")
        Dim paramList As New Generic.List(Of ReportParameter)
        paramList.Add(objParameter1)
        Me.ReportViewer1.ServerReport.SetParameters(paramList)

        Dim warnings As Warning() = Nothing
        Dim streamids As String() = Nothing
        Dim mimeType As String = Nothing
        Dim encoding As String = NothingDim extension As String = NothingDim bytes As Byte()
        bytes = ReportViewer1.ServerReport.Render("PDF", Nothing, mimeType, encoding, extension, streamids, warnings)

        Me.ReportViewer1.ServerReport.Refresh()
END Sub

However this behaviour seems not obvious for me 'cause i suppposed ReportViewer1.ServerReport.Render to be used only when report data in bites form required, but in my case i do not need report bytes and i don't use them, but

it affects on whether or not report generated on the page:

bytes = ReportViewer1.ServerReport.Render("PDF", Nothing, mimeType, encoding, extension, streamids, warnings)

???