cancel
Showing results for 
Search instead for 
Did you mean: 

Report Builder parameter search not working without (3) leading spaces

I noticed this while trying to do a parameter search on one of our paginated reports in the server. In our (raw) data, the available values in the parameter do not contain leading (or trailing) spaces.

 

Example: When searching for the term "ASEAN" (without leading spaces), no items returned:

02.png

 

Same keyword but with 3 leading spaces: "   ASEAN"

03.png

Status: New
Comments
v-chuncz-msft
Community Support

@olimilo 

 

I cannot reproduce the issue. Check the data souce again and create a support ticket for assistance if necessary.

 

olimilo
Post Patron

I was recently able to find a solution to this. In the Parameter Properties > Available Values, instead of using ParameterCaptionIndented as the Label field, you need to select ParameterValue as the Label field value:

 

2021-10-28 10_31_28-Report Parameter Properties.png

As to why ParameterIndentedValue is the default selection in this property, I would not know. I think it would be better to just have ParameterValue as the default selection instead.