topic Re: How to match and show matched values from two different fields? in Reporting Service & Alerting

How to match and show matched values from two different fields?

adann_CB_96 — Mon, 02 Feb 2026 12:59:29 GMT

I am using a filer pane in which I must show some values.

There are two fields: "A" and "B" with contract ids and I have to do something like inner join between them to check, if a values from "A" field exists in "B" field. If so, such a value will be shown in the filter pane and all other values existing in both fields will be shown too.

Do you know how to do it in an edit expression?

Re: How to match and show matched values from two different fields?

marcus_sommer — Mon, 02 Feb 2026 14:25:38 GMT

It shouldn't be done within the UI else in the data-model and might resulting in a single field for the id's and n extra fields with the information if the id is in orders/billing/shipment/whatever ... and/or how many times and/or the date-offsets or ...

There are various approaches possible, for example checks with exists() or aggregation-loads or interrecord-functions like peek() and previous.

Re: How to match and show matched values from two different fields?

adann_CB_96 — Mon, 02 Feb 2026 14:30:51 GMT

Hi, none of those functions you mentioned exist in a edit expression.

Re: How to match and show matched values from two different fields?

marcus_sommer — Mon, 02 Feb 2026 14:37:46 GMT

Like hinted, it shouldn't be done there else within the script to get native fields with the appropriate information.

Re: How to match and show matched values from two different fields?

marksouzacosta — Mon, 02 Feb 2026 15:21:44 GMT

Hi @adann_CB_96,

Maybe something like this:

Count({<FieldA=P(FieldB)>} FieldC)

Regards,

Mark Costa