Good question. Thanks Steve.

I would do this with a CASE statment in the SQL query, something like:

CASE WHEN EmpLevel IN ('Non Pmnt', 'Exclusions') THEN 'Temp' ELSE 'Regular' END AS EmployeeType

and then create a...

Oops, I choose (in my mind) the correct answer, and clicked with my, evidently uncoordinated hand, the incorrect choice and hit submit.

Regardless of my shortcomings (a.k.a. excuses), good...

Are you attempting this using the SSIS Import and Export Wizard under the Project menu item of BIDS?

Good question, thanks!

Give this article a read.

Does it work if you deploy the report to the report server?

Elizabeth,

When you say "appear on the next line", are you referring to the next parameter, or is the customer number going to be in the header along with the name?

I could be wrong, but I can't imagine Microsoft has any vested interest in or requirement to be browser agnostic with regard to out of the box install of SSRS....

Developer.

I would probably use the merge join to pull all the records into a staging table and then do additional manipulations via creating a view, etc.

What is the error specifically saying?

Check the Auditor field for missing values.

Depends on how much you want to pay. Any other version of SQL Server should work for you.

Thanks! Good one.