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,