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

Grouping Data on reports

P: 8
Hello! I have a small problem with grouping data on reports.
The situation is that I have an PersonIDnumber, PersonName, NoPurchases and ProductNumbersAllocated.

The person ID is just any number, which I want to be sorted in the report (did this fine), however if I have a personID that has more than one prodcutnumbersallocated, then it lists the PersonID several times.

PersonID and PersonName is from "TableA"
NoPurchases and ProductNumbersAvaialbleToPurchase(ProductNumbersAl located) is from "TableB".

So lets say PersonID is: 01.
PersonName is: Smith.
NoPurchases: 100 for productID 10(below), 100 for productID 20, 100 for productID 30.
ProdcutNumbersAllocated: 10, 20, 30.

When I create a report It will List The person ID and Name several times, listed each time for the ProductNumbersAllocated for example:

Person ID.........Person Name.......ProductNumbersAllocated......No Purchases

01....................Smith....................... ...........10...........................100,
01....................Smith....................... ...........20...........................100,
01....................Smith....................... ...........30...........................100,


However I want it to look like the following:

Person ID.........PersonName.............ProductNumbersAl located.............NoPurchases
01...............Smith,.......................10, 20, 30...................................300

Any help is ver much appreciated :)
Dec 20 '06 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,607
Hello! I have a small problem with grouping data on reports.
The situation is that I have an PersonIDnumber, PersonName, NoPurchases and ProductNumbersAllocated.

The person ID is just any number, which I want to be sorted in the report (did this fine), however if I have a personID that has more than one prodcutnumbersallocated, then it lists the PersonID several times.

PersonID and PersonName is from "TableA"
NoPurchases and ProductNumbersAvaialbleToPurchase(ProductNumbersAl located) is from "TableB".

So lets say PersonID is: 01.
PersonName is: Smith.
NoPurchases: 100 for productID 10(below), 100 for productID 20, 100 for productID 30.
ProdcutNumbersAllocated: 10, 20, 30.

When I create a report It will List The person ID and Name several times, listed each time for the ProductNumbersAllocated for example:

Person ID.........Person Name.......ProductNumbersAllocated......No Purchases

01....................Smith....................... ...........10...........................100,
01....................Smith....................... ...........20...........................100,
01....................Smith....................... ...........30...........................100,


However I want it to look like the following:

Person ID.........PersonName.............ProductNumbersAl located.............NoPurchases
01...............Smith,.......................10, 20, 30...................................300

Any help is ver much appreciated :)
1) Right Click the Person ID and Person Names Text Boxes in the Detail Sections of their respective Groups.

2) Select Properties, then Format

3) Set Hide Duplicates to Yes.
Dec 21 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.