I gave up on it and will recreate it the correct way. Thanx for your help.

I'm using Report Builder and don't see any dropdowns or how to open in xml.

Wonderful. I can't thank you enough.

I've attached the actual data. Thanx again for your help.

It returns records. I'm going to try the other approach, as you suggest.

There are 64K+ records. Mind if I attach a spreadsheet?

Here's the query. Basically, a copy of yours. I just changed #TEST to #T, the actual data. I also added the...

I was able to get correct results with the TEST data but, not my actual. When I sort using your select query, I get records for each month.

That's bizarre. Should it matter if there are LOSInMinutes=0?

My actual data has records from October, 2014 thru September, 2015. Our Fiscal Year. When I run the query I only get.............

(No column name)YearMonth

200.0000002014-12

216.0000002015-01

207.0000002015-04

196.0000002015-06

195.0000002015-08

199.0000002015-09

Oops. Not all of the YearMonths show up.

Thanx. Sorry about the data types and stuff.

This query runs fine when executing within SSRS but, times out when creating the fields for the report. Any thoughts? In SSMS the query takes 1 minute to run.

Thanx.

Wonderful. Thanx.

I do have access. Thanx.