I wrote a blog about this when using dynamic SQL Server queries that may help. Also there were several comments at the bottom of the blog that offered alternatives...

If you have the enterprise version you can use data driven subscriptions using one report with 3 subscriptions.

For yesterday your data driven subscription would be something like

SELECT DATEDIFF(dd,-1,GetDate()) AS FromDate,...

palandrome

You could have the dba set up some data models for the analyst and then give the analyst Report Builder.

As Sean points out, I think you just need to change "day" to "d"

I don't understand how you are doing your Average. DateDiff only returns a single number, and...

Here is a different approach. It looks to me like your case table should be an accumulating snapshot fact table. There were several articles on this just recently...

Whether you use the OnError, or redirect in the data flow, your net effect is the same.

Forgive me because I don't usually handle errors this way but if you want...

In loose terms

SWITCH(Fields!ProfileCount.Value > 1, 'Red",Fields!ProfileCount.Value = 1,"Yellow",1=1,"White")

I did not check to see if these are all valid colors. Also you would have to use this at the group...

renew

I suppose if you want to expose all the detail data rather than my solution above, you could add a grouping at the customer level and then Count the detail...

I would just make my dataset query like this:

SELECT [customerid]

,COUNT([profileid]) AS ProfileCount

FROM [match]

GROUP BY [customerid]

Then just base your color expression off of the value...

Two primary reasons. First, to help others through common difficulties we have all had to face at one time or another. Second, frequently I learn subtleties about something...

I would think you could just do this:

=YEAR(Fields!StartDate.value) + " " + MONTHNAME(MONTH(Fields!StartDate.value))

Are you getting an actual error, or are you getting the wrong result? What is the error you are getting?

I would say yes, but it is also generally a good idea to maintain whatever natural keys there are that can join those three rows in the first place. ...