How to Print "Included" in the Total Cost cell

Standard reports display the Total Cost value for each line item. If you prefer, you can suppress the value and display text in the Total Cost cells. This article describes how to configure a report to display "Included" for Base Estimate line items while continuing to display the Total Cost for alternate line items.

The procedures in this article describe how to create two parameters to control which scopes use text and what text is displayed. 

Configure Parameter Changes

1. Open an estimate in DESTINI Cloud Estimator.
2. Navigate to Home > New Report. Report Designer opens.
3. Click File > Open.
4. Navigate to the folder with the report template file (.repx) you want to modify.
5. Click the .repx file to open it.
6. In Report Explorer on the right side of your screen, click the Field List tab.
   
7. Scroll down and expand Parameters,
    
8. Right-click Include0LineItems and click Edit Parameters.
9. In the top left corner of the window, click the Add Parameter button.
10. With the new parameter selected, enter the following information:

    1. Name – ScopesWithAlternativeTotalCost

    2. Description – Scopes With Alternative Total Cost

    3. Label orientation – Vertical

    4. Type – String

    5. Allow null value – Checked

    6. Allow multiple values - Checked

    7. Default value – enter Base Estimate

    8. Value Source – Dynamic List

       1. Data Source - _DESTINICloudReportsDataSource

       2. Data Member – ScopesOfWork

       3. Value Member – Status

       4. Display Member – Status

       5. Filter String – Leave blank

       6. Sort Member – Status

       7. Sort Order – Ascending

11. Click the Add Parameter button again. Estimator saves the changes you just made and creates a new parameter.
12. With the new parameter selected, enter the following information and click OK:
    
    a. Name – AlternativeTotalCost
    
    b. Description – Alternative Total Cost
    
    c. Type – String
    
    d. Allow null value – Checked
    
    e. Default Value – enter Included

Designer Changes

1. In Field List on the right side of your screen, use the tabs to switch back to Report Explorer.

2. In the Report Explorer, search for tableCellTotalCost.
    

3. Right-click the result and select Navigate to Control.
   

4. In Designer in the middle of your screen, click the Gear button to the right of the Total Cost cell.
   

5. In the Table Cell Tasks popup, enter the following information:
   

   1. Format String – Clear the contents of the field

   2. Summary = Choose None from the dropdown

6. Click the ellipsis button next to Expression.
   

7. Choose one the following expressions based on your report.

   Report	Total Cost Expression
   Owners	Iif([ScopesOfWork].[Status] in (?ScopesWithAlternativeTotalCost), ?AlternativeTotalCost, FormatString('{0:c0}', [][[WBSProperty1] = [^.WBSProperty1] AND [WBSProperty2] = [^.WBSProperty2] AND [WBSProperty3] = [^.WBSProperty3] AND [WBSProperty4] = [^.WBSProperty4] And [LineItemIdentification] = [^.LineItemIdentification] AND [Description] = [^.Description] AND [UnitOfMeasure] = [^.UnitOfMeasure] AND [UnitCost_RoundedForGrouping] = [^.UnitCost_RoundedForGrouping] AND [Notes_ForGrouping] = [^.Notes_ForGrouping] ].Sum([TotalCost])))
   LMSEO	Iif([ScopesOfWork].[Status] in (?ScopesWithAlternativeTotalCost), ?AlternativeTotalCost, FormatString('{0:c0}', [][[WBSProperty1] = [^.WBSProperty1] AND [WBSProperty2] = [^.WBSProperty2] AND [WBSProperty3] = [^.WBSProperty3] AND [WBSProperty4] = [^.WBSProperty4] And [LineItemIdentification] = [^.LineItemIdentification] AND [Description] = [^.Description] AND [UnitOfMeasure] = [^.UnitOfMeasure] AND [LaborCost_RoundedForGrouping] = [^.LaborCost_RoundedForGrouping] AND [MaterialCost_RoundedForGrouping] = [^.MaterialCost_RoundedForGrouping] AND [EquipmentCost_RoundedForGrouping] = [^.EquipmentCost_RoundedForGrouping] AND [SubCost_RoundedForGrouping] = [^.SubCost_RoundedForGrouping] AND [OtherCost_RoundedForGrouping] = [^.OtherCost_RoundedForGrouping] AND[Notes_ForGrouping] = [^.Notes_ForGrouping] ].Sum([TotalCost])))

8. Copy and paste the expression into Expression Editor.

9. Save and run your report.