SSRS Indicator Size

Question

When adding an indicator to the report in accordance with the image, is it possible to have all indicators of the same size regardless of the size of the cell (to center them all, and not stretch to fill the cell)

Answer 1

Use rectangles inside the cells of the table: inside them, objects can be easily sorted so as not to have a full height or width.

Yes, the size of the rectangles and their contents can be annoying. I am not trying to do most of this with the mouse, I quickly return to the properties window, where I can type position and size.

Answer 2

try clicking on the indicator area (default name, i.e. GaugeReportItem) within the GaugePanel. You will get the size and position in the properties on the right side, where you can select AutoLayout. This will actually center and resize the sensors based on the width, height and settings of the cell.

Hope this helps.

Answer 3

Exporting an SSRS report to Excel did not work properly.

A report with indicators in rectangles exported to Excel randomly added 0 height lines between records that were not what I wanted. My indicators are simple green ticks and red crosses based on true false. I tried everything I found there, even counting for the indicator. Bad luck...

It turned out that the indicators will randomly outgrow the parent element when it is exported, just like a chart. The preservation of the tick and cross as an image has ended. Then, image control (with an appropriate proportional set) and an embedded image with a conditional expression were used to select a specific image. An addition has also been added so as not to overlap the borders.

The only problem I could think of is that the background of the report is not white, because I could not change the background color of the cell where the image is located, and there is no background for the image.

Hope this helps someone else.