Is it possible to create a report that combines data regarding the following:
Labor (Date, Emp. Name, Classification, Hourly wage, # of hours, Total, Description of work, etc)
Material (Date, Description, Qty, Cost, Total, Use of material, etc)
These would have to be grouped separately with two separate description headers. Also, there is a relationship between the two groups with a work order number. However, it is not a one to one relationship, since there will be more labor than material in most cases.
I have tried to use a subreport, but haven't been successful with it. Should I keep working with the subreports, try something different, or place them in separate reports?