SSRS Multi-select Records on a Form to Filter Query as an Input

Evaldas

1,800

Like(1)

Report

Hello AX World,

This will be a short post for my own reference.

Use case

SSRS report launched from a form.
Query as an input.
Multiselect form records to filter the query.

The Problem

The problem was not how to do it, but rather how to do it right with the least amount of code.

Solution

I have found a neat example for this.

If you look at SmaWorkNote report, you can see all what is necessary.

You need a query:

Use the query in the data provider:

Filter the query in the controller. You must do it in the prePromptModifyContract method:

The piece of code from setRanges:

MultiSelectionHelper has some nice functionality. Just couple lines of code +1 for clearing the ranges before.
You pass a caller, a query data source and a field to filter on. That's it.

Then you need to traverse the query in the data provider. You know how to do it already.