By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Grouping in a report

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In message <40********@news.vo.lu>, Georges Heinesch <ne**@geohei.lu>
writes
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):


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.

Nov 12 '05 #2

P: n/a
Bernard Peek wrote:
In message <40********@news.vo.lu>, Georges Heinesch <ne**@geohei.lu>
What I would like to have (grouped according the first column,
first record completely in one row):


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.


Worked!
Thanks a lot!

--
Georges
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.