Enesys RS Data Extension V3 Preview - Build 3.0.183 is available for download.
This new build includes:
Direct support for multi-value report's parameters
Reporting Services Multi-value parameters are now directly supported by Enesys RS Data Extension.
More specifically, you can use a multi-value parameter in the following context:
· SqlQuery statement with an IN clause:
· Pseudo Caml Query In operator (new in this version):
New pseudo CAML Query "In" and "NotIn" operators
Enhancing direct support for multi-value parameters, we have extended CAML Query syntax in order to support "In" and "NotIn" operators.
Using “In” at the CAML Query level rather than relying on the equivalent SqlQuery statement improves performances considerably when using medium to large lists (by a factor of 2 to 10).
For more information, refer to the documentation.
New pseudo CAML Query "IfNot" modifier
The new IfNot element acts as a modifier for the Eq operator in order to allow you to retrieve either all items or items filtered on a specific value.
The idea is to permit the “ALL” or “Some value” filtering scenario without relying on an additional SqlQuery statement and mostly, with much improved performance than the equivalent SqlQuery statement.
For more information, refer to the documentation.
Enesys SharPoint Query Builder
Enesys SharePoint Query Builder has been updated for supporting new "In", "NotIn" and "IfNot" operators.
When creating a project, it is now possible to specify SharePoint Url using "https" protocol.
Upgrading from a previous V3 build
To update your BIDS environment, just run the installation program.
To update your report server, just replace the dll (available in the install folder once you have run installation program) in the appropriate ReportServer bin folder.
