Cross-tab Sorting 1

[bmoremu]

I'm having a difficult time doing what I would hope would be an easy task. I'm using CR in .NET...here is my example table:

       Week1   Wk2   Wk3   Wk4   WkN   Total
User1    3            8     7     2      20

User2    5      6     1     2     1      15

User3    1      4     9           5      19

UserN           8     7     3            18

Total    9     18     25    12    8      72

The cross-tab automatically sorts by User, but I want to sort by the "Total" column. There is no grouping, which might be part of the problem I'm having. Thanks in advance for the help!

 

[IdoMillet]

Select the CrossTab by clicking inside the top left corner.

Go to Report menu and select Top N/Sort Group Expert.

Select how you want to sort.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bmoremu]

I can only access the Report menu by right-clicking in blank space of the report, and when I do that 'Top N/Sort Group Expert is grayed out / unavailable.

 

[IdoMillet]

You must start by selecting the whole CrossTab by clicking (not right-clicking) in the top left corner of the CrossTab.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bmoremu]

Correct, I see 'Top N/Sort Group Expert' but it is grayed out / unavailable.

 

[IdoMillet]

Do you have Rows in your CrossTab?

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Can you confirm that this is an inserted crosstab, and NOT just a series of fields laid out in the detail section with a formula for the total? If the latter were the case, you could go to report->sort records and choose {@total}.

If it is an inserted crosstab, you must click on the x for the topN to be available:

| | |
x | col 1 | col2 | total
_____| label | label |
row
label1 12 45 57
______
row
label2
______
total

Not sure if this was already obvious...

-LB

 

[bmoremu]

Ido,
My crosstab example is shown in my original post, that's all there is to it.

LB,
It is a crosstab. After clicking on the "x", I right-click in the Field Explorer, go to 'Report', and 'Top N/Group Sort Expert' is grayed out.

 

[lbass]

You should left click on the "x" so that the crosstab is selected (a crosshatch border appears around the entire crosstab) and then go to the menu at the top of the report screen->report tab->topN. The field explorer doesn't have anything to do with it. Having a group on your row field is irrelevant. The crosstab by its nature treats the row field as a group field, so topN should be available to you.

-LB

 

[bmoremu]

The reason I mentioned Field Explorer is b/c it's the only place I find a 'Report' menu, when I right-click there. Otherwise, after left-clicking on the 'x', I do not see a Report menu anywhere up top.

 

[IdoMillet]

It's the "Report" menu of Crystal. It's always there.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com