Report Structure Activity

 

 

 

Step

Action

1. 

Activity End Result

At the end of this activity you will have configured a standard report template, as displayed above. Bands in the template determine which report items are used (title, headers, footers, details).

 

To achieve this, you:

- Select the bands to be used in the report

- Configure the height of the bands

- Tell the report what to show if no data is returned from the query

2. 

Begin by opening the Department Report you created in the previous activity and removing the Column Footer, Summary, and Page Header bands.

 

Right-click the Column Footer tree item.

3. 

Click the Delete Band menu item.

4. 

Note: The Column Footer band is removed from the report.

5. 

Right-click the Summary tree item.

6. 

Click the Delete Band menu item.

7. 

Note: The Summary band is removed.

8. 

Right-click the Page Header tree item.

9. 

Click the Delete Band menu item.

10. 

Note: All three bands are now removed from the report. Deleted bands appear in the Report Inspector as grayed-out names.

11. 

Now, change the height of the Title band.

 

Click the Title node in the Report Inspector.

12. 

Note: After selecting an item in the Report Inspector, edit its properties in the Properties panel.

13. 

Enter 30 into the Band height field.

14. 

Press [Enter] to commit the change.

15. 

Note: The Title band's height reduces to thirty pixels.

16. 

Next, select the three remaining bands and adjust their height simultaneously.

 

Click the Column Header node.

17. 

Press the [Ctrl] key and click the Detail 1 node.

18. 

Press the [Ctrl] key and click the Page Footer node.

19. 

Enter 30 into the Band height field.

20. 

Press [Enter] to commit the change.

21. 

Note: The bands' heights are now thirty pixels.

22. 

Note: Only bands that appear in the report are active in the Report Inspector. Bands that do not appear in the report are grayed out.

23. 

Now, configure the report to display a message when the query returns no records from the database.

 

First, right-click the No Data node to add it to the report and make the No Data band visible.

24. 

Click the Add Band menu item.

25. 

Note: The No Data band now appears in the report. The No Data band also appears active in the Report Inspector.

26. 

Next, from the Report Elements palette, drag a Static Text element into the No Data band. If the palette is not visible, select it from the main Window menu.

27. 

Note: The Static Text element appears in the No Data band.

28. 

Double-click the Static Text element to edit the text.

29. 

Enter The report returned no records. into the Static Text element.

30. 

Press [Enter] to commit the change.

31. 

Note: The Static Text element displays the message.

32. 

Drag to expand the length of the Static Text field so the entire sentence displays.

33. 

Note: The Static Text element displays all the text.

34. 

Next, configure the report to display the No Data message when the query returns no data.

 

At the top of the Report Inspector, click the department_report node to select it.

35. 

Click the When No Data drop-down button in the Properties Panel to activate the menu.

36. 

Click the No Data Section list item to activate the No Data band.

37. 

Next, save the report.

 

Click the Save button.

38. 

Congratulations!

 

You successfully removed and configured bands, and created a No Data message.

End of Procedure.