Ok, I am thinking this through and it might work. Does it make a difference if the datetime is part of my PK? The key on my table is...

Yep, i get the same results in BIDS and the report server.

Very frustrating.

Interesting. See attached RDL for a similar layout to what i am working on. I did not apply any parameter filters in this test. The only filter is on...

I guess i will play it safe and change these to IS Nothing rather than = Nothing, even though it appears to work.

I also occasionally use LEN(Fields!FieldName.Value) > 0) in...

Here is some sample data:

IF OBJECT_ID('TempDB..#Agents','U') IS NOT NULL

DROP TABLE #Agents

CREATE TABLE #Agents (

EmployeeNumber [varchar](8) NOT NULL,

Location [varchar](10) NULL,

ClockDate [datetime] NOT NULL,

CONSTRAINT [PK_Agents] PRIMARY KEY CLUSTERED

(

[EmployeeNumber] ASC,

[ClockDate] ASC

)WITH...

Isn't SET DATEFIRST a sever wide setting?

We don't own the calendar table, so that is not really an option.

Anyway, my boss and I came up with this code as an option as well:

DECLARE @someDate as DATE...

A user on another forum suggested this:

DATEADD(dd,-DATEDIFF(dd,2, YourDateColumn)%7,CAST(YourDateColumn AS DATE))

DATEDIFF(dd,2,YourDateColumn) calculates the number of days between the value in YourDateColumn and the date represented by the number 2 - which...

So if I don't want to alter the contents of the SLHIH table directly, do I need to put the results of the query into a temp table and report...

I am still walking through these (have to work on something else this morning) but ChrisM, does this UPDATE actually update the SLHIH table, or does it just update the...

Ok, this is more than 10 records, but I wanted to be sure to cross a weekend and a holiday. I hope this is what you had in mind.

CREATE TABLE...

I certainly could. What would be the best way to do so? As an attachment?

Thank you very much for your patience and help, Sean. I really appreciate it.

So is a CTE kind of like a temp table to hold a dataset in table format?...

Well that burst my bubble. I have not given up on the suggestions you gave. I just don't understand them and cannot figure out how to make them worth with...

OK. Yeah, i thought about making that assumption as well. At this point I am not sure if that is a fair assumption though.

Here is what i have come up...