Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2014-04-11 : 10:42:57
|
| i haven't created a matrix report before. i have a equipment list that is by the equipment location. location as the column across the top and the equipment numbers as the row data going down the page. my problem is that the data in the rows for the first location might be 20 rows down the page and the second location might have equipment in the 10th or 15th row of the report. not easy to read at all. how do i get all the row data for all the locations to be under the column header and to show uniformly? location1 location2equip truck1 truck8 truck2 truck9 where it should like: location1 location2equip truck8 truck1 truck9 truck2i tried the visibility 'hide' on the row and the text box but that just 'whites' out the text box and is not what i'm looking for. any help would be greatly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-04-13 : 14:32:56
|
| As I understand you need to merge multiple row data and show location details in a single row. So in that case how do you want to show the associated equipment list? what does equip in sample data indicate? is it full equipment list?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2014-04-14 : 11:45:34
|
| i might not have described my problem properly. in my current matrix report for example i have in the first column location 'ABC'. in my first column i have equipment showing up in rows 9, 14, and 19. instead i want this equipment to show in rows 1,2, and 3. and i would like this for all of the columns to where the equipment on each location column starts at row 1 and then 2 and then so on. the matrix report seems scattered when viewing and is on multiple pages but if i can move all equipment to the top rows moving down on the page it is much more pleasing to the eye and i can fit it on one page. i hope this makes sense. |
|
|
|
|
|
|
Matrix - moving all row data to top