Adding Rectangle to Table Cell to prevent Indicator Stretching Cause Filtering Problem

Question

Hi,

Unfortunately, I found myself having to use Microsoft product (SSRS) that seems to be in freeze mode in terms of development , bug fixes and enhancements to find myself facing a bug that fits criteria of what to expect out of Microsoft.

My issue I think started when I wanted to push the product a bit further in terms of features - I guess I should have sticked to basic with Microsoft - So I wanted to Indicators which has been available for a while . Everything worked good initially and the indicator did what they were suppose to do , however when the table row stretches vertically to accommodate some long text in one of the cells the indicator icon stretches and looks ugly:

So I looked through the different forums and felt a lot of suffering of trying to come up with hacks and workaround to overcome problem that should not have been a problem to begin with but thanks to Microsoft its. One of the solution suggested to drop the indicator in a rectangle since ( not sure why) and drop the rectangle in the cell so after spending many hours trying to adjust boundaries, border colors and sizes because things did not sit well in the cell i got it to work and its not stretching any more:

So I was happy that at least there is a way and it worked until I exported the report to excel and noticed that the filtering is not working properly where if you add a filter to the header and try to select something it will only show one record !!!!!!

Im

Im sure there are more values than 6 .

The funny thing If I remove the rectangle , the filtering works!!!!!!!

Something to make a note of is Im not using simple layout, its a matrix with the following layout:

the 3 hilighted cells are where the rectanlge\indicators are added and it has to have the rectangle added to all boxes for some reason for it to impact the filtering .

Things to note to Microsoft development team:

1- Why stretching is problem without solution until today. I know I have been running into this so many times before and everytime a hack like this might seem to fix the problem but since its hack it will cause others. There are many properties like AutoFit, CanGrow, Size , Scale that none of them seem to help or change anything.

2- I have been using visual studio and SSRS through out my career and I have gone from VS 2005 to now 2022 and when it comes to VS UI yes Microsoft did good job in coming up with nice labels and icons but when it comes to core things like project templates and layout its the same damn thing even same bugs , Till now if I click on a cell or an object to view its properties I cant even search the properties vs having to go through a long list to find what I want. I understand SSRS is no long priority and probably not much development going on but its still a Microsoft product that if someone uses it and ran into issues like this it will leave bad taste against all Microsoft products not just this one.

Answer 1

Hi @samer.alisaleh，

You may also raise the issue here.

Share your suggestions with the SQL Server product team and they will help deal with it.

Regards，

Zoe Hui

---

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