I want to use one of the formula fields in my table as a search field for my tabular report page. I can include it to the search fields but when I changed its form element to any cascading element, it wouldn't allow me to use it for the "Field for value". It isn't available in the options to select from.
I also tried using a Virtual field and same thing happened. The formula field is just a concatenation of 2 text(255) fields. I don't want both of those fields in the table since two columns t