Results 1 to 3 of 3

Thread: Grouping on Dates

  1. Feb 19th, 2003, 07:22 PM #1
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747

    Grouping on Dates

    I have a what u could call sales database, and with each sale a date is recorded

    so when i make a graph Sales VS Date. it only displays data for the days that have sales, but i want each day there, even if there are no sales. so u can see the ups and very downs (where there are No sales)

    what do u think?

    oh i am using CR9
    Reply With Quote Reply With Quote
  2. Feb 20th, 2003, 11:23 AM #2
    ducky
    ducky is offline
    Addicted Member
    Join Date
    Jan 2001
    Location
    MPLS
    Posts
    187
    One way is to create an all_dates table in your db which has a single field day (date) and popuate it with every date in your potential range of sales dates. Then do a outer join in your crystal query to this table and you'll have included grouped dates that have no sales.
    Reply With Quote Reply With Quote
  3. Feb 20th, 2003, 05:09 PM #3
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747
    ok done, it works. thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width