diannelight
Technical User
It does not seem possible to place a TopN on a crosstab table or graph - is this true?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TopN
- Thread starter diannelight
- Start date
- Status
Not intuitive, but possible... 
)
Select the CrossTab by clicking on the empty top-left cell.
Then, use the Report, TopN/Sort Group Expert
Poor user interface, but it works.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
)Select the CrossTab by clicking on the empty top-left cell.
Then, use the Report, TopN/Sort Group Expert
Poor user interface, but it works.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #3
diannelight
Technical User
Ido, thanks for your help.
I did try this but it's not working for my situation.
Would anyone be able to help with a formula that would calculate the top 10 agents in a crosstab graph?
I'm using Crystal 9 and field definition files.
My cross-tab shows lost calls for each media, against agent name (showing only the top 10).
Thanks for your help.
I did try this but it's not working for my situation.
Would anyone be able to help with a formula that would calculate the top 10 agents in a crosstab graph?
I'm using Crystal 9 and field definition files.
My cross-tab shows lost calls for each media, against agent name (showing only the top 10).
Thanks for your help.
What exactly was not working in the TopN for you?
Note: you can't use the "All" option in the dialog. You must select the TopN option and you must start by selecting the CrossTab (as mentioned above).
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Note: you can't use the "All" option in the dialog. You must select the TopN option and you must start by selecting the CrossTab (as mentioned above).
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Also, you can't TopN the columns, only the rows.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
Hello --
IdoMillet Oct 28, 2003 posted
"Select the CrossTab by clicking on the empty top-left cell.
Then, use the Report, TopN/Sort Group Expert "
I can't find Report, "TopN/Sort Group Expert" in Crystal Reports 10.
Can someone tell me where it is?
Thanks for any help.
Larry Mehl
IdoMillet Oct 28, 2003 posted
"Select the CrossTab by clicking on the empty top-left cell.
Then, use the Report, TopN/Sort Group Expert "
I can't find Report, "TopN/Sort Group Expert" in Crystal Reports 10.
Can someone tell me where it is?
Thanks for any help.
Larry Mehl
Starting in v9 it is called the "Group Sort Expert".
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- TEK2(AT)kenhamady.com
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- TEK2(AT)kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question