Download Report Studio User Guide

Chapter 6: Try It Yourself Exercises
If you have some experience with Report Studio and want to improve your skills in report writing,
this chapter is for you. Each topic gives you some guidelines on how to create each sample report.
If you need help, links to more detailed instructions are available.
If you have not used Report Studio before, see the Report Studio Tour first to learn basic skills.
Try It Yourself - Create a List Report
Use list reports to show detailed information from your database, such as product lists and
customer lists.
In this topic, you learn how to create a list report that shows revenue for each product for the last
quarter of 2002.
It should take 15 to 20 minutes to complete this topic, and your report will look like this.
Steps
1. Create a new list report that uses the sample package named GO Sales and Retailers and the
sample template named GO-list.
2. Add the following data items to the report:
• Order number (in Orders)
• Order date (in Orders)
• Product type (in Products)
• Product name (in Products)
• Quantity (in Orders)
Tip: Use the source tab in the Insertable Objects pane.
3. Create this query calculation named Revenue:
[gosales_goretailers].[Orders].[Unit price] * Quantity
Tip: Use the toolbox tab in the Insertable Objects pane.
User Guide 173