SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

osupratt
Posting Yak Master

233 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
equip
truck1

truck8
truck2

truck9

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.

visakh16
Very Important crosS Applying yaK Herder

India
52309 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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

osupratt
Posting Yak Master

233 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000