?
Solved

SSRS 2008 Matrix Report

Posted on 2013-12-10
4
Medium Priority
?
771 Views
Last Modified: 2013-12-19
I have a matrix report that I've built. The column header is the Day of the month and in the detail section I am showing the tasks that are scheduled to be completed on that day. Right now the query only returns the first task and does not display the rest in the detail section. I have it grouped by job. Is there a way to display the additional tasks without using subreports?
0
Comment
Question by:J C
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 39710725
Are the additional tasks in your query?  If they are, you should be able to hide those results unless data is presented.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39710739
Could you post an example (using non-sensitive data) of what you see now and what you'd like to see?  It helps us to better understand your problem...
0
 

Author Comment

by:J C
ID: 39711723
Thank you very much for both of your responses. I kept fiddling with it and was able to get it to work (mostly). I had to insert a table into where the detail was which allowed for multiple values to be returned.

The issue I am encountering now is that my column headers in the matrix which are my Dates/Days of the week are out of order. Is there a way to sort those so that it arranges them by date? Attached is a screenshot show you what I am running into.

You'll see 1/1 through 1/8 before you hit 12/11
ss.png
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 39713488
I had to insert a table into where the detail was which allowed for multiple values to be returned.

^^ That makes sense.

The issue I am encountering now is that my column headers in the matrix which are my Dates/Days of the week are out of order.

That's happening because the sorting is using the string representation of the date instead of the date value.  You'll need to look into the Sorting page of the Column Group properties and ensure a real date/datetime field is getting used there.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question