Reply
 
LinkBack Thread Tools Display Modes
Old 10-13-2008, 09:34 AM   #11 (permalink)
Senior Member
 
Join Date: Mar 2006
Location: Novato (20 miles north of San Francisco)
Posts: 445
fryeguy is on a distinguished road
Default

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.
Attached Files:
File Type: zip SV Custom Report 081012.zip (40.0 KB, 28 views)

Last edited by fryeguy; 10-13-2008 at 08:12 PM.
fryeguy is offline   Reply With Quote
Old 02-25-2010, 08:48 PM   #12 (permalink)
Junior Member
 
Join Date: Feb 2010
Posts: 11
richardg is on a distinguished road
Default

waking an old one here.... but this is a pertinent issue for me and i'd imagine a lot of new SI5.5 users out there. I don't want to use SI's in-built mechanism for caluclating labour charges (...yet), so it's important that I can indicate labour clearly.

In my reports we have the following columns:
Quantity / Description / Unit price / Line price

Works fine, until we place a labour item in there. That shows up as £0 of course.

So how about adding in a new column:
Quantity / Description / Labour price / Unit price / Line price

So it wouldn't then show the unit price of labour but that's not such a bad thing?
__________________
if at first you don't succeed... shuffle sideways
richardg is offline   Reply With Quote
Old 05-20-2010, 04:15 PM   #13 (permalink)
Junior Member
 
Join Date: Feb 2010
Posts: 11
richardg is on a distinguished road
Default

anyone see what i mean?
__________________
if at first you don't succeed... shuffle sideways
richardg is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Item Installed Price showing Owner Furnished Memphix Reports and Reporting Center 6 06-30-2008 08:38 AM
Breaking out accessories jpol Reports and Reporting Center 6 05-05-2008 03:09 PM
Report: Line Item Detail fryeguy Bugs Section 0 12-28-2007 01:34 AM
Line item detail - Not showing client text kevink Reports and Reporting Center 8 07-20-2007 08:59 PM
Labor Line Item RichardMaris General Section 1 04-29-2006 04:39 PM


All times are GMT. The time now is 05:44 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.0
D-Tools, Inc.