Drill Downs Not Working In ReportViewer

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

Answer 1

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

 

Answer 2

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.