Dynamic Filtering

sabzam

Dear ALl,

I've got a query in the following scenario

I am running a report which during the workings will be running a filter onto the Entry No. field therefore, integer. The issue is that the no. of filters to be applied is dynamic. Therefore we may have two numbers, but we may aslo have ten.

I have tried to insert the numbers in a text variable but when applying the setfilter it is not accepting it.
SInce I am using the '|' I cannot use the number variable.

Manually this can be done but I cannot manage through code.

What's the way forward?

Regards,

Steve

Rob_Hansen

Please post the code you're having problems with. The following structure works fine for me, so you should be able to construct the dynamic filter in a text variable and apply it.

lrecGLEntry.SETFILTER("Entry No.",'1|2|3|4');

naveengour

Kindly post your code for solution....