locked
Drill Downs Not Working In ReportViewer RRS feed

  • Question

  • User951945299 posted

    Loading report from SSRS into Reportviewer with following code.  Report loads fine but drill downs do not work. 

    Found some info that SESSIONID is changing on the server....supposedly if you hard code a SessionID on the URL this will fix the problem.  I haven't been able to find syntax to do this in code below.

    Also if you put the REPORTSERVERURL and REPORTPATH in the REPORTVIEWER settings it works with no problems...only doesn't work from code.  But I need to work from code, especially if I want to pass parameters.

    ANy Ideas?  Seems to be a pretty common problem but no answer so far.

    Dim reportServerURL As String= "http://vm-sql/ReportServer_RRCUSQL"

    Dim reportPath As String= "/WebServers/WebServers"

    With Me.ReportViewer1

    .ProcessingMode =ProcessingMode.Remote

    With .ServerReport

    .ReportServerUrl = New Uri(reportServerURL)

    .ReportPath = reportPath

    End With

    .ShowParameterPrompts = False

    .ShowPromptAreaButton = False

    Me.ReportViewer1.ServerReport.Refresh()

    End With

    Monday, June 20, 2011 3:10 PM

Answers

  • User951945299 posted

    Just figured it out...obvious as the nose on my face.

    Change the last line to

    If NotIsPostBack Then

    Me.ReportViewer1.ServerReport.Refresh()

    End If

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 3:36 PM

All replies

  • User951945299 posted

    Just figured it out...obvious as the nose on my face.

    Change the last line to

    If NotIsPostBack Then

    Me.ReportViewer1.ServerReport.Refresh()

    End If

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 3:36 PM
  • User1471008070 posted

    I’m glad to hear that you resolve this issue. Thank you for sharing your solutions and experience here. I will mark it as answer. It will be very beneficial for other community members who have similar questions.

    Wednesday, June 22, 2011 2:20 AM