SSRS multiple text boxes in matrix header

Question

SSRS multiple text boxes in matrix header

Andy Bolk 10

I have a header row on a matrix that is outside of any of the groups. I would like to add 3 values in there and have one be left aligned, one center aligned and the other be right aligned. I can get a single value in there and align it however I want, but am not sure to add multiple values to a single cell. I have tried adding additional columns, but of course that causes the matrix to spill over to the next page.

Thanks for the help.

1 answer

Your answer

Answer 1

Anonymous

Hi @Andy Bolk

You can add a table in the matrix header row.

Then delete the data rows of the table, leaving the header row of the table. Add the values you want in the header row of the table and align them as you want.

Preview：

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Andy Bolk 10 Reputation points

2023-05-03T15:11:35.2266667+00:00

Unfortunately that does not work. After running the report it puts all 3 columns of the table crammed over on the left side.
Anonymous

2023-05-05T05:36:06.2766667+00:00

Hi @Andy Bolk

You mean there are not only header rows but also data rows, right? Then like you said, it might be a little better to add additional columns. If you are worried about the matrix overflowing to the next page, then you can adjust the width of the text box or the page size, margins, etc. to make the page large enough to hold the data.

Best regards,

Aniya

Share via

SSRS multiple text boxes in matrix header

1 answer

Your answer