Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Matrix - moving all row data to top
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

238 Posts

Posted - 04/11/2014 :  10:42:57  Show Profile  Reply with Quote
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 location2



where it should like:

location1 location2
equip truck8 truck1
truck9 truck2

i 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.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/13/2014 :  14:32:56  Show Profile  Reply with Quote
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 MVP
Go to Top of Page

Posting Yak Master

238 Posts

Posted - 04/14/2014 :  11:45:34  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000