SSRS indicator sizing

Question

enter image description here

When adding an indicator to a report as per the image, is it possible to have all the indicators the same size regardless of the cell size (so centre them all rather than stretching to fill the cell)

I'll try to find time to test this today, but I think the trick is to place the indicator in a rectangle. — Jamie F, Mar 23 '12 at 14:12
I have done it this way for now, but the rectangle is akward to position and can lead to the boxes being too large thus ruining the look of the report. It would be good if you could tell the indicator to both horizontal and vertial allign (as you can with text) to keep all the indicators the same size. — JsonStatham, Mar 23 '12 at 14:54

score 9 · Accepted Answer · answered Mar 24 '12 at 03:28

Use rectangles within the cells of the table: within these, objects can be easily sized to not take full height or width.

Yes, sizing the rectangles and their contents can be annoying. I don't try to do much of this with the mouse, I quickly fall back to the properties window where I can type position and size.

score 0 · Answer 2 · answered Jun 02 '13 at 10:28

0

try clicking on the indicator area (default name ie GaugeReportItem) within GaugePanel. You will get Size and position in Properties on the right hand side where you can choose AutoLayout. This will in effect center and resize gauges based on the cell width, height and your settings.

Hope it helps.

answered Jun 02 '13 at 10:28

Alex

1

2

No, he didn't want to re-size based on cell width, rather he wants fixed size of the indicator. – shibli049 Jun 02 '13 at 10:52

score 0 · Answer 3 · answered Jul 06 '17 at 09:45

Exporting SSRS report to Excel did not go as expected.

Report with indicators in rectangles exported to Excel was randomly adding 0 height rows between the records which was not what I wanted. My indicators where simple green ticks and red crosses, based on true false. I have tried everything I found out there, even a subreport for indicator. No luck...

Figured it out that the indicators randomly outgrows the parent item when you export it, just like a chart. Ended up with saving a tick and a cross as an image. Then used an image control(with fit proportional set) and embedded Image with conditional statement to pick specific image. Also added some padding not to overlap borders.

The only problem I could think of is if the background of the report is not white as I could not change the background color of the cell the Image is and there is no option for the Image background.

Hope this helps someone else.

SSRS indicator sizing

3 Answers3