summarizing info without grouping
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 2 of 2

Thread: summarizing info without grouping

  1. #1
    Join Date
    Mar 2009

    summarizing info without grouping

    How the database is organized.

    There is a table with a bunch of orders and another that has the various companies' information. I make a report which shows all the orders made by which customers (1 line for each order) and group them according to city of company. So the only problem is that I don't want to see a line for each order but rather a line for each company with their total in purchases.

    This total information is not found in the database. So anyone know how I can get that data to fit on one line without having to use sql?

    I figured this out I am kind of silly about not being able to see that. Use a nested grouping and include summary information for that second grouping. I grouped the second according to the company.
    Last edited by fa1512; March 26th, 2009 at 05:44 PM.

  2. #2
    Join Date
    Jan 2010

    Re: summarizing info without grouping

    If you look at the "SQL" for your query, add "distinct" to the select statement.

Tags for this 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

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)