Building a Discoverer Report

The following pages walk through an example of creating a Discoverer report from scratch. As an extremely simple example, let s say I want to build a Discoverer Report of my CD collection. Although it s overkill for an example this simple, let s work off the following tables:

 create table artists (artist_id       number             primary key, artist_lname    varchar2(30)       not null, artist_fname    varchar2(20)); create table genres (genre_id        number            primary key, genre           varchar2(20)      not null); create table sub_genres (sub_genre_id    number            primary key, sub_genre       varchar2(20)      not null); create table cds (cd_id           number            primary key, artist_id       number constraint artist_id_fk references artists (artist_id), genre_id        number constraint genre_id_fk references genres (genre_id), sub_genre_id    number constraint sub_genre_id_fk references sub_genres (sub_genre_id), title           varchar2(30)       not null, rating          number); 

To populate the tables, I ran the following insert statements:

 insert into artists values (1,Morrison,Van); insert into artists values (2,Counting Crows, null); insert into artists values (3,Beatles, The, null); insert into artists values (4,Coltrane,