Goal:
I need to display a final value of a string variable in the Footer of each group of a report or display it only in the Last record of each group. Let’s call the variable I need to display ConList.
The ConList variable is defined in the Code tab of the Report Properties as a shared variable. I created a function that formats the ConList (concatenates string values). Each record of the group contributes to this ConList variable. The number of rows in the group varies.
Example:
This example shows how 4 records in the group contribute to the ConList variable (with partial stages of the creation)
The "Item" is a value that contributes to the ConList
Item ConList
Row1: A A
Row2: B AB
Row3: C ABC
Row4: D ABCD
So, I want to write the last value: ABCD
All other rows should be hidden(Rows 1 - 3 are not displayed to the user).
This means I need to either
1. Conditionally hide ConList in each row but Row4.
or
2. Display a final value of the ConList, ABCD in the Footer of the group.
Problems I have:
1. I don’t know how to write the condition for the last record in a group.
2. The Footer of the group doesn’t know the value of the ConList yet (only the initial empty string). It looks like the Footer of the next group knows the value of the ConList from the previous group. How do I make the footer of the current group evaluate ConList (after the last Row)?
I need to display a final value of a string variable in the Footer of each group of a report or display it only in the Last record of each group. Let’s call the variable I need to display ConList.
The ConList variable is defined in the Code tab of the Report Properties as a shared variable. I created a function that formats the ConList (concatenates string values). Each record of the group contributes to this ConList variable. The number of rows in the group varies.
Example:
This example shows how 4 records in the group contribute to the ConList variable (with partial stages of the creation)
The "Item" is a value that contributes to the ConList
Item ConList
Row1: A A
Row2: B AB
Row3: C ABC
Row4: D ABCD
So, I want to write the last value: ABCD
All other rows should be hidden(Rows 1 - 3 are not displayed to the user).
This means I need to either
1. Conditionally hide ConList in each row but Row4.
or
2. Display a final value of the ConList, ABCD in the Footer of the group.
Problems I have:
1. I don’t know how to write the condition for the last record in a group.
2. The Footer of the group doesn’t know the value of the ConList yet (only the initial empty string). It looks like the Footer of the next group knows the value of the ConList from the previous group. How do I make the footer of the current group evaluate ConList (after the last Row)?