pietlinden. not sure if you get me.

The trouble for me is within SSRS. I don't know how to get three identical tables working together in concert, but...

I agree "one thing at a time" and the most important part is the middle region where there are 3 tables for different years - all reporting by month/ sum...

move_date = datetime datatype (format 2013-08-27 00:00:00.000)

This expression works

=Year(Fields!move_date.Value)

but

this expression will not reduce the year by one:

=Year(Fields!move_date.Value)-1

I have also tried

Datepart("yyyy", Fields!move_date.Value) -1

also tried

=Parameters!year.Value - 1

how to build...

pietlinden, thankyou so much.

My dataset is already pulling in all the years but....not in date form.

What you've pointed out to me is that I need to...

doug.brown, you rock. Exactly right.

I've managed to do in SSRS what I've been asking to get help with.

The steps taken seem unconventional - nowhere did I find the directions to do it...

This link had the solution

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/535c7e0a-75e2-47d0-8b18-60d1e94805a2/setting-variable-parameters-in-a-ssrs-subscription

but the article/s totally gloss over how to do certain things, like when the last link says

"In a tablix data region, click in the table, matrix, or list to...

can you provide a step by step for pulling in a table item, adding three columns, and getting the group by the one column for the remaining two?

For me the...

will read and try, thanks

will try, thanks

I had to first de-aggregate the source values in the second dataset before I could pull them in. The expression that worked, once I did that, was

=Fields!U_SentLeads.Value, "UniqueLeadsQuery"....which...

I didn't find this worked for me.

SQLRunner,

Are you suggesting that my main problem is 'division by zero'?

At the bottom of my column of percentages I need the average of percentages.

I've tried

=AVG((Fields!To_Your_Store.Value+Fields!Lost_to_Competitors.Value)/Fields!TotalLeads.Value))

and result is 'Infinity'....

Hi KoldCoffee,

probably you need to update your TimeCol table, set IsProcessed column to 1 for datePart 2014-06-20.