How to use the built-In expression IsFirstRepeatedCrossProduct and IsLastRepeatedCrossProduct?

How to use the built-In expression IsFirstRepeatedCrossProduct and IsLastRepeatedCrossProduct?

FIRST CREATED ON 19 May 2023  I  AUTHOR Emma Camacho

IsFirstRepeatedCrossProduct
IsFirstRepeatedCrossProduct(<repeater code>)

The function returns True if the current repeated value is the first one to be processed.

IsLastRepeatedCrossProduct
IsLastRepeatedCrossProduct(<repeater code>)

The function returns True if the current repeated value is the last one to be processed.

Example

A Report that will display all the Product group descriptions and add a prefix to the first and the last value to be processed.



The Conditional Element first has the following expression: IsFirstRepeatedCrossProduct("ProductGroupDesc")


The Conditional Element last has the following expression: IsLastRepeatedCrossProduct("ProductGroupDesc")



The output Report looks like this:


These expressions are useful, for example, to control the last page break in a report.

Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.


    • Related Articles

    • How to use the built-In expression DoesReportDocumentExist?

      FIRST CREATED ON 19 May 2023 I AUTHOR Emma Camacho Does Report Document Exist DoesReportDocumentExist(<report_document_name>) The function returns True if a report document with the given name exists in the current context (e.g. if a report document ...

    • What are Dynamic Values and how to use them in Mail & Deploy?

      FIRST CREATED 17 May 2023 I AUTHOR Emma Camacho Expressions are dynamic values - values which are dynamically obtained by the expression at the time of its evaluation. Example: You want to add a text report element to a report and you want the text ...

    • What are Constant Values in Mail & Deploy and how to use them?

      FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho If you want to use a constant, non-calculated value in an expression, you can do this by using the following syntax, which depends on the data type of the constant you want to use. Text If you want ...

    • How to use constant values and dynamic values in data types?

      FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho Depending on the data-type of the constant value (see Constant Values) or dynamic value (see Dynamic Values), you can access certain properties of the value and/or manipulate it. Date-Time More ...

    • How to make use of Modules in Mail & Deploy?

      FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho You can also write your own Visual Basic .NET code in a module. A module is a set of Visual Basic .NET code that contains functions to be used from any expression within the repository. This allows ...