Tutorials

There are a number of tutorials that demonstrate various aspects of the NuVu Query Designer.

The standard repository that is loaded as part of the normal server install contains a single datasource, called Sports2000 that points to a physical database called c:\temp\Sports2000.db, but this database needs to be created on disk before the tutorials can be run against that database.

To create this Sports2000 database is a fairly painless task, which is described here in detail:

• There should be an OpenEdge (or Progress) program group available from the ‘Start’ menu of Windows. Select this option and then look for an item called‘ProEnv’ and click it – a standard windows command prompt should be displayed
• The ‘c:\temp’ folder must exist so type this from the command prompt to ensure that it does: mkdir c:\temp (and press ENTER afterwards) – you may get a message that indicates the folder already exists – this can just be ignored
• Type the following to create a copy of the Sports2000 demonstration database: prodb c:\temp\Sports2000 EMPTY (and press ENTER afterwards). Ensure that you have specified the name EXACTLY – with case-sensitivity – ie: Capital S plus ‘ports2000′
• A message(s) should be displayed from the prodb utility indicating that the database has been created
• Type ‘exit’ (and press ENTER) to close down the ‘ProEnv’ session – the database is created and should now be available for use with the various tutorials that are described below

Tutorial Links

1. Simple customer selection, sorted by Country
2. Adding grouping to the query
3. Adding a simple calculated field to the query
4. Adding a filter to restrict the rows that are returned to the query
5. Joining multiple tables and showing in a single results grid
6. Split Joined Tables to show in separate grids
7. Adding a calculated field that shows a count of children for each parent
8. Adding a chart to the query
9. Adding a filter that prompts for a value at runtime
10. Report Design: Changing the spacing of sections
11. Report Design: Adding rectangles and text objects
12. Report Design: Conditional formatting of field objects within a report
13. Report Design: Adding a chart to the report
14. Creating a schedule for a query
15. Creating your first Dashboard
16. Adding an Object to the Dashboard
17. Adding an RSS Feed Object to the Dashboard
18. Creating a chart based on ‘Selected Columns’
19. Fine-Tuning properties of a chart
20. Adding a Knob Dial chart to your query
21. Local Filtering and Searching on the result set
22. Maintaining Favorites (Prompts/Calculated Fields/Filters)