Different dynamic grouping question

Hi,

I have a basic report that has some transaction info, eg

Name Type

AAA Buy

AAA Buy

AAA Sell

BBB Buy

BBB Buy

BBB Buy

BBB Sell

Etc

I want to group all the BBB's together, but I don't want to group ANY others together... Ie, I want to group the transactions together if the name is BBB, else I don't want to group at all.

Is this possible?

I hope I have given enough info.

Cheers

Rob

You can very well do the grouping on NAME field and hide the grouping depending on the value of that field.
|||

I need to be able to drill down into the complete list if needed. which means I need a group header to display the grouped data and allow the user to click the plus sign to expand the BBB records.

This won't work for two reasons, firstly I don't want anything other than BBB to be grouped at all, secondly this would show up a group header for each different name, when I'd only want a group header for the BBB group, and the others just display the details.

Hope that makes sense.

|||Anyone? This is doing my head in