SSRS report - row heights

Question

SSRS report - row heights

mark goldin 696

I have a table which has another table in one of the columns. I am exporting the result into Excel. It might look like this:

User's image

As you can see the row with fault project 2 is smaller than the above one. That is happening because in the column with image I have rectangle with an image. If I would have an image directly in the column the problem won't be there. I am using the rectangle to avoid vertical cells merger in the column with the image. I am not getting merged cells, but I get a problem with the row height. Any idea what can be done?

mark goldin 696 Reputation points

2023-07-31T19:27:02.8133333+00:00

The problem is only seen in Excel.
william anderson 0 Reputation points

2023-07-31T22:54:01.1+00:00

To fix the issue with the row height, you can try adjusting the properties of the rectangle with the image. Experiment with the rectangle's size and positioning to ensure it aligns properly within the cell and doesn't cause the row height to shrink. You may also consider resizing the image to fit directly into the cell without using the rectangle. Additionally, check if there are any padding or margin settings affecting the row height and adjust them accordingly.
AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff

2023-08-03T08:23:36.9566667+00:00

Hi @mark goldin

Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya

1 answer

Your answer

mark goldin 696 Reputation points

2023-07-31T19:27:02.8133333+00:00

The problem is only seen in Excel.
william anderson 0 Reputation points

2023-07-31T22:54:01.1+00:00

To fix the issue with the row height, you can try adjusting the properties of the rectangle with the image. Experiment with the rectangle's size and positioning to ensure it aligns properly within the cell and doesn't cause the row height to shrink. You may also consider resizing the image to fit directly into the cell without using the rectangle. Additionally, check if there are any padding or margin settings affecting the row height and adjust them accordingly.
AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff

2023-08-03T08:23:36.9566667+00:00

Hi @mark goldin

Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya

Answer 1

AniyaTang-MSFT 12,451 Microsoft External Staff

Hi @mark goldin

I did simple test. I created a simple report like you said and when I first exported to Excel it did have the wrong row height.

Screenshot 2023-08-01 112800

From what I've researched, after setting both the CanGrow and CanShrink properties of all cells in the Tablix to false, row heights are working correctly.

Screenshot 2023-08-01 113053

Hope this can help you.

Best regards,

Aniyia

AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff

2023-08-02T06:11:29.1066667+00:00

Hi @mark goldin

Did the answer help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Share via

SSRS report - row heights

1 answer

Your answer