Knowing that the record amount for the type of report I want to produce exceeds 10,000 records, does anyone know of any other approach to reporting out multi-select picklist values? Are there apps out there that I'm missing that one can pay for that provides a solution to this?
I am aware of creating formula fields (as suggested by Salesforce in the link below), but with my company's ever-changing case component list, it would not be feasible to contantly be updating them. We are also stuck with reporting on the components directly in excel. Ultimately, we need a solution in Salesforce (not excel) to provide reporting capabilities on the multi-select picklist.
https://help.salesforce.com/HTViewSolution?id=000004482&language=en_US
2 respuestas
I found that writing a trigger to populate a linked object with the individual items allowed me to get the reporting that I wanted. Try creating a trigger for 'after insert' and 'after update'.
