I would like to add an 'All' value that is the union of distinct values pulled by my Enesys query.  Is this possible using Enesys - what is the appropriate code to do this?

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>DistinctCategories</dstTableName>

<tableName>Products</tableName>

<fieldName>Category</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.

Let me know if it helps.
Regards,

---

Frederic LATOUR
ENESYS