Re: BREAK ON multiple colmns possible?
From: Mechanical Mann <eric_at_REMOVE_SPAMspeco.com>
Date: Wed, 31 Oct 2001 09:30:55 -0600
Message-ID: <9rp5hd$8o8$1_at_bob.news.rcn.net>
Date: Wed, 31 Oct 2001 09:30:55 -0600
Message-ID: <9rp5hd$8o8$1_at_bob.news.rcn.net>
Each BREAK command clears the previous one. Therefore you must combine all breaks into 1 BREAK statement.
BREAK ON col_1 SKIP PAGE ON col_2 SKIP 1
This statement will cause a new page on col_1 values and a space on col_2 values.
"Bernd" <bernd_at_jaegle.de> wrote in message
news:984054a2.0110310008.60cc0cf8_at_posting.google.com...
> Hi SQL-Gurus,
>
> I have to build a report and I want to do a break on more than one column.
> I only have found out how to do it for one column.
>
> BREAK ON column1
>
> Does anyone know how to do this.
> Thanx in advance.
>
> best regards,
> Bernd
Received on Wed Oct 31 2001 - 16:30:55 CET