Skip to Content

If you are created the complicated report for one department and another department wants the same report, only with their logo and department header information. Based on the parameter we can change the page header information. We can use the xtreme database and filtering/displaying information based on the country.

1. Open your report.
2. From the design tab,  right click on ‘Page Header’ and click on ‘Insert section below’. The page header will now be divided into two sections, ‘Page Header a’ and ‘Page Header b’

image1

3. Within Page Header a and b, insert your images, text, heading, and column header information for each section.  In my example below, I am using two counties,  Canada and France.

image2

4. Now create a parameter that will control which Page Header which to display at run time.  From the Field Explorer, right click on ‘Parameter Fields’ and click on ‘New’

image3

 

5. Set your parameter as a ‘String’ type and ensure that it is static.  In this example, I’ve added two default values, Canada and France, while ensuring that ‘Allow multiple values’ is set to false.

image4

6. Incorporate your parameter into your select statement,   From the tool bar, click on ‘Report’, ‘Select Expert’.

7. In the field dialog box, select Country (in this example) , then click OK
8. Choose the parameter from the drop-down list. {?Country} and click OK.

image5

Select parameter:

image6

 

9.  From the design tab,  right click on ‘Page Header a’ and click on ‘section expert’.
10. Ensure that ‘Page Header a’ is highlighted, and click on the ‘X-2’ icon tot he right of ‘Suppress (No Drill-Down)

image7

11. In the Formula workshop, under Report Fields, double click on your parameter.  In my example, The information for Canada was in report header a, France b. You will want your parameter to not equal itself.   Repeat this step for each page header section you recreated.

image8

12. Save and Close
13. Press F5 to refresh your report, selecting your parameter value when prompted

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply