GroupHeader by Expression?

Using VCL 6

I've never used Expressions yet in GroupHeaders.

I have an issue where I have to hit up a stored procedure. ( fyi, I have ZERO control of the data end of things in this project )

I have to search an inventory by a number of possible things. That part is easy, done 100 times now.

Issue here is, I get all the data I needed, but I need to kind of break it all up in the report. Which is where group headers I was hoping would work out.

In this case, the first section. If any of these items in inventory results that are marked as being on a work order, I need to show them group all together as one.

So if 10 parts out of 100 are on a workorder, I would like to have 1 group header to represent the 10 parts. If I do it by data field, WO, it makes multiple groups, for each workorder #, and then
a group for the rest of the parts with a null WO field value.


Also it MAY get to a point, i have to group by more than one field ?

Is this doable? is Either of this doable?

I tried looking at the online help section, but couldn't seem to find exactly what I was needing, so sorry in advanced if i somehow glossed over the details on this one.