Create your first Velixo report for STACK

STACK.ITEMCOSTREPORT

Created by Velixo Team, Modified on Fri, 29 Aug at 8:26 AM by Velixo Team

Applies to

Velixo NX 2025.8 or higher
STACK

Introduction

The STACK.ITEMCOSTREPORT function returns all Item Cost report records for a given project.

Syntax

=STACK.ITEMCOSTREPORT(ConnectionName, Project, TableOutputCell)

Parameters

Parameter	Required/Optional	Description
ConnectionName	Required	The name of the connection, as specified in the Connection Manager
Project	Required	Project name. Use the STACK.EXPANDPROJECTRANGE function to retrieve the list of STACK projects.
TableOutputCell	Optional	If the parameter is specified, the function output is represented as an Excel table, and the first column is populated at this address. See the Table Mirroring article for details. If the parameter is omitted, the result is returned as a spill range.

Parameter

Required/Optional

Description

ConnectionName

Required

The name of the connection, as specified in the Connection Manager

Project

Required

Project name.
Use the STACK.EXPANDPROJECTRANGE function to retrieve the list of STACK projects.

TableOutputCell

Optional

If the parameter is specified, the function output is represented as an Excel table, and the first column is populated at this address. See the Table Mirroring article for details.

If the parameter is omitted, the result is returned as a spill range.

Example

=STACK.ITEMCOSTREPORT("Stack","Second Project",A2)

Description: Returns all Item Cost report records in the Second Project project for the connection named Stack.

Result: