locked
Filter drop downs in SQL Report Viewer webpart RRS feed

  • Question

  • Is there a way to position parameter filter dropdowns on a SQL report viewed through the SQL Report viewer webpart.

    Right now it is on left in a parameters pane

    I currently get to report builder from SharePoint's UI by using link Open in Report Builder.

    Thursday, July 25, 2019 2:29 PM

All replies

  • Hi 2013Sharepoint

    What the detailed ssrs version and the report builder version are you using.

    Seems the parameter location could not be changed in the version before ssrs 2008 r2.

    If you want to change the parameter location in report builder ,see:

    If above not meet your requirement, you could try to offer more detailed information to us for more further research .

    Hope it can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Friday, July 26, 2019 1:50 AM
  • That does look easy

    What about once the report in the Sql Report Viewer webpart within SharePoint.

    Do the filters still stay at top or do you get the Parameter pane on the left

    Friday, July 26, 2019 8:47 PM
  • Hi

    According to your description , if you want to change the report parameter location in sharepoint web page .

    Seems it is more related to the sharepoint scope , you need try to check different layout  or different type of web part.

    See: SharePoint SSRS Integrated Report Move parameters on the top & More

    You could also try to offer this issue in share point forum for more other aspect help.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    • Proposed as answer by Mitarai Queen Wednesday, July 31, 2019 2:35 AM
    Monday, July 29, 2019 5:56 AM