Labor Distribution by Department

[Creese (Corvin Reese)]

Hello,

I am working on a new conversion Crystal to SSRS report. This one is Labor Distribution.

One of the fields in crystal say: Percentage of Sum of BAQReportResult.LaborDtl.LaborHrs (Numbers). I don’t even know what that means to be honest. Sum up the Labor Hours and get a percentage. I guess for each department there is a different percentage.

I have the field, its expression is
=Sum(Fields!LaborDtl_LaborHrs.Value)
Do I need to like, wrap that in another parenthesis with Per or something for Percent?
=Per(Sum(Fields!LaborDtl_LaborHrs.Value))

Before the report runs, in crystal, it has a parameter popup for department, start and end date. That I am also unfamiliar with.

Thank-you.

[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. …