Wow. Extremely easy and straight forward.
Thanks so much.
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, August 30, 2016 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Crystal Reports: Group by vendor but sort groups by total spend
Report --> Group Sort Expert...
For this group sort: Top N
based on Sum of @NetSales
Where N is: 25
---In vantage@yahoogroups.com, <jorojas@...> wrote :
Hi All,
E9.05.702A Progress
I’m working on a BAQ Report for “Top 25 Supplier Spendâ€.
The request is to also break out the supplier spend by job number so I am pulling the AP details in my BAQ. Meaning, no summaries in the BAQ.
In Crystal, I have two groups: Vendor ID and Job Number
So far so good, but now what I want is the ability to sort the Vendor ID groups by total spend in descending order.
From my google searches, this does not seem possible but I thought I’d ask the group.
Is there a way to achieve this? If yes, could you explain what it would take?
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
Advancing Your Innovations For Health
261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>
THINK QUALITY. BE QUALITY. GO BEYOND.
This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.
[Non-text portions of this message have been removed]
Thanks so much.
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, August 30, 2016 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Crystal Reports: Group by vendor but sort groups by total spend
Report --> Group Sort Expert...
For this group sort: Top N
based on Sum of @NetSales
Where N is: 25
---In vantage@yahoogroups.com, <jorojas@...> wrote :
Hi All,
E9.05.702A Progress
I’m working on a BAQ Report for “Top 25 Supplier Spendâ€.
The request is to also break out the supplier spend by job number so I am pulling the AP details in my BAQ. Meaning, no summaries in the BAQ.
In Crystal, I have two groups: Vendor ID and Job Number
So far so good, but now what I want is the ability to sort the Vendor ID groups by total spend in descending order.
From my google searches, this does not seem possible but I thought I’d ask the group.
Is there a way to achieve this? If yes, could you explain what it would take?
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
Advancing Your Innovations For Health
261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@...<mailto:JoRojas@...> | WEB: ventionmedical.com <http://www.ventionmedical.com/>
THINK QUALITY. BE QUALITY. GO BEYOND.
This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.
[Non-text portions of this message have been removed]