Glad to hear that localizing the lookup tables helped.

As for the lookups as joins, this is an intelligent guess at best, without knowing or having access to everything. As an...

The table size is smaller than I was expecting, so that's a good thing. I still think that turning those lookups into joins with local tables will help. For example,...

I'm confused why this blows up on you. We use hidden parameters quite frequently, for things like userid, etc., and also dynamically build the datasets of the other dropdowns based...

If I'm understanding you correctly, then sure (untested, so likely a logic error or two):

DECLARE

 @strSelectedCity  varchar(50)

SET

 @strSelectedCity = 'FairField'

SELECT

 XCode

 ,City

FROM

 City_Table

ORDER BY

 CASE WHEN City = @strSelectedCity THEN 0 ELSE 1 END

 ,XCode

Edit: Note that...

I barely know where to start.

A couple of things.

How many rows are in [V_DM GM_Sales Primary Contact Info]?

Is your data,...

If I'm following you correctly, there are two basic options off the top of my head. You can write a big ol' CASE statement inline, to handle each of the...

Then just denormalize it. Join the tables together and create a group on employee in the report itself.

Magy, it depends (don't you love that answer?), as some things, such as aggregate functions, can safely deal with Nulls by ignoring them. But yes, 2 + Null = Null.

Sure, but without knowing more about your data you'll need to build it yourself. You basically want to select from the archive table where there is no match in your...

If Reporting Services, including Report Manager (the IIS portion) is installed on the same server as your production database, and if my memory doesn't fail me, I think you're fine....

Have you tried using SQL Logins in your datasource?

Psst, your question was answered here. 

If I am understanding you correctly, I'd denormalize the results and then use grouping in the report to accomplish what you want. I am slightly confused though. Do you have...

Why do you want to raise an error if there is a value in the column? If you don't want that value, just don't bring it across. What are the...

Jeff, that answer was detailed enough that I'll buy you a beer, if you're ever in the Atlanta area, even though it wasn't my question.