Custom object as a drop down filter
SummaryWorkaround solution for Drop down filter
I have custom object BallotExclusion linked to contact object.
In report filter, I need to show Exclusion reason as drop down list, which is not possible.(It is shown as text field)
Workaround solution : Created User defined variable and filter. Refer Screen shot
Assume there are 90 records with No value (null) in ballot exclusion reason & 10 records with valid ballot exclusion reason.
By default, if don't apply any filter for ballot exclusion field (i.e No Value). I want to show all 100 records but currenly report shows 90 records.
How to show all records?