Can i have dynamic grouping in a report. As in based on a prompt change my grouping criteria
Yes. Create a data item with an expression that varies depending on the prompt response.
case ?GroupingPrompt?
when 'A' then [Customer]
when 'B' then [Product]
when 'C' then [Date]
else [Customer]
end