kingtimm

I do like the way labor for each item is shown. Thank you for sharing that report. Now I just need a good way to summarize at the end, and separate types of labor.

The more I look into it, it seems it might not be easily possible, but I'll keep trying.

fryeguy

Tim:

Make sure to check the script in my report that looks like this (at the bottom):

Sub grpItemHeader_BeforePrint
Dim LbrPrc, EQ1, EQ2, EQ3, EQTot As Double
Dim lbrNote As String = ""
Dim categoryType As String = ""
LbrPrc =ReportUtilities.ReturnTextBoxValue(rpt,"grpItemHe ader","txtLbrPrc1")
lbrNote = "*"
EQ1 = ReportUtilities.ReturnTextBoxValue(rpt,"grpItemHea der","txtEQBase1")
EQ2 = ReportUtilities.ReturnTextBoxValue(rpt,"grpItemHea der","txtEQAdj1")
EQ3 = ReportUtilities.ReturnTextBoxValue(rpt,"grpItemHea der","txtMiscParts1")
EQTot = EQ1 + EQ2 + EQ3
'code allowed for case when showLaborItems was in question
'If showLaborItems Then
try
categoryType = ReportUtilities.ReturnTextBoxValue(rpt,"grpItemHea der","txtCategoryType").ToString
If categoryType.ToLower = "labor" Then
ReportUtilities.SetControlVisibility(rpt,"txtPrice ", false)
ReportUtilities.SetTextBoxValue(rpt,"grpItemHeader ","txtLbrNote",lbrNote)
Else
ReportUtilities.SetControlVisibility(rpt,"txtLbrPr c2", false)
ReportUtilities.SetControlVisibility(rpt,"txtLbrNo te", false)
End If
catch
End try
End Sub

This code is the logic that determines whether or not to show labor line items which is not typical for D-Tools reports. There is some extraneous info that I don't use but it keeps it from breaking for everyone else.

Are your labor line items defined as category "labor"? If not my code won't work properly as the labor amounts will get summed with install labor. Are you using a custom category name for this labor type? If it isn't "labor" the script will break...

Are you using the above mentioned script segment? Without this or something that duplicates it, I would expect that the labor would have no value.

I also create zones & locations for engineering & project management that allows those items to be grouped together using line items. They are also phases which allows us to easily break down different disciplines for labor analysis.

kingtimm

fryeguy,

I am back to your script as a base now, and that is a great way to calculate labor line items. Assigning labor items to their own zone/location is a major step forward. I should have figured that out.

I still would like to show extended rates. In your code, I don't see scripting for the parameter to show labor by phase. I'd assume I would have to alter it at that level to allow for the individual labor rates for specific items (rough-in labor, programming, design, etc.) to show.

Thanks again for your help.

-Tim

fryeguy

tim,

ok I'm not sure if we are speaking exactly the same language on some of this.

my understanding of "show labor by phase" is where line items for the total labor of each phase is shown in the summary. If you want this feature, you may have to track down the script code in another report: copy and paste. Not sure but this may be a subreport that is part of the summary...

when you say extended rates and talk about showing the labor rates, I think you are saying that you want to see something that shows the number of hours of labor, the hourly rate for a labor type, then the total labor.

It might be that the labor rate can be grabbed from the XML data but I am not sure...
../../../dtr:Project/dtp:Phases/dtp:Phase/dtp:LaborCost/dtp:Rate

Do you have any cases where more than one labor type would appear in a location?

kingtimm

Hi fryeguy,

Sorry it took me a while to get back.

I misunderstood Show Labor by Phase. I now have a better understanding of that function.

When I speak of extended rates, I am talking about labor first and foremost. You are correct in the description of columns: qty of labor hours | labor rate | and total cost of labor. However, I would like to be able to list this by labor type (engineering, programming, install, etc) as well like my example.

Perhaps beside the point, but I also think equipment should be able to be listed with extended rates. QTY | Item w/ Description | Per Unit | Total.

For labor, I can do this by perhaps putting the respective labor rates in the description. However, installation labor attached to an item would not be listed in the same manner as programming/engineering items added to a project.

As far as being able to list more than one type of labor in a location, it would be nice for say a digital signage project proposal for 20 sign locations. Let's say all 20 are out of the client's budget, they can easily go through and pick and choose which ones they want/need...it might not be worth $XXXX.XX to put a sign in the restroom, but the main entrance needs to have one. I am not saying every single cost such as tax/shipping needs to get attached to a location, I just think it would be nice if you could isolate the different types of labor to a location, listing them in a consistent manner.

Thanks a lot for your help in conceptualizing this type of proposal.