Matrix Report Problem

From: Laura Tonesi <Laura_Tonesi_at_lf1.ccmail.compuserve.com>
Date: 1996/11/06
Message-ID: <3280EEED.4D40@lf1.ccmail.compuserve.com>#1/1

Hi everybody,

I have been wrestling with Oracle REPORTS to create the following:

group = Metals           container1   container2
  calcium                   .6           .9
  cobalt                                 .3            
group = Gasses           container1   container2
  chlorobenzene                          .5

This is what I get:
group = Metals           container1   container2
  calcium                   .6           .9
  cobalt                                 .3            
group = Gasses           container2
  chlorobenzene             .5          !!!!!?

The column get shifter over because there are no records for gasses in container2. But this aint a matrix.

How do I get Oracle REPORTS _NOT_ to reset at group level?
Or, does anybody know a good client/server REPORT GENERATOR (for win95) that works well with an Oracle database?

Thank you very much for your help. Received on Wed Nov 06 1996 - 00:00:00 CST