Sub-summary Display in List Views
It seems so simple, when all you want is to show the data in a particular fashion. Such as showing a sub-summary amount when your data is sorted in a list view. All you really want to know is how many blue items there are versus all the other colors. To accomplish this with a portal, you need multiple relationships with multiple table occurrences. To accomplish this in a list view, all you need is a GetSummary() function right?
Well, there's a bit more to it than that, and fortunately, you'll have this video to help guide you through the process. If making things look great in your database is something you enjoy, then I'm happy to provide you with one more technique to make that happen!
Comments
Leading Summary List
Hi Matt,
Great technique. I know this video is from a few years back, but I wanted to ask about one other technique for summary reports. I would love to be able to generate a report that looks similar to the one in this solution, but all of the summary data gets presented up front. To use your example, the report would look like:
Blue 355
Green 524
Red 259
----Section Break----
Widget Blue 55
Spegmit Blue 71
Tingjoy Blue 51
. . .
Phlunket Red 99
This seems very simple, but I can't seem to get the subsummary data for the categories to appear as a list for all the categories together, and I'd like the user to have the data of how many products in each color there are right at the top, without having to scroll. I bet I'm missing something super-basic, but I'm baffled! Thanks as always for the great resource!
Cheers,
Bob