SSRS 2008 Matrix Report

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?
J CAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
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
 
Kent DyerIT Security Analyst SeniorCommented:
Are the additional tasks in your query?  If they are, you should be able to hide those results unless data is presented.
0
 
ValentinoVBI ConsultantCommented:
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
 
J CAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.