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?
StevenYou 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment