sql server reporting services: Hey All,
I've found another problem related to everyone's select all hack which is
using a union and an extra check.

I have a simple Customers drop down and I want to display the (All
Customers) option.

So, I took Reddy's advice and tried this:

WHERE (Customer IN (@Customer) or '(All Customers)' in(@Customer))

This works until you try to set '(All Customers)' as the non-queried default
value. The worst part is that it works in the VS Preview mode, then does NOT
work from the report server.

Basically, it just ignores the default value.

Anyone know why this might be the case?

Steven

You may need to delete the deployed report from RS and then redeploy. There
is a problem where parameter values get incorrectly updated if you redeploy
over the top.

Taz