In my report i have created the following
Group Header #1 Department, Total # of work orders, Total Cost of Work Orders
Group Header #2 Status of Work Orders
Group Header #3 Work order ID, Status, Employee, Finish Date, # of Labor Hours, Work order Cost
In Group header#3 i also have a sub report linked as On Demand. For the sub report link I have from available Fields i have chosen to move WORKORDER.WORKORDERID over to "Field's to link to".
For the sub report Parameter Field to use I have chosen "Pm-WORKORDER.WORKORDERID" and have checked the box for "Select Data in subreport base on field" and have chosen "WORKORDER.WORKORDERID"
When I run this report I get a blank report with no data, Not sure how I am linking this incorrectly.
