Skip to Content
0
Former Member
Dec 03, 2009 at 09:39 AM

How to place aggregated fields in the page header or group header

35 Views

Hi,

i have a report where in i have to display a header based on the aggregated value of a field

currently the field has values like

row1 blank

row2 blank

row3 Cookies

row4 blank

I wanted to know how to get the maximum of these rows in the page header i.e. it should come as Cookies for this case.

Is there any way to get this? it is easy in the footer where i can do a maximum of this field and get the value but not sure how to get this in the group header.How do we group maximum at the page header or group header?

Require your help on this at the earliest.

Thanks

Shilpi