Problems with setfilter

sabzamsabzam Member Posts: 1,149
I am creating a report which reads a table. This table serves as a filter for another table.

I have the following code
Company.SETFILTER(Name, X.Name);

Now the x.name sometimes needs ' ' to be read properly even when inserting the filter manually needs the ' on both sides. Now what can be done to solve this problem since this is halting the report since it is constantly releasing an error. To be note that on one occasion the X.Name includes brackets and this is the reason why this is halting the report from running properly.

Answers

  • Soft_TodSoft_Tod Member Posts: 43
    Hello sabzam

    Use the whole SETFILTER statement as:
    Company.SETFILTER(Name, '%1'', X.Name);
    
    the string should then be recognised always.

    ...Soft Tod
    It is impossible to make anything foolproof, because fools are so ingenious.
  • sabzamsabzam Member Posts: 1,149
    Hi,

    Thanks it has worked perfectly. After all it had been such a simple solution. :)
Sign In or Register to comment.