Stored Procedure to combine detail rows

From: <vick9935_at_my-dejanews.com>
Date: Thu, 09 Jul 1998 20:20:25 GMT
Message-ID: <6o38m9$7ua$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

Thanks in advance,

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 - 15:20:25 CDT