Dennis @ PerfectForms
What you are describing is drilling down to a specific instance(s) and showing a set of fields from that/those instance(s) in a data list. You will have to drill down by several metrics to find your specific instance. The user can do this manually by clicking the reporting objects, for example: A pie chart with the workflow stages – click Final stage. Perhaps you would then drill down by date range using a filter input reporting object. You can also use wild cards in a filter input object to search for words or names in a field.
If you are building a report for a specific individual and want to drill down programmatically when the report opens use Set Filter objects to drill down by pre-set values.
Please review our free training video on reporting: /training_videos.php