hello,
I have this "stupid" problems:
1) Empty filter- everything is OK, but when I want use this filter, it is empty, why?
2) Doesn´t working filter- each item in this filter is working besides Poplatek (zboží), why?
Date
Votes
4 comments
-
Jet Reports Historic Posts hi
Can you show me the formula for lookup
then only we can predict the output…
Alex 8-) -
Jet Reports Historic Posts Hello,
the first problem is resolved- it is working now.. I did nothing but it works now :)
But the second problem is still actual… -
Jet Reports Historic Posts It looks like you are including special search characters in your value.
When filtering in NAV you can build quite complicated searches with characters like | () * <>
When those characters are used in the data, NAV will have trouble filtering.
You can try to quote the data. Searching for 'Poplatek (zboží)' (quotes included) should work.
The adding of these quotes can be done in an excel formula.
Instead of referring to your original value, you can make the filters referring to the calculated value.
If your user selected value is in C7 e.g. try to put this D7:
="'"&C7&"'"
And let your filters refer to D7
HTH
rmw -
Jet Reports Historic Posts Hi
There is 2 ways you can insert the lookup functionality
1) =NL("Lookup","G/L Account","Account Type")
2)Kindly go through the screen shot attached.
I think this will help you out
Please sign in to leave a comment.