This is going to be hard to describe, and I wish I had an instance of SQL Server handy so I could take your sample data and write some T-SQL...

My response was based on the following text from the original post:

"I need to use an MS Access database as my datasource to do some work on it to migrate...

Seems to me the way to apply the use of a calendar table will need to be based on the code for the absence, so two "views" of the calendar...

I don't have a SQL instance on which to test this, but it may be possible to do something along the following line:

;WITH C AS (

-- FILL IN ALL THE...

I'm not sure why anyone would mess with SSIS to migrate an Access db into SQL Server, as Microsoft has a FREE tool to do it called SQL Server Migration...

Given the level of angst on this topic, I wonder if perhaps using SSRS is really the right solution for a scenario with what amounts to a desire for "cascading"...

Check out HP's PolyServe... It might be exactly what you're management would like to have.

Steve

(aka sgmunson)

:-):-):-)

The very reason I got this one wrong was precisely because of posts here that described the "Qurky Update", and thus I was left with the idea that the SET...

Glad to be of service. I definitely enjoy it when I need help and while I find the problem myself, someone else helps me go in the right...

Post a screen-shot of your report in design mode - I presume you're using BIDS... Worst case you can zip up the RDL file for the report and...

Assuming you have your detail fields on the detail line, then the next critical step is to ensure that your data actually has a different group value for the grouping...

I'm thinking you have the fields set to display on the GROUP line as opposed to the detail line within the tablix... Take a closer look at your...

Merry Christmas indeed !!!

P.S. - your description of the nature of the problem has an acronym:

PEBKAC (Problem Exists Between Keyboard And Chair)

:-D:-D:-D

Steve

(aka sgmunson)

This working too close to a holiday has to stop... I must be going nuts... I discovered my problem was self-inflicted. I had...

How about adding a group that is based on a field that's unique within all records, and using that group to create a page break between each group? ...