Hi - I have a nice custom report for our ‘Member Roster’ (i.e. customers). Only issue is that the fields available do not seem to include the ‘Inactive’ flag. i.e. I really only want to include active customers in the custom report. Currently that field does not seem to be available to include in either the ‘where’ or ‘select’ criteria. So it is neither possible to (i) restrict the list to active or inactive or (ii) even add the field to the report to identify active vs. inactive.
Lubos - Any chance the inactive status flag could be exposed to the custom report fields for the customers table?
Thanks for considering. It seems silly to have to duplicate the active/inactive flag in a custom field to be able to have something available to use in the where clause.