Memphix

On the Line Item Installed Price, it just doesn't display a price if its owner furnished.

I have come across the utility dtr:OwnerFurnishedEquipment, but using this provides a true or false field. Ideally it would just say owner furnished if it is and nothing if it isn't. Does this require some knowledgeable scripting or just tweaking some fields?

This use to be displayed with SI4 (if you chose product description... however using the client description did not show it).

RickC

Originally Posted by Memphix

On the Line Item Installed Price, it just doesn't display a price if its owner furnished. I have come across the utility dtr:OwnerFurnishedEquipment, but using this provides a true or false field. Ideally it would just say owner furnished if it is and nothing if it isn't. Does this require some knowledgeable scripting or just tweaking some fields? This use to be displayed with SI4 (if you chose product description... however using the client description did not show it).

You can probably add a textbox control to your report and set the text to "OFE" or whatever you want to call it.

In the script, in the "Format" event of the respective section, you may be able to do something like:

Code:

' Get the current item Dim currentItem as DTools.SystemIntegrator.Reporting.Item = ReportUtilities.ReturnItem(rpt) 'Test for null If currentItem isnot nothing then Assumes the control is named "TextBox1" ReportUtilities.SetControlVisibility(rpt, "TextBox1", itm.OwnerFurnishedEquipment) end if

RE: SI4 and OFE. OFE was never noted as a field in the DB. When a user checked "Owner Furnished", it stuck the string "OFE" onto the end of the product description in the project. and then OFE was tested for by checking if the description ended in "OFE". This was problematic for a lot of reasons. The side effect was that products in proposals were automatically flagged as OFE. Which I suppose you could simply modify the description of the product and forget about the above suggestion.

-R

Memphix

Thanks for your reply...

I received the folling validation errors:
Report Script Compile Error on line 71 Error = Name 'itm' is not declared.
Report Script Compile Error on line 355 Error = Access of shared member, constant member, enum member or nexted type through an instance; qualifying expression will not be evaluated.

First error is referring to the line " 'Assumes the control Is named "TextBox4" "
and second to a line that is blank?

I've included the report as a zip (its a customised Line Item Installed Price... in the process of adding extra fields such as cost price). It publishes without errors prior to this addition.

Sorry my scripting isn't there yet (was not able to expand on what you provided). What language is that your using (VB/VB.NET/C etc) ??

RickC

ah...typos when free wheeling a bit of script...

Hopefully, I caught them all this time.

Needed a comment marker in front of the line that starts with "Assumes"
variable name is "currentItem", not "itm"


The language is VB.NET, but AR supports C# too. The script for all the reports is written in VB.NET though since it's more readable and more people who have created marcos or done any MS Office scripting will be more familiar with the syntax.

-R

Code:

' Get the current item Dim currentItem as DTools.SystemIntegrator.Reporting.Item = ReportUtilities.ReturnItem(rpt) 'Test for null If currentItem isnot nothing then 'Assumes the control is named "TextBox1" ReportUtilities.SetControlVisibility(rpt, "TextBox1", currentItem.OwnerFurnishedEquipment) end if

Memphix

I've tried to add this new script to my report, it received no compile errors - promising.

Then I got no results, tried filter for OFE only and then said there was no result. Then I remembered why, the OFE check box disapears (a current bug that)... Owner furnished equipment

Are there plans for a small update soon. This is very restricting.

garym

What are you trying to accomplish? If you're just trying to communicate to the client that these line items are his gear, I have a "manufacture" in my database called "Client Supplied", it has all the items that client's generally supplies (displays, audio, and video sources... etc.), they have the proper labor and accessories attached and the client knows easily from the report that this is his stuff. Once the project is closed, I can easily replace these with the correct model.

__________________
MP3... what is that... a new Mazda?

CIdocs.com

Go Cubs!

Memphix

Thanks for your input, the option of changing the Manufacturer to an "Owner Furnished" manufacturer is a possibility.

But I am still keen to see this bug fixed as I don't want to sift through these big projects for each OFE item.