Emulate Oracle SQL*Plus break on skip1 in LiveReport

Does anyone know a cleaver way to emulate the SQL*Plus break on column_name skip 1 in a LiveReport? I'm listing (and ordering) users by primary group (GROUPID) and I want a blank line between each group. Thanks,- Mark

Find more posts tagged with

Comments

Tim_Hunter

Mark I can't think of a way to do this in LiveReports, but I have done this in WebReports (if you have it) by just a simple check of the previous row and not printing if its the sameFor reference to non oracle users or to anyone who doesnt know what break on skip does. it avoids repeating the leading attribute of a sorted output

Mark Runyan

Thanks Tim, yes WebReports is on my wish list! Note the Skip 1 command also separates the groups by with a blank line. Sometimes makes the separate groupings more obvious. - Mark