Create a calculated column in your dataset for the year.

YEAR(SomeDate)

Then you should be able to group no problem.

Do you understand the difference between an OLTP database structure and a DW database structure? Which part are you having trouble with? The star schema?

If you can get your hands on a copy, read a little of Ralph Kimball's Data Warehouse Toolkit

Sorry, I completely missed this. What you describe is exactly what I ended up doing. Lots of parameterized subreports that I could include in a "main" report. ...

I think I managed to reproduce your problem... and I think I solved it.

First off, some data to play with that I used as the data source for my report:

SELECT...

Oh, super cool! Guess I'll have to test and see if it is happy on Win7 or another non-Server OS.

Thanks!

Are you trying to create a single dataset to use in your report? If so, it looks like you can union the results together.

SELECT...

FROM v_SomeView

WHERE...

UNION ALL

SELECT...

FROM v_SomeOtherView

WHERE...

and then...

If you're using a Slowly Changing Dimension, and this is classwork, you might want to read up on them in Kimball's book. He explains how to do this in...

Probably should have done this with a CTE, but anyway, I think this works:

SELECT mx.SaleYear, mx.SaleWeek, mx.highestSale, sd.ProductID

FROM

(SELECT SaleYear

, SaleWeek

, MAX(Quantity) AS highestSale

FROM SalesData

GROUP BY SaleYear, SaleWeek) mx

INNER JOIN...

If you're using a normal database and not an SSAS cube, then you can use a Calendar table. Here's the article on it: http://www.sqlservercentral.com/articles/T-SQL/70482/

Basically, the Calendar table...

In a dataset that already exists within the ssrs 2008 r2 report I need execute

a stored procedure called StudentData and pass 3 parameter values to the stored procedure. The...

Yes, that's what I'm saying. I could be wrong, but I couldn't get it to work any other way. Would love an SSRS wizard to set me right.

No. do your own work. Read the article, try it, and post your SQL if you get stuck.

I think your only option is to do something like this:

IIF([State]='CA',NULL,[ValueColumn])

Are you doing this in T-SQL or in Reporting Services?

if you're using SSRS, use a Matrix. Otherwise, read this:

Using PIVOT and UNPIVOT