Problems when selecting filter
Posted: Mon Jul 18, 2022 8:30 am
Hi,
I have a report where I configured a numeric filter based on a variable called "iduserlocation". Its format is "short"
If a I set it to write it manually (eg I type an integer such as 10, or 20, etc), it works perfect.
But if I select it from a list based on a column of another table it does not work.
The column that I am selecting from that table is also a "short" type. In the filter drop down I can see the numbers (the same numbers that I had previously tried manually), but if I select any of them I get the error messsage.
Attached you will find the error message.
Could you plese guide me to fix it?
Thanks
I have a report where I configured a numeric filter based on a variable called "iduserlocation". Its format is "short"
If a I set it to write it manually (eg I type an integer such as 10, or 20, etc), it works perfect.
But if I select it from a list based on a column of another table it does not work.
The column that I am selecting from that table is also a "short" type. In the filter drop down I can see the numbers (the same numbers that I had previously tried manually), but if I select any of them I get the error messsage.
Attached you will find the error message.
Could you plese guide me to fix it?
Thanks