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  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Previous Month's Data

Author  Topic  kam321 Starting Member 1 Post Posted - 2009-03-23 : 13:48:17 Hello I have a report which is has a date parameter-- what I am trying to achieve is if I enter a month, say 01/1/2009 I want to return all of January's data along with December 2008 data. I have been using the dateAdd Function to give me the date, and it returns the previous month's name. What I cannot seem to accomplish is returning the previous month's data-- there is a column in the table called TTCFileDate which has data relating to the month (1/1/2009, 12/1/2008,11/1/2008, etc) so I thought that this would be a simple fix-- I'm finding it more difficult-- I have tried using both a table and a matrix and I only get the data for the month I enter. Any suggestions? thanks kam