fryeguy

What do they say?
If you fail, try, try again.
Well I'm sure I butchered that quote but suffice it to say I managed to work out my report.

It is a Line Item Detail report that shows labor by location and labor line items with there value instead of reading as $0.00.

Originally I was trying to use an If/Then statement that determines whether the Item is of Category Type "labor" or not and then use:
ReportUtilities.SetTextBoxValue(rpt,"MyReportSection","MyTextBoxName",MyItemValueVariable)
to set the value of the item. I neve managed to get this to work properly so instead I added a second text box in the same location as the typical txtPrice text box and used the If/Then to set the visibility property of the boxes depending on Category Type.

The programming sure isn't elegant but it works.

I am also considering more logic to remove the Equipment Total by Location for any Locations that have no Equipment value. That way it makes labor only Zones/Locations read more clearly. A sidenote to this comment is that we create Phases/Zones/Locations for Programming/Engineering/PM labor instead of using labor multipliers.

Any feedback is appreciated.