If you really mean the current year as in YEAR(GETDATE()), then

=YEAR(Today())-1 is last year: 2013

=YEAR(Today())-2 is two years ago: 2012

It's a tablix on the outside (for the years) with a matrix inside (for the Totals by month for a single year). Because several years are in the...

In a word, use DATEADD().

for example...

=DateAdd("d",3,Today)

I can try to attach this thing... the fun part is that I had to do some voodoo to get all the dates to show up. Here's the query...

What does your dataset look like? Could you post some dummy data? Hate to push you into the deep end in your first lesson, but here goes... This is...

Nice job posting DDL and sample data! How do you determine which rows are/are not the Current Edition? Once we have that, the rest of this should be...

I got the matrix working pretty quickly doing it as a subreport. Of course that means performance won't be great, but one step at a time, I guess. ...

you need a matrix. You might want to use the Wizard to get the setup started. If you select Add New Report, in SSRS, it starts the Report...

I think I did it right...

Here's my dummy data:

SELECT '0' AS TType,'1' AS IDNo,'2013-10-22' AS MoveInDate,'10' AS MonthNo,'2013' AS MoveYear UNION ALL

SELECT '1','2','2013-09-09','9','2013' UNION ALL

SELECT '0','3','2014-05-13','5','2014' UNION ALL

SELECT '0','4','2013-12-19','12','2013'...

You would have to deal with the non-dummy dates first. (Or if you can do it with a join?)

Then you could just use something like

UPDATE <tablename>

SET someDate = '01-01-1900'

WHERE...

I would do it with a Calendar table. Then you can query for Mondays within your date range and then do the insert.

Here's a link:

http://www.sqlservercentral.com/articles/T-SQL/70482/

You're missing the DelimitedSplit8K function, which is here[/url]. If you read all the way to the bottom, the code is in one of the downloads at the bottom of...

Is this a test database where you need to just generate a bunch of random records? Jeff Moden has an article or two on it I'm sure. Chris...

Is SSRS 2012 pretty much the same (in terms of setup procedure) as SSRS 2008? I know that there are good videos and information on that. Have not seen...

Thanks for the feedback/response. I was thinking about checking out Paul Turley's book. (Getting harder now that brick & mortar bookstores are pretty much a thing of the...