I would probably bring all the data down into Access and index the tables -- after you have all the data. Then build your query there. When you're...

One option is to do this with a windowing function, like this:

SELECT ProductID

, Sales

, SUM(Sales) OVER (ORDER BY Sales

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) AS RunningTotal

FROM (SELECT 1 AS ProductID,...

Exercise your GoogleFu... There are examples all over the place, especially on the MS website...

http://msdn.microsoft.com/en-us/library/ms190307.aspx

See example B.

I'm still confused. Are you changing the backcolor of your cell with that? Otherwise, I'm afraid your approach doesn't make sense to me.

Something like this in the BackgroundColor...

I'm confused. When I put an indicator into my report, it gives me ranges for Red, Yellow, Green. I tried a couple to see if I could recreate...

What version of SQL Server are you using? If you're using 2012, you could use something like this as the source for your dataset:

SELECT

custID

,OrderID

,OrderDate

,LAG(OrderDate) OVER (PARTITION BY custID ORDER...

If you use windowing functions, this isn't that hard. Since I didn't understand how the create table/insert statements were related to your question, this is a somewhat generic answer.

It...

Seems you would do that in Excel... nothing to do with SSRS.

You might be able to do this by using a Tally table. Jeff Moden has a great article on it.

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

Itzik Ben-Gan's book on Window functions is good.

SELECT FORMAT(2504,'0000000');

Looks like this works:

SELECT EmployeeID

, MIN(CoverageCode1) AS CC1

, MIN(CoverageDate1) AS CD1

, MIN(CoverageCode2) AS CC2

, MIN(CoverageDate2) AS CD2

FROM vwCoverage

GROUP BY EmployeeID;

you would point to the calculated date if you wanted to do date calculations, comparisons etc. The 20040201 looks like a date (to you, not to SQL Server), so...

What are you trying to do with your SQL statement?

Definitely a case where some sample data would go a long way.

That said, I think you could use a UNION query to get what you want.