Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Question Unanswered: BREAK command question (about multiple columns)

    I am wondering if it is possible to do a break on multiple columns. Right now Im just concatenating the columns, and it looks a bit messy, so if its possible to break on multiple columns I think the appearance would be a bit more nicer looking.

    Ive tried doing something like

    BREAK column1, column2,....

    select column1, column2,....

    but that doesn't work.

    also have tried

    BREAK column1
    BREAK column2
    ...

    but that also doesn't work.


    If there is a way to do this, please let me know thank you.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  2. #2
    Join Date
    Jan 2003
    Posts
    35
    Just a correction,

    When I said:
    BREAK ......

    I meant
    BREAK ON ......

    I just forgot to put "ON"
    in the last post.

    Also, is there anyway of doing a sub break, with possibly a sub compute as well?
    Last edited by okiiyama; 03-12-04 at 18:31.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  3. #3
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Just guessing, as I've never used BREAK, but...

    Try BREAK ON column1 [action1] ON column2 [action2] ... to get the subbreaks. Try using SKIP 0 for action1 to do a single break on multiple columns.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •