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