When running a report, is there a way for the line items within WBS levels to be sorted by takeoff number? It looks like it auto-sorts to Item Number (ascending order). Typically, we organize our estimate detail by takeoff number which comes in handy for referencing a particular line item. Is there a way this can be adjusted?
Solution:
By implementing a custom WBS Property, for example, Report Order, any of the New Beck Technology Standard Reports can be modified by a user to sort by the custom WBS Property | Report Order.
- Declare the custom WBS Property | Report Order
Video: 01 Report Order.mp4
Video: 02 Report Order.mp4
- In the Report Designer | Insert Column to Left in GroupHeader1 (Level 0)
Video: 03 Report Order.mp4
- Declare Cell Expression | [Report Order]
Video: 04 Report Order.mp4
- In the Report Designer | Declare Group Field – Report Order in GroupHeader1 (Level 0)
Video: 05 Report Order.mp4
- Validate various syntax’s for the Report Order Ascending Sort
Video: 06 Report Order.mp4
Video: 07 Report Order.mp4
- In the Report Designer | Declare DisplayReportOrder Parameter (Yes/No) toggle
Video: 08 Report Order.mp4
- In the Report Designer | Declare Visible logic statement for Report Order Cell using testing on DisplayReportOrder Parameter: Iif(?DisplayReportOrder,1,0)
Video: 09 Report Order.mp4