Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    India
    Posts
    40

    Unanswered: Urgent help break and Compute for Report display

    Hi all

    I have a big problem with break and compute....

    i have to select Date,store,number,sum(a) from mytab groupby Date,store,number

    I want the report to be display in this way...

    Date Store Number Sum(a)
    ----------- ----- -------- ------
    01-Jan-2000 10 90 1000
    70 1000
    60 5000
    -------
    7000
    -------
    01-Jan-2000 20 100 200
    343 300
    223 500
    -------
    1000
    -------
    8000
    ------

    so please let me know how can i compute sum and break on each .....columns..


    thanks
    Suryadevara

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    jdbf,

    Your example report doesn't make sense... are you breaking on date, the store, or number?

    JoeB

Posting Permissions

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