Hi,

Enesys RS Data Extension does not parse multi-value parameters so that you will not be able to use such a parameter within a query.

Howeveyou can still use multi-values parameters for filtering at the report server level.

You will build a report with 2 datasets:

One dataset for retrieving all items from your list

A second dataset for specifying the available values for your parameter. The query for the second dataset will be similar to the following query which returns distinct categories from a product list:

<?xml version="1.0" encoding="utf-8" ?>

<root xmlns="http://enesyssoftware.com/schemas">

    <list title="Products" relativeSiteUrl="/sites/demo/"  tableName="Products">

        <fields>Category</fields>

        <query></query>

    </list>

    <sqlOp op="distinct">

        <dstTableName>DistinctCategories</dstTableName>

        <tableName>Products</tableName>

        <fieldName>Category</fieldName>

        <sortOrder>ASC</sortOrder>

    </sqlOp>

    <resultSet>DistinctCategories</resultSet>

</root>

You create a report parameter and check the Multi-value option. You specify your second dataset for your parameter Available values.

You add a filter (either at the dataset level or at the table level) such as the following :


I'm curious to know how you were expecting to use multi-values parameters within an ERSDE query.

Regards,

Hi,

Glad I could help.

We are thinking of providing some kind of "IN" statement that could be written inside the CAML fragment (within the query element). Under the hood we would replace this statement with as many caml <Eq> statement as necessary.

Regards,

Hi Steve,

You should not have anything to do for implementing "Select All" using this approach.

Checking "Select All" will return all the available parameter values and will make the filter works as expected.

Do I misunderstand your question? Let me know.

Regards,

Hi Steve,

If I understand you well, you would like to have all values selected by default when you run the report.

If so, you may set the parameter default values using the exact same dataset used for setting the available values as shown in the following screenshot:

Is this what you were looking for?

Regards,