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