Stored Procedure to combine result set rows

From: <vick9935_at_my-dejanews.com>
Date: Thu, 09 Jul 1998 16:55:47 GMT
Message-ID: <6o2smk$il2$1@nnrp1.dejanews.com>

Eliminating report white space

I would like to eliminate "white space" in a report; in essence, I want the equivalent of combining the contents of rows at the detail level.

Now here is the result of the report (I am getting the "column headings" by using DECODE on date columns ie DECODE(TO_CHAR("FORECAST_DATE",'MON YYYY'),'JAN '||:AS_FISCALYR,1,0) "JANFCST"):

                J       F       M ->
Activity #1     Site1
                Site2
                        Site3
                                Site4
                Site5
                                Site6
Activity #2             Site1
                                Site2
                                Site3
                        Site5

Here is what I want:

                J       F       M ->
Activity #1     Site1   Site3   Site4
                Site2           Site6
                Site5
Activity #2             Site1   Site2
                        Site5   Site3

Any ideas? All help is greatly appreciated.

Brian in Seattle

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 09 1998 - 11:55:47 CDT