Row Headings in a Matrix

Question

Row Headings in a Matrix

Carolyn-358394

SSC Enthusiast

Points: 149
More actions
August 21, 2006 at 5:59 pm

#172203

Hi,
i have a matrix which is made up of 3 Row fields and 1 Column field. I want to give each of the Row fields a static heading. How do i do this?
I have tried adding a text object and placing it over the matrix in my desired position, this looks fine in the preview, but when viewed through IE, the layout is all messed up.
Thanks, Carolyn
August 24, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Stuart Johnson Mr or Mrs. 500 Points: 522 More actions · Answer 1

You can type headings into the text box that the matrix has above the rows. The alignment is tricky but using trial and error you can type in a text string and spaces that will align reasonably well. It would be nice if they could build in something more graceful to allow headings in this very useful report control.

Stuart

David Wilson-361993 Grasshopper Points: 11 More actions · Answer 2

I came here looking for an elegant solution to this problem as well but it seems one might not exist just yet. What I've ended up doing is dropping a table into the top left cell of the matrix above the row groups. I then remove everything in the table bar the heading row (and create multiple heading rows if I need them). I can then create as many table columns as I need to match the matrix groups and type static headings in each table cell. Similar to Suart's concept but it allows me a little more control over cell widths and I can set them to match the matrix widths.

I usually create the same number of rows in the embedded table as there are column groups in the matrix. This way I can get the headings to appear just above the matrix column groups and use the right-most table cells to hold the lower level matrix "row group" headings if needed. Not elegant but it seems to work.

Dave

Carolyn-358394 SSC Enthusiast Points: 149 More actions · Answer 3

Thanks David, that worked!

You can't but text such as "hello how are you?" in a textbox. The report removes all the extra spaces when it prints it, eg. it'll get printed as "hello how are you?".