Grouping Data on reports

**ADezii** · Dec 21 '06, 12:41 AM

Originally posted by gozzer101

Hello! I have a small problem with grouping data on reports.
The situation is that I have an PersonIDnumber, PersonName, NoPurchases and ProductNumbersA llocated.

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 prodcutnumbersa llocated, then it lists the PersonID several times.

PersonID and PersonName is from "TableA"
NoPurchases and ProductNumbersA vaialbleToPurch ase(ProductNumb ersAllocated) 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.
ProdcutNumbersA llocated: 10, 20, 30.

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

Person ID.........Pers on Name.......Prod uctNumbersAlloc ated......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.........Pers onName......... ....ProductNumb ersAllocated... ..........NoPur chases
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.

Grouping Data on reports

Grouping Data on reports

Comment