Repeating Columns Headings in Oracle Report?

From: Eric Raskin <eraskin_at_paslists.com>
Date: Tue, 11 Apr 2000 10:01:45 -0400
Message-ID: <sf6ctsogcqv87_at_corp.supernews.com>

Hello:

  I'm trying to get a set of column headings to repeat over the top of a
"down/across" repeating frame.

  The query generates data that looks like this:

    AZ 100
    NY 150
    CT 225

     .         .
     .         .

  I want the report to look like this:

  State   Count      State   Count   .... (as many times as necessary)
    AZ      100        WY      150
    CT      225        VT       175
     .           .
     .           .

  where the first column is filled in completely, then the second column, then the third, etc. Column headings should appear at the top of each column with data in it. There's no need for column headings on columns without data.

  Currently, I have an "across" repeating frame printing the headings, and a
"down/across" repeating frame printing the data. They are based on the same
group, which contains the queried data. The problem is that the "across" repeating frame prints out for each row of the data group, not each column printed. So, I get pages and pages of column headers (one column heading for each data row). Obviously, that's not what I need...

  Ideally, a total summing up the count in all columns should appear at the end of the last column with data. I've temporarily put it in the Margin (at the top of each page), since I couldn't get it to float properly.

  Can anyone tell me how to do this correctly?

  TIA

---

Eric H. Raskin
eraskin_at_paslists.com

Professional Advertising Systems Inc.          Voice: 914-741-1100
70 Memorial Plaza                                      Fax:   914-741-2788

Pleasantville, NY 10570 Received on Tue Apr 11 2000 - 16:01:45 CEST