Hi,
I think that I may have understood what you would like to achieve :

The "distinct" operation has an undocumented element (addValue) that will let you add a value to the result set returned by the distinct operation:

<sqlOp op="distinct">

<dstTableName>DistinctNames</dstTableName>

<tableName>YourList</tableName>

<fieldName>Name</fieldName>

<addValue>ALL</addValue>

</sqlOp>

The value ("ALL" in this case) is inserted as the first row of the result set.

Unfortunately, when giving the option to filter on a specific element or not to filter (ALL values) it is not possible to use CAML. You will have to retrieve all the value and rely on Reporting Services filtering options.

Your Report Services Filter will be something like this :

Fields!YourField.Value  =  =IIF(Parameters.yourParameter.Value = 'ALL', Fields!YourField.Value , Parameters.yourParameter.Value)

Let me know if it helps.
Regards,

---

Frederic LATOUR
ENESYS

Hi,
We would need to automatically transform the user defined caml within the Query in order to support such a scenario. Though not completely trivial we are considering this option for a future version for being able to support multi-value parameters.
Regards,

---

Frederic LATOUR
ENESYS

Hi,

Please have a look to this thread : http://www.enesyssoftware.com/Forum/tabid/53/forumid/2/threadid/502/scope/posts/language/fr-FR/Default.aspx

It uses another approach to the same problem by relying on Reporting Services multi-values parameters.

Does it make sense? Please do not hesitate to tell me if not and I will write a KB article that explains the process in details.

Regards,

---

Frederic LATOUR
ENESYS