Grouping in a report

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Georges Heinesch
    #1

    Grouping in a report

    Hi.

    I would like to apply some grouping in a report, but I don't know
    whether this here is possible. Best I describe it with an example:

    Here some records:

    Apples green 12 USD
    Apples green 12 USD
    Apples green 12 USD
    Bananas green 12 USD
    Bananas green 12 USD
    Oranges green 12 USD
    Oranges green 12 USD
    Oranges green 12 USD

    What I would like to have (grouped according the first column, first
    record completely in one row):

    Apples green 12 USD
    green 12 USD
    green 12 USD
    Bananas green 12 USD
    green 12 USD
    Oranges green 12 USD
    green 12 USD
    green 12 USD

    All I get is (first record splitted on 2 rows):

    Apples
    green 12 USD
    green 12 USD
    green 12 USD
    Bananas
    green 12 USD
    green 12 USD
    Oranges
    green 12 USD
    green 12 USD
    green 12 USD

    Is it possible that the fields of the first record in the detail section
    gets displayed at the same line?

    TIA

    --
    Georges
    Tags: None
    • Bernard Peek
      #2
      Re: Grouping in a report

      In message <4023b44b_2@new s.vo.lu>, Georges Heinesch <news@geohei.lu >
      writes[color=blue]
      >Hi.
      >
      >I would like to apply some grouping in a report, but I don't know
      >whether this here is possible. Best I describe it with an example:
      >
      >Here some records:
      >
      >Apples green 12 USD
      >Apples green 12 USD
      >Apples green 12 USD
      >Bananas green 12 USD
      >Bananas green 12 USD
      >Oranges green 12 USD
      >Oranges green 12 USD
      >Oranges green 12 USD
      >
      >What I would like to have (grouped according the first column,
      >first record completely in one row):[/color]

      Put all of the fields in the detail section. Sort by name, colour and
      price. Set the "Hide Duplicates" property on the name field to true.

      You will see:

      Apples green 12 USD
      green 12 USD
      green 12 USD
      Bananas green 12 USD
      green 12 USD
      Oranges green 12 USD
      green 12 USD
      green 12 USD



      --
      Bernard Peek
      London, UK. DBA, Manager, Trainer & Author. Will work for money.

        Comment

        • Georges Heinesch
          #3
          Re: Grouping in a report

          Bernard Peek wrote:
          [color=blue]
          > In message <4023b44b_2@new s.vo.lu>, Georges Heinesch <news@geohei.lu >
          >[color=green]
          >>What I would like to have (grouped according the first column,
          >>first record completely in one row):[/color]
          >
          > Put all of the fields in the detail section. Sort by name, colour and
          > price. Set the "Hide Duplicates" property on the name field to true.[/color]

          Worked!
          Thanks a lot!

          --
          Georges

            Comment

            Previous template Next
            Working...