Report Builder only returning first value

Hi Userpath77 ,

Please try below steps:

1. Verify Parameter Configuration: Ensure that your parameter in the Report Builder is correctly set up to accept multiple values. This involves checking the parameter properties and ensuring the "Allow multiple values" option is selected.

2. Adjust Dataset Query: If your parameter is correctly set up to accept multiple values, the next step is to examine your dataset query. Ensure that it's designed to handle multiple values correctly. For SQL-based data sources, this often involves using the IN clause in your WHERE statement to filter based on multiple values. For example:

WHERE ProjectName IN (@ProjectParameter)

Replace @ProjectParameter with the actual name of your parameter. This syntax allows for filtering based on multiple selected values.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.