Reports - Custom EVOLVE for calculated fields

Updated 7 months ago by Kerry Poe

String
- Split
Revit
Global

While DevExpress Reports includes predefined functions that address common scenarios, EVOLVE has implemented custom functions to ensure users can properly report values from Revit (based on current project units), pull data from EVOLVE Data Tables, easily parse strings, and many other scenarios. Below is a current list of the custom EVOVLE functions that may be accessed in the Expression Editor.

String

Split

Split(source, delimiter, index, [trimValues], [limitReturnCount])

Divides the source into segments based on the delimiter and returns the segment at the specified index (0 based).

If the index is invalid, null is returned.

- trimValues (optional true/false) specifies if the segment values should be trimmed of leading/trailing spaces (default is true)

- limitReturnCount (optional integer) returns up to this many segments. The final segment will contain any remaining delimiters

Revit

GetDataTableDescription

GetDataTableDescription(tableName)

Gets the user description for the provided tableName as provided in Report Manager.

GetDataTableLastUpdated

GetDataTableLastUpdated(tableName)

Gets the timestamp of when the provided tableName data was last updated.

GetDataTableMetadata

GetDataTableMetadata(tableName)

Gets the user provided meta data for the specified tableName.

GetDataTableValue

GetDataTableValue(tableName, columnName, [filterExpression], [sortExpression])

Returns a value from Data Tables with the provided tableName. The value returned is that of the specified columnName of the first record matching the provided filterExpression and/or sortExpression.

NOTE: This function queries the data stored within the model directly. As such, tableName should be the name of the respective table within Data Tables.

The respective tableName does not have to be included within the report in order for this function to access it.

- tableName = Existing table entry within Data Tables to query

- columnName = Column name within tableName which contains the value to retrieve

- filterExpression (optional string) 'Select' filter expression for use within a .NET DataTable. ex: "[Name]='My Part' AND [Left Length] > 1"

- sortExpression (optional string) Sort expression for use within a .NET DataTable. ex: "[Col 1] ASC, [Col 2] DESC"

GetDataTableValue_AlmostEqualToCondition

GetDataTableValue_AlmostEqualToCondition(columnName, numericValue, [tolerance])

Convenience method which creates a filter condition for use with the GetDataTableValue function. The resulting filter allows for comparing high precision decimal values accounting for some tolerance.

For example, providing a value of 1.5 with a 0.001 tolerance would create a condition searching for values between 1.499 and 1.501.

- columnName = Column name containing the numeric value to compare against

- numericValue = Target value to locate. This is expected to be a decimal value

- tolerance (optional decimal value) Value to account for precision/rounding variances between the target value and the column being searched. Default value is 0.0001

ToAirFlowDisplay

ToAirFlowDisplay(value)

Takes in a numeric value and returns the AirFlow measurement display value honoring the Project Units set in the respective Revit project.

ToAirFlowValue

ToAirFlowValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store AirFlow values.

ToAngleDisplay

ToAngleDisplay(value)

Takes in a numeric value and returns the Angle measurement display value honoring the Project Units set in the respective Revit project.

ToAngleValue

ToAngleValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Angle values.

ToAreaDisplay

ToAreaDisplay(value)

Takes in a numeric value and returns the Area measurement display value honoring the Project Units set in the respective Revit project.

ToAreaValue

ToAreaValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Area values.

ToCableTraySizeDisplay

ToCableTraySizeDisplay(value)

Takes in a numeric value and returns the CableTraySize measurement display value honoring the Project Units set in the respective Revit project.

ToCableTraySizeValue

ToCableTraySizeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store CableTraySize values.

ToConduitSizeDisplay

ToConduitSizeDisplay(value)

Takes in a numeric value and returns the ConduitSize measurement display value honoring the Project Units set in the respective Revit project.

ToConduitSizeValue

ToConduitSizeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store ConduitSize values.

ToCurrencyDisplay

ToCurrencyDisplay(value)

Takes in a numeric value and returns the Currency measurement display value honoring the Project Units set in the respective Revit project.

ToCurrencyValue

ToCurrencyValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Currency values.

ToDuctInsulationThicknessDisplay

ToDuctInsulationThicknessDisplay(value)

Takes in a numeric value and returns the DuctInsulationThickness measurement display value honoring the Project Units set in the respective Revit project.

ToDuctInsulationThicknessValue

ToDuctInsulationThicknessValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store DuctInsulationThickness values.

ToDuctLiningThicknessDisplay

ToDuctLiningThicknessDisplay(value)

Takes in a numeric value and returns the DuctLiningThickness measurement display value honoring the Project Units set in the respective Revit project.

ToDuctLiningThicknessValue

ToDuctLiningThicknessValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store DuctLiningThickness values.

ToDuctSizeDisplay

ToDuctSizeDisplay(value)

Takes in a numeric value and returns the DuctSize measurement display value honoring the Project Units set in the respective Revit project.

ToDuctSizeValue

ToDuctSizeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store DuctSize values.

ToElectricalCurrentDisplay

ToElectricalCurrentDisplay(value)

Takes in a numeric value and returns the ElectricalCurrent measurement display value honoring the Project Units set in the respective Revit project.

ToElectricalCurrentValue

ToElectricalCurrentValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store ElectricalCurrent values.

ToElectricalPowerDisplay

ToElectricalPowerDisplay(value)

Takes in a numeric value and returns the ElectricalPower measurement display value honoring the Project Units set in the respective Revit project.

ToElectricalPowerValue

ToElectricalPowerValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store ElectricalPower values.

ToHvacPressureDisplay

ToHvacPressureDisplay(value)

Takes in a numeric value and returns the HvacPressure measurement display value honoring the Project Units set in the respective Revit project.

ToHvacPressureValue

ToHvacPressureValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store HvacPressure values.

ToLengthDisplay

ToLengthDisplay(value)

Takes in a numeric value and returns the Length measurement display value honoring the Project Units set in the respective Revit project.

ToLengthValue

ToLengthValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Length values.

ToMassDensityDisplay

ToMassDensityDisplay(value)

Takes in a numeric value and returns the MassDensity measurement display value honoring the Project Units set in the respective Revit project.

ToMassDensityValue

ToMassDensityValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store MassDensity values.

ToMassDisplay

ToMassDisplay(value)

Takes in a numeric value and returns the Mass measurement display value honoring the Project Units set in the respective Revit project.

ToMassValue

ToMassValue(value)(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Mass values.

ToPipeDimensionDisplay

Takes in a numeric value and returns the PipeDimension measurement display value honoring the Project Units set in the respective Revit project.

ToPipeDimensionValue

ToPipeDimensionValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store PipeDimension values.

ToPipeInsulationThicknessDisplay

ToPipeInsulationThicknessDisplay(value)

Takes in a numeric value and returns the PipeInsulationThickness measurement display value honoring the Project Units set in the respective Revit project.

ToPipeInsulationThicknessValue

ToPipeInsulationThicknessValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store PipeInsulationThickness values.

ToPipePressureDisplay

ToPipePressureDisplay(value)

Takes in a numeric value and returns the PipePressure measurement display value honoring the Project Units set in the respective Revit project.

ToPipePressureValue

ToPipePressureValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store PipePressure values.

ToPipeSizeDisplay

ToPipeSizeDisplay(value)

Takes in a numeric value and returns the PipeSize measurement display value honoring the Project Units set in the respective Revit project.

ToPipeSizeValue

ToPipeSizeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store PipeSize values.

ToRotationDisplay

ToRotationDisplay(value)

Takes in a numeric value and returns the Rotation measurement display value honoring the Project Units set in the respective Revit project.

ToRotationValue

ToRotationValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Rotation values.

ToSlopeDisplay

ToSlopeDisplay(value)

Takes in a numeric value and returns the Slope measurement display value honoring the Project Units set in the respective Revit project.

ToSlopeValue

ToSlopeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Slope values.

ToSpeedDisplay

ToSpeedDisplay(value)

Takes in a numeric value and returns the Speed measurement display value honoring the Project Units set in the respective Revit project.

ToSpeedValue

ToSpeedValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Speed values.

ToTimeDisplay

ToTimeDisplay(value)

Takes in a numeric value and returns the Time measurement display value honoring the Project Units set in the respective Revit project.

ToTimeValue

ToTimeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Time values.

ToVolumeDisplay

ToVolumeDisplay(value)

Takes in a numeric value and returns the Volume measurement display value honoring the Project Units set in the respective Revit project.

ToVolumeValue

ToVolumeValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Volume values.

ToWattageDisplay

ToWattageDisplay(value)

Takes in a numeric value and returns the Wattage measurement display value honoring the Project Units set in the respective Revit project.

ToWattageValue

ToWattageValue(value)

Takes in a text/formatted display value and returns the numeric value which Revit uses internally to store Wattage values.

Global

GetGlobalNumber

GetGlobalNumber(name)

Returns the global number value with the specified name which was previously set by SetReportVariableNumber.

If the name provided has not been previously set, 0 is returned.

GetGlobalString

GetGlobalString(name)

Returns the global string value with the specified name which was previously set by SetReportVariableString.

If the name provided has not been previously set, null is returned.

SetGlobalNumber

SetGlobalNumber(name, value)

Sets a global number variable with the provided name to the specified value so it can later be retrieved by GetReportVariableNumber.

Returns the value which is set.

SetGlobalString

SetGlobalString(name, value)

Sets a global string variable with the provided name to the specified value so it can later be retrieved by GetReportVariableString.