Share via

Why SSRS parameter when selecting all it does not show but the values are all selected

PhillipK 121 Reputation points
Oct 14, 2022, 3:44 PM

When I select the Parameters to ALL values. It does not show on the textbox but the dropdown shows it

250583-image.png

250594-image.png

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.
2,993 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,601 Reputation points
    Oct 17, 2022, 2:16 AM

    Hi @PhillipK ,
    The drop-down list has a numeric value that only indicates that you created the parameter and assigned values to it.
    However, if the report cannot be displayed when the parameter is selected, you need to consider whether filtering has been added to the dataset query.
    You can add Filters to a dataset or use the following Where clause in a dataset query:

    WHERE Production.ProductInventory.ProductID IN (@ProductID)  
    

    see more: Add a multi-value parameter to a paginated report.

    Also, confirm that you created any Tablix or text boxes or charts instead of blank reports.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    0 comments No comments

Your answer

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