Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Unanswered: Database Report Summary Help

    Hi All,

    My first topic here and I hope I will be able to find a solution to my problem here.

    I have a data table and I've created report from that table. Data table contains data for Area, Store and sales, cost and profit data on different column.

    I have created a report that gives me data by Store and it works fine.

    But I want to create a report that gives me summary by area. When I try to do that detail section repeats so many lines instead of giving me total for each area.
    I mean if one of area contains 3 store than it's not showing me total of 3 stores instead it shows me 3 different line and 3 different figures instead of 1 in detail section.

    Can any one please let me know how can I have summary?

    Thanks.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I'll tell you something that used to bite me in the pants until I finally learned to do it. In report design, click on the Grouping icon. I betcha your groupings are all wrong, or at least out of the correct order. Either that, or your SQL is wrong.

    Sam

Posting Permissions

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