Top N Sorting with VB RDC

[jrhine]

At runtime, I'm already successful at changing the grouping for a Crystal Report I'm displaying through my VB App.

However, I can't seem to get the "Group" to sort according to it's summary field.

Anyone have some suggestions?

---

Basically, I have a report that's grouped by Region, BranchOffice and then by Sales Rep. This report contains information about how many applications these Sales Reps turn in to us, how many of those applications are rejected, and how many are deficient.

I'd like to be able to (on the fly) sort DESCENDING this report based on the run-time summation of Count(DeficientApps) for example. That way my client can get a list of those TOP 10, 20 whatever slacker Sales Reps who keep turning in deficient applications.

Any thoughts on how to do this through VB code at run time?

Thanks in advance!
Jeff Rhine

 

[kenhamady]

Which version/integration method are you using?
Are you trying to:

Turn the TopN on and off?
Set the TopN number?
Decide which subtotal field to use in the TopN? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[jrhine]

Yes! To all of the above

I'm using Visual Basic 6.0 (SP5) and Crystal Enterprise 8.5 (the Report Designer
Component within my VB App.) The user is permitted to select the customized
sorting/grouping options by ComboBoxes on the CRViewer1 form.

--------------------

My client wishes to have an "uber" report that she can turn the sorting off, back
on and even choose the field on which to perform the sorting.

Sure I can create a few different reports to accomplish the same goal, but I
thought Crystal might be able to handle such a setup.

Oh, and thanks for your reply. I've been searching the internet for some
time and haven't found what I needed.

Jeff Rhine