Labor Distribution by Department

[gpayne (Greg Payne)]

I would put this in a subquery grouped by department with a calculated field like this

SUM(LaborDtl.LaborHrs) * 100 / SUM(SUM(LaborDtl.LaborHrs)) OVER ()

You may want to consider never doing BAQ reports if you are just getting started and do RDD reports instead. You can pass the date parameters in either type.

Is there a way to add table or BAQ to a BAQ Report

First consider the BAQ Report functionality dead, its not dead but there is no reason to ever use BAQ Report (its considered legacy now). There is a new gun in town. If you build your RDD and then create your style in Report Style Maintenance, you can just do a Action\Create SSRS Report and it will create you the template report just like in BAQ Report. Plus, you get all the data columns are mapped in for you. It should only take a couple more clicks to do RDD + BAQs instead of BAQ Report. …