cancel
Showing results for 
Search instead for 
Did you mean: 

How to display a Text that's in a formula on the first Page only?

alpha_sow
Participant
0 Kudos

Hello

  I have a report that has

report header

page header

Group header #1 a, on this (group header # 1a) it's grouping by a customer no and on this group i have a formula which has some text(it's a letter) and I display the letter then below the letter I have

Group Header #2 a. where I display one line that has an address information then

Group Header #2 b. this has the header information things like, invoice_no,invoice_date,amount, currency. then

Group Header #3. this has the currency(no show) then

Group Header #4. this display the currency code either, USD or CHF or EUR then below this is

the Details : this has the detail of what is on Group Header #2 b, the, invoice_no,invoice_date,amount,currency then I have

Group footer #4

Group footer #3: this is the currency where I have a total by currency

Group footer #2

Group footer #1 : this is the customer no


Now the question, sometimes I may have a lot of records(invoices) to be display on the detail and this may run into 2,3 may be 4 pages, how can I display the Text(letter) that's on group header #1 only on the first ?

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

Go to the Section Expert.  For the GH1 section, click on the formula button to the right of the Suppress checkbox (DO NOT check the checkbox!) and enter the following:

InRepeatedGroupHeader

This will suppress that section on subsequent pages if the group value is the same as the previous page.

-Dell

alpha_sow
Participant
0 Kudos

Can I ask another on this same question, for the same report  I used to have Total on the Group footer #1 but at that time I did not know there more than one currency for the same customer so I added a group by under the currency, how can I display the Total per currency at the footer level?

DellSC
Active Contributor
0 Kudos

Per the SCN Rules of Engagement, you really need to ask this as a new question.

Thanks!

-Dell

Answers (1)

Answers (1)

alpha_sow
Participant
0 Kudos

Thank you, that did it for me, thank you much for your help