This article couldn't be more timely for me.

Thanks!

No, I'm not doing that - at least I'm not intending to.

I need to pull all of the values from the table where the value of the field is not...

It goes into another dataset/query. It's part of the WHERE clause.

SELECT

stuff

FROM

tables

WHERE

criteria AND

table.ID IN (SELECT table.ID FROM table where table.name NOT IN (:InclCancel))

The...

Yes, I already checked to see if the value was being populated correctly. It is.

I'll check with someone else if they can find any glaring problems with the query,...

The values were manually created.

I've tried quotes & no quotes around the values. I've tried the following for the "No" values:

CANCELLED, INACTIVE

"CANCELLED", "INACTIVE"

"CANCELLED, INACTIVE"

"CANCELLED" & ", " & "INACTIVE"

Cstr("CANCELLED")...

In a perfect world, it would be great if everyone was able to choose the job that was perfect for them. However, this isn't a perfect world and the...

You can't export subreports directly to Excel in SSRS 2005, but you can do it in 2008.

My husband lost his job last November, just before Thanksgiving. Early this summer, he was asked to take a contract position with a company because one of their employees...

Yes, you've summarized my issue precisely. The problem with the current methodology is that in order for the dates to update when you select a different timeframe, I need...

Thanks for the link to the cleaner, easier date computations. I inherited the code & since it works, I was happy to leave it alone. 🙂

Thanks, but this won't work for me. I'm using the stored procedure to populate the dates in Reporting Services & having the NULLs doesn't allow the user to select...

Nevermind. I figured it out. I needed to add the dates to the Available Values as well as the Default Values. Strange solution but it appears to...