locked
RSViewerPage.aspx and POST RRS feed

  • Question

  • Hi guys,

    i am currently working on a solution that calls reports running in a SharePoint-Integrated SSRS from an external application
    therefore i built a HTML form where users can select some parameters and then pass them to the SSRS report
    to do this i am using the RSViewerPage.aspx and the relative path the the report (similar as if you would click on the report in MOSS)
    http://localhost/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/test.rdl

    the problem is, that some of these selections may be very big and exceed Internet Explorers URL length limit of 4000 (or 2000) characters

    so i switched the HTML form's method to POST instead of GET so the parameters do not get passed in the URL to avoid the url length limit

    i know that, if i am using ReportViewer, i have to prefix the parameters with "rp:"
    this also works fine when using GET

    unfortunatelly it does not work when using POST
    i also tried other or no prefix but none of them seemed to work

    here is a simplified example of my HTML form:

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <title></title>
    </head>
    <body>
    <form id="form1" runat="server" target="_blank" method="post" action="http://localhost/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/test.rdl">
     <input type="text" style="width: 250pt;" name="rp:Zeit" value="[Date].[Calendar].[Calendar Year].&[2006]"/>
            <input type ="submit" />      
        </form>
    </body>
    </html>

    as i said, a call like below works just fine
    http://localhost/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/test.rdl&rp:Zeit=[Date].[Calendar].[Calendar Year].%26[2006]

    does RSViewer.aspx even support parameters being passed using POST?
    if yes, what has to be considered?

    any help is kindly appreciated

    kind regards,
    gerhard


    - www.pmOne.com -
    Friday, November 4, 2011 7:45 AM

Answers

All replies

  • You can use HTML viewer except Report Viewer. you have any issues to use HTML viewer ? check this out .
    http://altecnotes.wordpress.com/2011/11/03/passing-parameters-to-ssrs-report-using-url/
    Friday, November 4, 2011 11:23 AM
  • Hi Anush87,

    first of all thank you for your answer

    I know that i could use the HTML viewer from the Reporting Services WebService
    but I have problems with authenication when connection to the ReportServer directly and not via SharePoint

    thats why i need to use RSViewerPage.aspx as this page is accessible by all users that have access to SharePoint

     

     


    - www.pmOne.com -
    Friday, November 4, 2011 4:02 PM
  • anyone?
    - www.pmOne.com -
    Monday, November 7, 2011 4:51 PM
  • RSViewerPage.aspx only reads parameters from the URL query.  It does not read any values from the form, which is where the parameters would be on a POST, so it doesn't look like you can use RSViewerPage.aspx for your scenario.

    You could consider creating your own aspx page in SharePoint, similar to RSViewerPage, that does accept parameters from the form.  Your page would contain the Report Viewer web part and set incoming parameter values on the web part's OverrideParameters property.

    ReportViewerWebPart:
    http://msdn.microsoft.com/en-us/library/ff492403(v=SQL.105).aspx

    ReportViewerWebPart.OverrideParameters:
    http://msdn.microsoft.com/en-us/library/microsoft.reportingservices.sharepoint.ui.webparts.reportviewerwebpart.overrideparameters.aspx 

    • Proposed as answer by Sharp Wang Tuesday, November 8, 2011 2:28 AM
    • Marked as answer by Gerhard BruecklMVP Tuesday, November 8, 2011 9:02 PM
    Monday, November 7, 2011 9:39 PM
  • RSViewerPage.aspx only reads parameters from the URL query.  It does not read any values from the form, which is where the parameters would be on a POST, so it doesn't look like you can use RSViewerPage.aspx for your scenario.

    that's want I wanted to clarify - so out of the box it is not possible to pass parameters using POST

    I am aware that i could write my own .aspx-page and user OverrrideParameters property but i was hoping that it could be accomplished with using only built-in MOSS and/or SSRS features

    thanks for the clarification!

    kind regards,
    gerhard


    - www.pmOne.com -
    Tuesday, November 8, 2011 9:02 PM
  •   

    Hi Gerhard,

    Can we edit the RSViewerPage.aspx  existing page ? if yes from where we can get this page and edit its webpart?

    Actually i am facing one problem-

    We host SSRS reports in sharepoint site for MSPS 2010(microsoft project server).

    when we run the report and expands the last parameter drop down to select the values(multi select parameter) all the values are not visible as those values get trimmed when they go below the web browser. I am using IE8. Ideally the scroll bar should get adjusted so that the page can be scrolled down to see all the parameter values but scroll bar doesn't get expanded.

    Please suggest me how to adjust UI of sharepoint page or any config change at report level.

    Thanks in advance :)



    Sushant

    Friday, February 1, 2013 1:17 PM