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  1240   ADezii 8,834
Recognized Expert Expert
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.
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
groups, the groups are childs of the first group.
i.e.
Group 1
Group 2
|
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 change the grouping of a single report, based on the
user's selection?
Or do I have to create another report, with different grouping, and call it
when user selects different grouping?
Thanks,
amber
|
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 reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
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 the moment the printed output is usually going to Word. It's turning into
an unholy mess, because I'm having to prepare umpteen different Word
templates, and the queries that drive them, depending on what events a
course has.
|
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.
first, let me say that this is a really long post. i wasn't sure how
much information/ background to provide, so i thought more was better
than less. i tried to delineate certain areas so that it would be
easy to peruse my posting and find...
| | |
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 advance, Bob.
|
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 the book
will use snaking columns, so I am wary of using subreports, as I know
they do not support snaking. The alternative I guess is to create
separate reports. Is there a way to group these separate reports into
one to be output to Snapshot?...
|
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 and start times for each run. For example on monday march 10 there could have been entries like 5:00 - 13:00 (..data from shift), 13:00 - 21:00 (data from shift).. etc.
The report that i'm working on displays all production runs between two dates....
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
