Dynamically show/hide columns for DelimitedData output
My users want to see only dynamic sets of data from the same report query.
For example, if the query returns:
Date, Widget1Count, Widget2Count, ..., WidgetZCount
User1 wants to see Date and counts for widgets 1,2, 5, and 10
User2 wants to see Date and counts for widgets 2, 3, 4, 5, 10-20.
Uset3 wants to see Date and widget 99 count.
I don't want to write a custom report for every single user nor do I want to create Z! number of queries to satisfy every possible request combination.
I wonder, is there a way to change "Exclude from XML Output" property for a particular query field(s) from a report AfterPForm or BeforeReport trigger?