Skip to Content
0

problem with tokens crystal report for sap business one

Nov 04, 2017 at 11:51 PM

40

avatar image
Former Member

Dear partners please could you tell me how I can filter a list of parameters based on 2 tokens, with only one token it works correctly, but with 2 tokens it does not generate data. I did the sql test and it works correctly.

SELECT T0."CardCode", T0."CardName" FROM OCRD T0 WHERE T0."GroupCode" IN ('113') AND T0."SlpCode" IN ('1','2','4')

https://1drv.ms/f/s!Asu8xO7tGVFEvgflEd08bn4s1Yz9

THANK YOU VERY MUCH

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kennedy T Nov 05, 2017 at 05:33 AM
0

Hi

Check the parameter IN or = is missing...

T0."SlpCode" IN

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thank you, you're right but it does not solve the problem

0