Re: Formatting query results

Hello Martin,

Ever considered using Excel for layouting your result set ?

I've written a utility called Oraxcel with which you can fetch data straight into your Excel spreadsheet. Then you can use the sorting/layout facilities in Excel and print it to wherever you want it.

The functionality is fully present in the LITE version of Oraxcel. The LITE version is completely free and can be gotten from

http://members.aol.com/gjlinker

On the site there is extensive documentation on Oraxcel: Screen prints / Demo's / Free LITE version download

Kind regards, Gerrit-Jan Linker

In article <77ii9k$kfr$1_at_hdxf08.telecom.ptt.nl>,   Martin <I.want_at_no.mail> wrote:
> Hi all,
>
> I'm trying to format the following query:
>
> SET HEADING ON
> SET PAGESIZE 10000
> CLEAR BREAKS
> COLUMN MAAND FORMAT A9
> COLUMN JAAR FORMAT A4
> COLUMN MAANDNR NOPRINT
> COLUMN NET FORMAT A4
> BREAK ON JAAR SKIP 2 NODUP
> BREAK ON NET SKIP 1 NODUP <---- This is no use :-(
>
> SELECT TO_CHAR(VKV_TELDATUM, 'YYYY') JAAR
> ,VKV_NET_VAN NET
> ,TO_CHAR(VKV_TELDATUM, 'MONTH') MAAND
> ,TO_CHAR(VKV_TELDATUM, 'MM') MAANDNR
> ,COUNT(*) AANTAL
> FROM BAAS_VERKEER
> GROUP BY TO_CHAR(VKV_TELDATUM, 'YYYY')
> ,VKV_NET_VAN
> ,TO_CHAR(VKV_TELDATUM, 'YYYY')
> ,TO_CHAR(VKV_TELDATUM, 'MM')
> ,TO_CHAR(VKV_TELDATUM, 'MONTH');
>
> I get this:
>
> 1997 AAAA JANUARY 1116
> AAAA FEBRUARY 771
> .
> .
> AAAB JANUARY 45
> AAAB FEBRUARY 46
> .
> .
>
> etc
>
> 1998 AAAA JANUARY 1116
> AAAA FEBRUARY 771
> .
> .
> AAAB JANUARY 45
> AAAB FEBRUARY 46
> .
> .
>
> etc
>
> But I want this:
>
> 1997 AAAA JANUARY 1116
> FEBRUARY 771
> .
> .
> AAAB JANUARY 45
> FEBRUARY 46
> .
> .
>
> etc
>
> 1998 AAAA JANUARY 1116
> FEBRUARY 771
> .
> .
> AAAB JANUARY 45
> FEBRUARY 46
> .
> .
>
> etc
>
> I understand only one break can be defined at one time,
> but is there a way to get the layout I want ? (with or without breaks).
>
> TIA,
>
> Martin
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 16 1999 - 10:21:25 CST