Dinamic page footer

Massimo Sommaruga

Hi,
I would like to create in my report a page footer (in every page) containing different rows; the number of rows depends on the data displayed on the same page and cant be predicted at the beginning.

For example in marketing documents:

=====================
-------Page1
Item group quantity
00 A 10
11 B 5
22 A 20

-------footer page 1----
Subtotal:
Group A: 30
Group B: 5
=====================
-------Page2
Item group quantity
33 A 10
44 A 10
55 C 7

-------footer page 2----
Subtotal:
Group A: 50 ¦ the number of rows should change on
Group B: 5 ¦ every page and cant be known at the
Group C: 7 ¦ start
=====================


Is it possible with the tool now available in the report designer?

Thanks.

Manuel Grenacher

Hi Massimo

You have do define 2 Aggregates

Sum1: (RunningSum)
Expression->DataBand("Quantity")
Groups -> 1-> DataBand("Group")
RunningSum -> True

Sum2
Expression->DataBand("Quantity")
Groups -> 1-> DataBand("Group")
2-> PageNumber
RunningSum -> False



On Header you can get the Sum with: YourDataBand.Sum("Sum1", DataBand("Group"))

On The PageFooter: YourDataBand.Sum("Sum1", DataBand("Group")) + YourDataBand.Sum("Sum2", DataBand("Group"),PageNumber)

Massimo Sommaruga

Hi Manuel,
thanks for your suggestion, but it doesn't work... with the aggregates you told to me to define I can see only 1 value in the page footer...
Even if in the page there are more than 1 group, on the page footer I see only 1 value...

I think that if you insert a field with the value DataBand("Group") in the page footer you can see only one value...
page footer is not like a databand in which i can see more records by the detail object.
Therefore, the formula YourDataBand.Sum("Sum1", DataBand("Group")) + YourDataBand.Sum("Sum2", DataBand("Group"),PageNumber) can return only 1 value.

It's wrong?

What i could do to solve my issue?

THK

Regards.


Massimo

Philipp Knecht

Hi

What i can offer is:

=====================
-------Page1
Item group quantity
00 A 10
11 B 5
22 A 20

Subtotal:
Group A: 30
Group B: 5
=====================
<NewPage>
...


-> There is no possiblity to create an dynamic Pagefooter togehter with PageSums.

hth