Hi

It depends on what the drop down list contains, and what default you want to set, you might need to give a bit more information on this one.

OK, there are a couple of simple things you could do to speed it up, but I'm not sure it's worthwhile doing the simple things, I would make wholesale changes...

OK, first look tells me that your problem is definately in the SQL Code,, however, you'll need to give me a couple of hours to fully digest and re-work it.

I'll...

The timing is not bad when a single SELECT for a single employee takes 5 seconds!

5 * 162 = 810 seconds in total, this is 13.5 minutes and...

It really depends on how you are doing your calculations:

Are you using any cursors to do this?

Are you using formulas in your WHERE clause?

Generally speaking I haven't found a difference...

There's no option to do this that I know of, sorry.

Yes, this is the only option that will deal with this.

I have never seen this option, the only one I can find like this is

Hide in List View

Is this the one you are using?

If this is the one you...

My pleasure, pleased to help.

Stored procedures, just as a matter of interest, would need exactly the same coding in the select statement!!

SELECT CASE WHEN @col = '1' THEN For_Sale.Bike

...

Are you using the document map entries?

Short answer is YES, you don't need it if the select is from one table, I normally use an alias on the select which makes the typing shorter, for example:

SELECT...

SSRS Automatically converts document map entries into bookmarks, in fact I'm not sure there's a way to NOT do this!!

Have you tried it and failed?

Are you using the document map...

You would probably use a CASE statement to achieve this, for example:

SELECT

CASE

WHEN @Column='Bike' THEN TBL.Bikes

WHEN @Column='Clothes' THEN TBL.Clothes

WHEN @Column='Access' THEN TBL.Accessory

ELSE...

If this is really all you want to do (to hide them from the tree view) then probably you can use the same type of expression you have used for...