May 16, 201114 yr 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.
May 16, 201114 yr 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
Create an account or sign in to comment