Variable Report Headers

[mbehna]

I have to create a report where the header data changes on a page by page basis due to page break conditions.
I have all the data I need but can't seem to figure out how to force the report title to change!?

The report page breaks on groups and I need to display the group name in the report header/title. For example, the first group is "Personnel Dept", the second is "Marketing Dept", etc...

I know how to display these as column/group headers but I can't seem to figure out how to modify report headers...

Can anyone help me?

Thanks in advance to all who respond.

 

[nagornyi]

1. Create report parameter p_title.
2. In the group that contains group names create formula column CF_title_assignment with the following formula:

function CF_title_assignmentFormula return Number is
begin
_title := ut_your_group_name_field_here;
return 1;
end;

3. Put a field in the report header and source it with the p_title.

This approach creates headers on all pages but the first one. To create the first header you need to know what would be the name of the first group. That is a separate problem, but often it is known in advance. Let me know if finding the first group name is any problem.