Set up a table related to members with one record for each item of clothing issued to that member. Create a summary report based on this related table. You can use sorting to group the records by type and size and a summary field placed in a sub summary layout part can provide the count for each such group of records.
Thanks...for further clarity, I want the layout something like below, but in the standard report, I am not seeing how to do this.
Items | Small Large
Shirt 15 23
Pants 12 9
What I am suggesting, (You did ask "What is the most efficient way...") would look like this:
Getting this data into two or more columns as shown will be more complex to set up.
Got it and that will work. I see where I was messed up in how I set up the layout.