Once you have created a BusinessObjects report you may want to re-run it so that you can retrieve different information. The report structure will stay the same and just the contents will change. A static header may not always accurately describe the contents of the report. Using the formula editor, you can quickly create a header that will change according to the contents of your report.

The example below looks at a report that has returned the number of Japanese students, the courses they have enrolled in and the faculties for those courses. For this type of report, a prompt could be used in the query so that the report could be run for different countries. In this event, the heading would need to be dynamic so that it changed according to whatever country was selected.

1. Click on the header cell once with the mouse and then click on the Formula Editor button. The Formula Editor window will open.
   
   
   
   
2. Double click on the equals to sign in the Operators section on the right hand side. Type "No. of students from " and be sure to include the quotes.
   
   
   
   
3. Double click on the ampersand character (&) in the Operators section on the right hand side. Expand the Aggregates folder in the Functions section by clicking once on the plus sign next to it.
   
   
   
   
4. Double click on the Max function. You will see it added to the formula statement.
   
   
   
   
5. Double click on the Permanent Residence Location object in the Variables section on the left hand side. Click on the OK button to finish.
   

The report heading will now be updated to reflect whatever country is chosen when running the query.