Quickreports Group Header

From: Jeff (jlabute_at_shaw.ca)
Date: 05/26/04

  • Next message: Tom: "Adding plugins to my application" 
    Date: Wed, 26 May 2004 19:12:42 GMT

    Hi Everyone...

    I am trying to create a report with much trouble.
    First, I am using D6 Pro and quick reports v 3.5.1 (free version)

    I generate a dataset with SQL
    select city,phone,count(phone) as NumHouse from customer
    where .......
    Group By City,Phone
    Order by City,NumHouse,Phone

    which generates a list of how many records have the same phone number with
    in a city
    sorted by city and increasing value of same phone number.

    when I do a quickreport... I have GroupHeader and the expression is
    "City;NumHouse"
    which doesn't seem to break properly... it lists the first city in the
    database and then 64 pages of just
    NumHouse in a detail line.

    If I just have "City" as the expression... then it lists all the cities but
    with NumHouse being 1,2,3 and so on
    under the same group... I want to break on City and NumHouse whioch I can't
    seem to do. Also, I tried
    using two group headers... one for city, one for NumHouse with no luck.

    Jeff

  • Next message: Tom: "Adding plugins to my application"

    Relevant Pages

    • Re: Reports with a grouped field.
      ... It will show me ALL the cities, ... cities that match with the cities on the report. ... When i tried linking by city it gave me the ... Create a query that lists all the cities. ...
      (microsoft.public.access.reports)
    • Generating Report from Form with Options
      ... I had posted this question a few days ago in the Report section and have not ... report to be able to pick up the lists of docs generated by the option ... Case 2 'City ... 'county, ...
      (microsoft.public.access.forms)
    • 21/9/05:LARGE SCALE IRAQI CIVILIAN KILLING-WHOS BEHIND(GLW/FWD)
      ... RAQ: Tal Afar: Another brutal victory for 'democracy' ... the US military's assault on the city of Tal ... according to a report filed two days earlier by the United ... IRIN reported that, according to the Iraqi Red Crescent Society, the ...
      (soc.culture.asean)
    • 21/9/05:LARGE SCALE IRAQI CIVILIAN KILLING-WHOS BEHIND(GLW/FWD)
      ... RAQ: Tal Afar: Another brutal victory for 'democracy' ... the US military's assault on the city of Tal ... according to a report filed two days earlier by the United ... IRIN reported that, according to the Iraqi Red Crescent Society, the ...
      (soc.culture.australian)
    • 21/9/05:LARGE SCALE IRAQI CIVILIAN KILLING-WHOS BEHIND(GLW/FWD)
      ... RAQ: Tal Afar: Another brutal victory for 'democracy' ... the US military's assault on the city of Tal ... according to a report filed two days earlier by the United ... IRIN reported that, according to the Iraqi Red Crescent Society, the ...
      (soc.culture.burma)