Hi everyone,
We are working on a custom report that has a parameter for account number, which is an alpha-numeric field. The account number strings are anywhere from 30-40 characters long.
We are finding that when we pass them in as a multi-select parameter, that they are being truncated to 30 characters, which is causing the report to return incorrect results.
We don't have an id field for this value at present, because we are pulling it from a view that is looking at multiple columns in another custom table (long story...).
I'm wondering if this is expected behavior or if there is something strange going on that is causing this parameter to be truncated.
Looking forward to hearing your thoughts. Thanks!