Is there an easier way - wrapping summary data

[Atalanta]

I'm working on a report. We'll go with my widget schema again. I've generated a report where it's first sorted by WidgetColor and then Widget with a count of each widget (widgetcount). I've presented this report and am waiting the next requirement. In the meantime, I am anticipating that he is going to want it to be:

Widget Color1

Widget1 Widget2 Widget3 Widget4

Widget5 Widget6

Widget Color2

Widget1 Widget2 Widget3 Widget4

Widget5

And so forth (you get the idea). I know this can be "easily" done with a single iteration of each widget by doing a loop in the script to omit duplicates (each Widget Color-Widget has a unique code) and then doing a sub-summary by Widget Color and the body in columns with the Widget.

Is there a way to do this without having to do the "omit loop"? I looked at cross-tab reporting but that's not it. The sub-summary portals didn't quite seem to be the answer either (unless I missed something). I'm guessing it's going to be something stupidly obvious that comment is going to point out and, again, I'll feel a bit "blonde" LOL.

[comment]

We'll go with my widget schema again.

I wish you wouldn't, because it's confusing. You are calling two separate things by the same name. If you are sorting records by Widget, then obviously a record in your table does not represent a widget. IOW, you are not counting widgets but something else - something of which one widget has many of.

I know this can be "easily" done ....

You either know more than I do or I don't understand the kind of report you are describing. :B