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.
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.
Comments
VarToStr(<YourDatasetName."YourFieldName1">) + VarToStr(<YourDatasetName."YourFieldName2">)
expression