1. Sofhin Wong
  2. PowerBuilder
  3. Monday, 8 May 2023 07:06 AM UTC

Hi all

I want to show Page number once in the page.

I put my compute_1 in my group 1. So whenever full_name changes, it shows compute_1

 

The reason why I put compute_1 in group 1 as it is requested by user. Can't change.

 

But I wanna make it shows only once in the page. Currently it will shows three compute_1 if I have three different full_name and reference_no.

 

Any idea? Any input is highly appreciated.

 

René Ullrich Accepted Answer Pending Moderation
  1. Monday, 8 May 2023 10:21 AM UTC
  2. PowerBuilder
  3. # 1

Try this as expression for the visible property:

if (page() = cumulativeSum( page() for page), 1, 0 )
Comment
  1. Markus Eckert
  2. Tuesday, 9 May 2023 06:03 AM UTC
You're right, the page() function isn't strictly necessary. The clever part lies in the use of the cumulativeSum( ... for page ) function.

The following function would have the same effect:



if( 1 = cumulativeSum( 1 for page), 1, 0 )
  1. Helpful 2
  1. René Ullrich
  2. Tuesday, 9 May 2023 06:07 AM UTC
Yes, this is much easier.
  1. Helpful 1
  1. Sofhin Wong
  2. Tuesday, 9 May 2023 08:11 AM UTC
Wow, thanks so much for the info!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.