LIKE In RDLC Report

Elyes

Hello,
I use a navision 2013
I would filter the databox with two chaine
The expression =Fields!ItemNo_ItemLedgerEntry.Value like "*paac" and "KIT-PA*"

Could you please help me

Elyes

Elyes

could you please help me?
Thanks in advance

Aluan

Hello Elyes,
if you need a and condition you can add a second filter.

First Filter with the value:
*paac

Second Filter with the value:
KIT-PA*

The Expression and Operator is for both filter the same.

Elyes

Hello Aluan,

If a add the two filter the resultat is null

when i add one filter the resultat is below only the PAAC is show



could you please help me?

Yannick1

Use OR instead of AND

Aluan

So,
just for clarification, do you need all lines where the ItemLedgerEntry.Value end with "paac" AND start with "KIT-PA", or do you need the lines with ItemLedgerEntry.Value that end with "paac" OR start with "KIT-PA"?

Elyes

Hello aluan,
Yes, Ineed the lines with ItemLedgerEntry.Value that end with "paac" OR start with "KIT-PA"

Aluan

Then you need an or condition, as Yannick1 said.

One way would be:
Expression:

=Fields!ItemNo_ItemLedgerEntry.Value Like "KIT-PA*" OR  =Fields!ItemNo_ItemLedgerEntry.Value Like "*paac"

Type: Boolean
Operator: =
Value: TRUE

Elyes

Hello aluan,

I have this error when i compile

Aluan

Just type TRUE without anything else. If that doesn't work, take please a Screenshot.