Hello, I am back :)
So I was just wondering if there was a way to group a report based on a parameter? For instance, I have a report that give the user a choice to group info (group id, customer, category, and product) and I only want the report to group info based on what they choose. So if they choose group id and category, I dont want the report to group by customer and product as well. Does this make sense?? I have it right suppressing the groups based on their selection but the report is still performing the grouping (just not displaying it)
Is there a formula or something I can use to group based on the user's selection?
try
go to section expert click x-2 button next to suppress(with no drill down)
and put an appropriate formula like
isnull(?parameter)
for each group like
Thanks for the reply. That is what I already have setup, it is just suppressing the info but still performing the grouping. if that makes sense.
Make formulae for each group/parameter as follows (assumes your parameters are boolean (ie group by customer true/false);
GROUP 1if = True then else ""
