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 1229
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: thefirstwml |
last post by:
I am using Visual Studio.NET 2002 Professional and am attempting to
create a report on Crystal Reports for .NET.
I know that Crystal Reports can group on anything, and when I add
multiple...
|
by: amber |
last post by:
Hello,
I have a report in VB.NET/Crystal Reports.
I have a criteria form that users select between 2 different types of
grouping (group by category or group by year).
Can I programmatically...
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have...
|
by: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At...
|
by: Megan |
last post by:
quick summary: i'm having problems trying to group fields in a report
in order to calculate percentages. to calculate percentages, i'm
comparing the results from my grouped fields to the totals....
|
by: Bob |
last post by:
I wish to group data on a report by week, month and year. Crystal reports
has this ability as a built in function. Is there a quick way to do this in
Access97/2000 VBA reports ?
Thank you in...
|
by: midlothian |
last post by:
I need to create a large book of work for my company, with many
different reports using different data. It all needs to come together
in one book, to be saved in PDF format. Some of the reports in...
|
by: Bart op de grote markt |
last post by:
Hello,
I have a very simple problem which I will illustrate with an example:
I have the following records in my table:
A 1 C
A 2 C
A 3 C
B 8 K
B 9 K
|
by: CoopEng |
last post by:
Hey Team,
Here's one for you all to ponder. In Access 2003, I'm updating a Operations Database for a manufacturing plant. The data is of production runs for the plant. So there are start date's...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |