Share via

How do i disabled ssrs parameters panel scroll

Chew, Farn Jie (uia58396) 21 Reputation points
2020-12-10T14:34:20.993+00:00

Hi, All

I have a ssrs 2016 report have many parameters. I need to disabled the scroll of the parameter panel so that all my parameter display without scroll or increase height of parameter panel . How should i do so

46914-image.png

Regards,
Jack

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments

Answer accepted by question author

ZoeHui-MSFT 41,551 Reputation points
2020-12-14T07:33:57.547+00:00

Hi @Chew, Farn Jie (uia58396) ,

Sorry for my misunderstand for your issue at the beginning.

When we are designing the report in report builder, we could easily adjust the parameter panel.

However when we run the report on web, the parameter panel has a fixed height that we couldn't change. It is by design.

You could vote for the point or raise your needs on this forums.

https://feedback.azure.com/forums/908035-sql-server/suggestions/32909506-allow-ssrs-parameter-panel-to-be-formatted

If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Was this answer helpful?

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chew, Farn Jie (uia58396) 21 Reputation points
    2020-12-14T06:35:42.17+00:00

    Hi @ZoeHui-MSFT

    The issue is still not OK, let me share more screen shot
    where i already adjust my panel of parameter to the max
    47755-image.png

    but when i view in browser the parameter panel still cannot display all parameters and still need to scroll and my view of brower is set to 100%
    For your info, I am using sql server reporting 2019

    47756-image.png

    Regards
    Chew

    Was this answer helpful?

  2. ZoeHui-MSFT 41,551 Reputation points
    2020-12-11T02:48:46.72+00:00

    Hi @Chew, Farn Jie (uia58396) ,

    The image you attached is unavailable.

    Suppose that you want to adjust the area of parameter pane,if I misunderstand your needs,please incorrect me.

    There is a separation Line between the parameter pane and design pane.(in the design mode is the same)

    47224-screenshot-2020-12-11-104435.jpg

    You may drag and drop this line to adjust the parameter pane to increase the height.
    47233-screenshot-2020-12-11-104554.jpg

    More custom Parameters Pane settings, you may refer the official documentation.

    https://learn.microsoft.com/en-us/sql/reporting-services/report-design/customize-the-parameters-pane-in-a-report-report-builder?view=sql-server-ver15#to-customize-the-parameters-pane

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.