Unfortunately, you can't group by one thing and sort by another. You'd have
to have the calculations done someplace else.
Worst case, you might be able to have a subreport do all of the "math" and
then use shared variables/arrays if you know you're only looking at the top
10 or 20 and then have the top 10 or 20 set up in the main report.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Monday, March 22, 2010 6:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal report grouping
If I have a group footer summary at vendor of total dollar of DMRs and total
dollar of POs. and have a formula on that footer for percentage of dmrs/pos
how do I get the top percentafe in descending order.
Its not available as a choice in the Top Group Sort
Sent from my Verizon Wireless BlackBerry
[Non-text portions of this message have been removed]
to have the calculations done someplace else.
Worst case, you might be able to have a subreport do all of the "math" and
then use shared variables/arrays if you know you're only looking at the top
10 or 20 and then have the top 10 or 20 set up in the main report.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Monday, March 22, 2010 6:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal report grouping
If I have a group footer summary at vendor of total dollar of DMRs and total
dollar of POs. and have a formula on that footer for percentage of dmrs/pos
how do I get the top percentafe in descending order.
Its not available as a choice in the Top Group Sort
Sent from my Verizon Wireless BlackBerry
[Non-text portions of this message have been removed]