I could give it a try, but isn't neccecary anny more. I now selected each item separately via the Jet Designer, it took more time but did the job. Thanks for your help anyway.
Date
Votes
2 comments
-
Jet Reports Historic Posts I have a problem creating a new report. I want to see all sale lines only from certain articles. One of the article numbers is 013170, when i write this itemnumber down in Excell for my filter , the final result is 13170 instead of 013170. Now my filter is useless.
Is there a way how I can fix this, I allready tried ceveral Cell properties. -
Jet Reports Historic Posts Try to use the prefix ' before the item number: '013170
It will tell Excel to see the number as text.
I am not sure if Jet will loose the character before applying the filter, but I think it will.
If not, you can use a separate cell with the formula: =text(A1;"000000"), assuming your item number is in A1….
rmw
Please sign in to leave a comment.