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

All Forums  Development Tools  Reporting Services Development  Basic Matrix and Grouping Question

Author  Topic  ballison Starting Member 1 Post Posted - 2006-04-12 : 10:15:01 This is my first project working with Reporting Services and I don't have any technical background. I'm trying to build a Matrix showing; |Payment Date| |Invoice Date| |Sum of Payment| I want it to group by mm/yyyy or yyyy/mm Currently it is showing d/m/y. I tried Format (Invoice Date, "yyyy/mm"), under group edit, but that resulted in only earliest date showing. I have two Reporting Services book, a training manual, and have reviewed the MS Online books. Unfortunately I think my lack of experience with this is making it difficult for me to find the solution. Thank you