RickC

Originally Posted by Memphix

RickC, Is there a document that shows what other fields are available like TotalItemPrice? or can this be found in the Data Explorer somewhere?

The TotalItemPrice is a method off the ReportUtilities object that is available to all reports that are generated in the context of D-Tools. It was originally built for internal use to wrap a number of repeated bits of logic, but is available for calls externally. All the methods on this object are defined here:

ReportUtilities API

I believe there is a brief explanation for all of the calls and some have short examples. All are desinged to do specific tasks, whether it be returning values (per item or on the project total) or shortcuts/helper functions to set/read values from controls on the report.

There are two help files in there. One for the reportutilities class and one for the "Item". The item is an object representation of the data available when a user is iterating over "Items" or "ProposalItems" in a report.

Many of the examples where a value is calculated on a record by record basis leverage this.

Basically, if you're inventive, you can use the values on the item to calculate just about anything you may be looking for.

Also, I can't emphasize enough that a better understanding of how a report is generated will come from spending some time looking here:

http://www.datadynamics.com/Help/ARN...rts3_start.htm

The section in the users guide called "Concepts" is worth the read.

Also, using the "Summary" properties on the textbox controls for totalling/subtotalling is definitely worth understanding.

That may be more than you were looking for, but I hope I answered your question.

Originally Posted by Memphix

To spell out the textbox properties from RickC's help above: (Name) txttotPrice DataField totPrice OutputFormat C I've inserted the tax amount before that total. Just drag and drop "dtr:Total" onto the page found in the Data Explorer here: +dtr:ProjectTaxes +dtr: ProjectTax -dtr: Description -dtr: Labor -dtr: Equipment -dtr: Total and format it by putting "C" in its OutputFormat field within Properties.

Just on a side note about this.

This will work fine for anyone who has their tax country set to "Standard", "Australia", or "New Zealand" since there is only ever one record here... You should be good.

If the tax country is set to "Canada", there are two records in this section of the data (one for PST and one for GST).


-R

Memphix

Excellent.

Will get stuck into reading that... in the mean time, I've got a custom Wire Checklist that I run By Location.

I'm trying to modify it so its By Location By Zone. It was easy to sort it by this using the Grouping in Report Definitions (adding Zone under Location), but I'd also like to have the Zone labelled on the report.

Is it a GrpDynamicHeader with some script or is it a bit more complicated? Thanks.

RickC

Originally Posted by Memphix

Excellent. Will get stuck into reading that... in the mean time, I've got a custom Wire Checklist that I run By Location. I'm trying to modify it so its By Location By Zone. It was easy to sort it by this using the Grouping in Report Definitions (adding Zone under Location), but I'd also like to have the Zone labelled on the report. Is it a GrpDynamicHeader with some script or is it a bit more complicated? Thanks.

Add a group section to the report. make sure it's ordered below the grpDynamicHeader1 section.

Change it's name to GrpDynamicHeader2

Add a textbox to the new section

Name the textbox: txtDynamicHeader2

Save and publish.

No script. We achieve dynamic grouping by looking for the sections with the specific names and then the controls in the sections with specific names.

-R

Memphix

Perfect! Thanks.