I think your only option is to do something like this:

IIF([State]='CA',NULL,[ValueColumn])

Are you doing this in T-SQL or in Reporting Services?

if you're using SSRS, use a Matrix. Otherwise, read this:

Using PIVOT and UNPIVOT

seeing that it will be around 1 AM, probably not. But if you post a simple description of what you're modeling and then your model (create table scripts with...

My problem is I do not know how to have the dataset call the stored procedure with the 3 parameter values and pass back the 5 different unique data values...

Output parameters are your friend:

http://technet.microsoft.com/en-us/library/ms187004(v=sql.105).aspx

Can you post a really brief description of what you're modeling and your table definitions on the part you're having trouble with? (start with only maybe two or three...

"You can get the job on the basis on your SQL certificate"... depends a lot on how big the pool of available SQL developers is in your area, I guess....

In the 2008 version, there's a whole chapter on Customizing Security.

Thanks SQLBuddy! Way to live up to your moniker! I'll check them out.

Are there any good tutorials online anywhere? I guess I'll see if there's anything on the MS website... or PragmaticWorks.

Okay, I'll have a look.

Pieter

Are you trying to create a crosstab of some type? Or are you trying to create something that looks like labels? Both are reasonably easy in SSRS.

You can...

Right-click on the CustomerName...

Grasshopper,

There's a really good article on referring to controls and their properties on the dying website AccessWeb, which is here: http://www.mvps.org/access. Look for an article by Keri Hardwick. ...

The usual way to do something like that is to do an outer join to the destination table and only insert the values that don't exist there already.