Greetings Crystal Report Forums!

I'm definitely new to Crystal development, and I usually rely on reverse engineering of what I've already got at my disposal. I don't have any examples to work with this time though.

We use SAGE MAS as our backend, and I'm trying to pull warehouse quantities from the tables. I need to pull the quantities for three different warehouses, but the way they're stored in the tables is confusing me.

They store like so...

Item# // Warehouse 01 // Count
Item# // Warehouse 02 // Count
Item# // Warehouse 03 // Count

Currently, What's in place is a sub report with a "sum" of the "count" field, but it doesn't output correctly (I've confirmed that in the tables).

Any chance someone might have a suggestion for me? I know my question is quite vague, so if I can help clarify anything let me know!

I'm still not going to be able to explain it properly, but I did get it working.

I didn't think to look at the sub report's selection formula. Adding selection methods into there, as well as a group summary gave me what I was looking for.