How to repeat field value on page changed

Darveson Wright

I have a field on a report and suppress if duplicated works.Also condiitonal supress with fomula {TableA.FieldA} = previous({TableA.FieldA}) works. If the group continues unto the next page I want to stop the supression for the first entry..

To explain: When the group orange has to continue on next page, I want to supress duplicate of orange on first page and repeat orange at the first entry on next page. Need to translate something like this to a function: if group not change and page change then show else if current value = previous value suppress.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Darveson Wright3y ago
Thanks. I create formula as follows and place in Page Header section.
```
Global numberVar PageNumberVar;
PageNumberVar := 1;
```
Then second formula and place in Group header section
```
Global numbervar PageNumberVar;
PageNumberVar := PageNumber;
```
My knowledge of declaring variables is probably what causes the solution not to work. I achieve a similmar result by adding "If InRepeatedGroupHeader then false else true" in "Suppress" of Group Header section expert. Plus concatenate "continued " to the group header display.
+1
Deepak Rawat3y ago
To achieve the desired functionality of suppressing duplicates within a group but allowing the first entry to repeat on the next page, you can use a combination of conditional suppression and page-level variables in your reporting tool (e.g., Crystal Reports). Here's a general approach:
1. Create a page-level variable (let's call it PageNumberVar) to keep track of the current page number.
2. Within the group header section, reset the PageNumberVar to the current page number using a formula like: PageNumberVar := PageNumber;.
3. Use a conditional suppression formula in the group header section to suppress duplicates based on both group continuity and page change. The formula could look like this:
```
{TableA.FieldA} = previous({TableA.FieldA}) and PageNumberVar = PageNumber - 1
```
Explanation: The formula checks if the current value of TableA.FieldA is the same as the previous value, indicating a duplicate. Additionally, it verifies if the PageNumberVar is equal to the previous page number (PageNumber - 1). This condition ensures that duplicates are suppressed only when the group continues onto the next page.
1. In the group footer section, update the PageNumberVar to the current page number again to ensure accurate tracking throughout the report: PageNumberVar := PageNumber;.
By implementing these steps, you should be able to suppress duplicates within a group on the first page but allow the first entry to repeat on the next page when the group continues.

Please note that the specific implementation may vary depending on the reporting tool you are using. Consult the documentation or support resources for your reporting tool to understand the syntax and functionality of page-level variables and conditional suppression in that particular tool.
+1