 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / July 2008Row Headings in Matrix
Hi I have designed a Matrix in SSRS and I cannot seem to find any way in which to insert row headings. Column headings are fine and have been added automatically, but for some reason Row headings are not inserted by default - which is odd, since matric reports designed by Report Builder, via Report Models seem to have row headings. Is there someone out there who can advise how this can be done, since I have looked for hours on the internet and cannot find anything. Kind regards Ricky Hello RickyP, I did this before, but sadly enough cannot really remember how, but this might help you along: - Right-click on your matrix and select "Properties" from the menu - Open the "Groups" tab There you should be able to insert your required data. Greets, Stitch10925 ------------- > Hi > [quoted text clipped - 10 lines] > > Ricky I tried looking in this area, but there is nothing there that is relevant to adding in row headings.... Could you elaborate any further? > Hello RickyP, > [quoted text clipped - 30 lines] >> >> Ricky I am not too sure what it is you really want. Do you just want to add a header, add a dynamic row or add static content? Could you maybe give an example of what you want your matrix to look like? > I tried looking in this area, but there is nothing there that is relevant to > adding in row headings.... [quoted text clipped - 34 lines] > >> > >> Ricky Hi Stitch Thanks for getting back to me. Essentially I am after a matrix that has column and row headings. the Column headings are okay, but for some reason I cannot get Row headings up. E.g Salary Name Age Paul 21 100 Richard 30 200 As seen in the example above I can get the "Salary" title to appear on the Martix, but not the "Name" and "Age" headings to appear. Kind regards Ricky >I am not too sure what it is you really want. Do you just want to add a > header, add a dynamic row or add static content? [quoted text clipped - 43 lines] >> >> >> >> Ricky Hey RockyP, You are going about this the wrong way if I understand you correctly. The matrix is not suitable for what you need to do because it dynamically loads the rows AND the columns from the data you put into it. In other words, you can't create static column titles. For your case I would suggest using a table. You can then add the headers (columns) you need and load the rows with the information dynamically. This will give you the headers/columns (Name, Age, Salary) with the data automatically loaded in the rows below them. Hope this helps. Sincerely, Stitch10925 --- > Hi Stitch > [quoted text clipped - 62 lines] > >> >> > >> >> Ricky Hey Stitch Thanks for your reply, but this works in Report Builder reports, based off Report Models, I don't see why Report Designer can't do this? Ricky > Hey RockyP, > [quoted text clipped - 92 lines] >> >> >> >> >> >> Ricky Hello RickyP, After finally having to work with Matrixes again I now finally understand what you were trying to tell me! (Sorry for that). So, I am actually trying to find a solution for the same problem you are having, if I find something I will let you know. Stitch10925 -------- > Hey Stitch > [quoted text clipped - 99 lines] > >> >> >> > >> >> >> Ricky Hey Stitch Thanks for your reply, I have kinda got around it, although it's kind of crude in the approach. One way is to create a Matrix in report builder and then open it in Report Designer and then strip out all references to the model and replace with your own data set. The other alternative is to create a container and embed multiple text boxes in the matrix, with each corresponding column, although lining up the columns headings to their respective data columns is very time consuming. kind regards ricky > Hello RickyP, > [quoted text clipped - 120 lines] >> >> >> >> >> >> >> >> Ricky |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.