Sum Textbox Values

[VetlinkPRO]

Hi there,

I have a textbox which holds a lowest price for a group of products (calculated using data fields). Then I would like to sum them  and display the total in the page footer. How do I achieve this?

Here is the structure of my report:
Header
    Product Brand (Group)
        Products
            1
            2
            3
            ...
            textbox (lowest price)
    (Group End)
Footer ( show total lowest price)


Any help would be appreciated.
Chi

[Hrisi]

Hi Chi,

Page sections (Header/Footer) are independent from the report sections and its layout. To use aggregates in them is not possible because they are bound after the report is processed.

The aggregates can be placed in the report sections. If the aggregate is placed

• In the Report Header/Footer sections, they will operate on the whole set of report data.
• In the Group Header/Footer it summarizes detail data included in each  group member. If the group is unbound (no grouping criteria) the engine uses its parent grouping criteria or the whole data if  the unbound group is a root group.
• In the Detail section it should summarize only one detail data an thus it does not have much sense.

Because you can set for the report and group sections PrintOnEveryPage=True you can have the aggregate shown on every page.

Regards,
Hrisi
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.