casaplex

I am working with Si5, and I wanted to make it print out the Labor SKUs, but just not print price. Currently it prints out a price of $0.00 for all Labor, which confuses clients. I would like the option of either printing Labor price or not printing price at all on reports.

I looked at the customizing reports documentation, and found it to not be very helpful at all. I tried to modify a report and add code to the Format of Detail1.txtPrice, but had no luck in getting it to work.

Is there a document which outlines all the available functions/methods used in the Script Tab of the report Designer? I looked at the ActiveScripts file, and found nothing useful. For example:

ReportUtilities.SetManufacturerModelTextBox() was not in the ActiveScripts documenation, and is obviously something D-Tools specific. Where can we find this documentation? I can't find it in the D-Tools SDK either.

RickC

Originally Posted by casaplex

I am working with Si5, and I wanted to make it print out the Labor SKUs, but just not print price. Currently it prints out a price of $0.00 for all Labor, which confuses clients. I would like the option of either printing Labor price or not printing price at all on reports.

The versions of the Proposals shipped in the latest patch resolve this issue.

Labor items in the "List Price" versions do not show prices as the list price for a labor item is $0.00.

Labor Items in the "Install Price" versions of the proposals will show the price as the install price will be > $0.00.

There is a parameter on the definitions (user modifiable: http://downloads.d-tools.com/si5/rep...efinitions.pdf) to determine whether labor items will show in the reports or not ("Show labor items in report?"). This, I believe, is false by default for the "List Price" versions (as the list price is $0.00) and True for the "Install Price" versions (as this is > $0.00 and has an effect on the subtotals).

Originally Posted by casaplex

Is there a document which outlines all the available functions/methods used in the Script Tab of the report Designer? I looked at the ActiveScripts file, and found nothing useful. For example: ReportUtilities.SetManufacturerModelTextBox() was not in the ActiveScripts documenation, and is obviously something D-Tools specific. Where can we find this documentation? I can't find it in the D-Tools SDK either.

The ReportUtilities object that is referenced in the script of many of the reports is D-Tools specific. It was created to encapsulate many common functions used across many of the reports and create wrappers to simplify some functionality in the script. All functions are available to all reports and are available for use when creating custom reports.

Documentation on the methods, their signatures, behaviors, and usage constraints will be forthcoming.

-R

michux1

Originally Posted by RickC

Documentation on the methods, their signatures, behaviors, and usage constraints will be forthcoming. -R

WHEN? WHEN? WHEN? If we have this information, then we won't have to rely and/or wait for you to build this stuff for us? We may also be able to help others on this message board

While we are on the subject, how do I change the subreport for the contract percentages to reflect a filtered price. Currently you are using the hook ReportUtilities.TotalProjectPriceNoFilter(). Because I have to guess, I tried ReportUtilities.TotalProjectPrice() and ReportUtilities.TotalProjectPrice(rpt), and got close, but still returned an error.

__________________
Wherever you go...there you are.

RickC

Originally Posted by michux1

WHEN? WHEN? WHEN? If we have this information, then we won't have to rely and/or wait for you to build this stuff for us? We may also be able to help others on this message board

In the next day or two for a rough cut. I agree with your points whole heartedly. Just trying to get it cleaned up a little bit (probably still be a bit rough, but will be better than nothing).

Originally Posted by michux1

While we are on the subject, how do I change the subreport for the contract percentages to reflect a filtered price. Currently you are using the hook ReportUtilities.TotalProjectPriceNoFilter(). Because I have to guess, I tried ReportUtilities.TotalProjectPrice() and ReportUtilities.TotalProjectPrice(rpt), and got close, but still returned an error.

ReportUtilities.TotalProjectPrice(rpt) currently depends on the report iterating over the "items". Many of the helper methods are dependent on the report iterating over the project items.

We're looking at this very issue right now.

-R

michux1

Originally Posted by RickC

In the next day or two for a rough cut. I agree with your points whole heartedly. Just trying to get it cleaned up a little bit (probably still be a bit rough, but will be better than nothing). -R

Wow. These have been the longest two days I have ever seen.

__________________
Wherever you go...there you are.

RickC

Originally Posted by michux1

Wow. These have been the longest two days I have ever seen.

Sorry. That was the plan. I've had other commitments and obligations that have taken precedent. Still on the list and will happen. I could say a lot of things, but simply: My bad.

-R

michux1

Maybe this sounds crazy. but is it possible to just post what you guys are using internally??? Or could you email it to me if possible?? right now anything is better than nothing. I don't mind if it's not formatted perfectly with pretty pictures. Plus you may be able to shut me up for a while while I try to figure it out.

__________________
Wherever you go...there you are.

RickC

Originally Posted by michux1

Maybe this sounds crazy. but is it possible to just post what you guys are using internally??? Or could you email it to me if possible?? right now anything is better than nothing. I don't mind if it's not formatted perfectly with pretty pictures. Plus you may be able to shut me up for a while while I try to figure it out.

In case you miss it...

ReportUtilities API

-R

michux1

Thank you! This should be very helpful.

__________________
Wherever you go...there you are.