How to configure a selectable list of 'starts with' or likes' trimmed from the report filter?
Hope you're all well.
I would like to trim the results of a field to display the first two characters that I am after for my selection and then be able to select these values from the filter (as a list) when running the report.
For example 'AD2012-23-05' would show 'AD' in the report filter and when selected, display all the records that start with AD in the report.
The same goes for 'EO139-2500M-0083-FMS1' which would be 'EO' and show all the records when this is selected from the report filter from the same list.
Is there any way of doing this?
Appreciate your help and much thanks in advance.