Handling Multi-Value Parameters with Optional Blanks in Microsoft Report Builder
Hi everyone, I'm working in Microsoft Report Builder and have a report with multiple parameters, including multi-value parameters. I want to ensure that when one parameter is left blank, it doesn't affect the results or cause issues with the other parameters. Here are my specific requirements: Users can leave a parameter blank without it influencing the query or results. If a parameter is selected, it should filter the results accordingly. I'm working with multi-value parameters, so I need to handle cases where users can choose multiple values or leave it blank. Has anyone encountered a similar issue or can suggest a solution to handle multi-value parameters with optional blanks in Microsoft Report Builder? Thanks in advance for your help! I try: AND object_key IN(:object_key) - It works but can't left blank object_key AND object_key IN (:object_key) OR :object_key IS NULL OR :object_key = '' - it can left blank object_key but can't choose multi-values. From Options: Data_type (TEXT), Allow blank value (""), Allow multiple values