Samples: All group footers at end (on anew page)

Fabio Pagano · Post by **Fabio Pagano** » Wed Sep 12, 2007 2:37 am

V 2007.2

In the demo example "AllGroupFootersAtEnd" i have tried to print the final "letter" summary on a new page, but with no success.

Do you have a suggestion?

Thanks.

EDV Gradl · Post by **EDV Gradl** » Wed Sep 12, 2007 4:27 am

Set the property "Start New Page" of Column HeaderBand1 to true. Then all GroupFooters2 will print on a new page.

Marco

Fabio Pagano · Post by **Fabio Pagano** » Wed Sep 12, 2007 5:10 am

Thank you. In the new page i also need to reset page number but didn't find that property in Column HeaderBand1. Any suggestion?

Post by **Edward** » Wed Sep 12, 2007 7:12 am

Please check the Marco suggestion once more. His suggestion is correct. I've checked myself.

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Wed Sep 12, 2007 7:33 am

Marco's suggestion about newpage works, i was not referring to that.

My problem is about "PageNofM". If i draw it in columnheaderband1, there appears "Page 5 of 5" and in the previous page appears "Page 4 of 5". It's ok but i wanted that on the last page (the final "letters" summary) would appear "Page 1 of 1" and on previous page "page 4 of 4" and so on (for example "page 3 of 4" on third page).

In other words i wanted to reset page number before printing the final "letters" summary.

Example:

Total pages in reports: 5. The fifth is the summary.

First page: "Page 1 of 4"
Second page: "Page 2 of 4"
Third page: "Page 3 of 4"
Fourth page: "Page 4 of 4"
Summary (fifth) page: "Page 1 of 1"

---

Another question about this demo: how can i make see an "incidence percentage" on each summarized letter in the final summary?

Example:
Letter: A: Count: 4 Incidence: 8%
Letter: B: Count: 8 Incidence: 16%

I don't know how to calculate incidence.

Thanks.

EDV Gradl · Post by **EDV Gradl** » Wed Sep 12, 2007 8:00 am

You can set the property ResetPageNumber of GroupHeaderBand2 to true. Then it works.

Ther percentage should be: {Math.Round(100m/Customers.Count*Count(),2)}

Marco

Fabio Pagano · Post by **Fabio Pagano** » Wed Sep 12, 2007 9:10 am

EDV wrote:You can set the property ResetPageNumber of GroupHeaderBand2 to true. Then it works.

Ok, thanks for the answer. But if the summary goes on more than one page i will see on the second summary page "Page 1 of 1" (...i suppose, because i did not test).

EDV wrote:The percentage should be: {Math.Round(100m/Customers.Count*Count(),2)}

My internal report language is in VB, so the working expression is slightly different:

{Math.Round(100/Customers.Count()*Count(),2)}

Thanks.

EDV Gradl · Post by **EDV Gradl** » Wed Sep 12, 2007 9:26 am

But if the summary goes on more than one page i will see on the second summary page "Page 1 of 1" (...i suppose, because i did not test).

Then you could use the BeforePrintEvent of the GroupHeaderBand:

this.GroupHeaderBand.ResetPageNumber = this.Customer.IsBof (or is it .Bof ??)

Marco

Fabio Pagano · Post by **Fabio Pagano** » Wed Sep 12, 2007 1:12 pm

Ok, understood.

The problem is that i don't want to write internal code, because all reports will be designed by end users that don't know nothing about programming.

Anyway i think that in most cases the necessity of splitting the final summary on more than one page (caused by too much elements) is very very rare, so resetting page on group (as previously suggested) will work correctly in about 99,99% cases.

Thank you to all.

Fabio Pagano · Post by **Fabio Pagano** » Sun Sep 16, 2007 7:17 am

Now, always in "All group footers at end" demo, after i have added the percentage incidence for each letter, i would like to add a graphical bar showing that percentage. Each bar has a scale of 100 and its value is the percentage itself. I have tried with some graphics but with no result.

In the following image, in the red box i would like to make appear the horizontal bars, one for each letter:

Thanks.