Easiest way to do it is to open the report in design view. Do you not have rights to do that?

My guess would be to create a PIVOT

This article walks you through it:

http://www.sqlservercentral.com/articles/pivot/62808/

Then once you have that, you should be able to append it to your destination table.

Can't you just publish it as a report part and reuse it that way?

If what you're intending is to "explode" the range (say 1/1/2014 to 6/1/2014), then the easiest way is probably using an auxiliary Tally table. (Mine is called "Numbers" for...

This worked... I changed a few field names, because they're reserved in T-SQL. Turns out this is a plain totals query.

SELECT Ticket, UserX, MIN(PriorityX)

FROM

(SELECT 'A' AS Ticket,

'ME' As...

Before trying to build a data warehouse, I would definitely recommend reading Ralph Kimball's book. I have a really old copy of The Data Warehouse Toolkit. There are...

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'...