none
Reports with parameter prompt in reportviewer not working RRS feed

  • Question

  •  

    We are having a proplem when implementing reports with parameter prompts in a reportviewer.
    The report and the parameter prompts are initially loaded correctly but when we select a value and click the View Report button, the report posts back but the selected parameters are ignored.
    The reports were created using the Report Builder with prompted filters.
    When the reports are viewed from the report server the reports works fine.

    Below is how we initialize the reportviewer on load:

      Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            ...
            rv_render.ServerReport.ReportServerUrl = New System.Uri(ConfigurationManager.AppSettings("report_server"))
            rv_render.ServerReport.ReportPath = ConfigurationManager.AppSettings("report_folder") + Request.QueryString("report")
            rv_render.ShowParameterPrompts = False
           
            rv_render.ServerReport.ReportPath = ConfigurationManager.AppSettings("udrReportFolder") + "/" + Request.QueryString("report")
            rv_render.ShowParameterPrompts = True
            rv_render.PromptAreaCollapsed = False
            rv_render.ServerReport.Refresh()
            ...
      End Sub

    Monday, October 6, 2008 5:27 AM

All replies