cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report Crosstab column without sorting (Original order)

Former Member
0 Kudos

HI,

I'm using a stored proc in my crystal report. All data are sorted in the procedure.

My report has cross tab with col1 and row1.

Is there any way to prohibit crystal report to sort my col1 data to desc and asc.

my proc is returning data1,data2 and data3.

in the procedure. I have sort by data4 desc

crosstab column = data1

crosstab row = data2

crosstab summarized = data3

data4 not used in the report.

But when I run the report the column (data1) is sorted in asc or desc.

Thanks,

K67078

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The way that Crystal builds a crosstab, it has to sort it by the rows and columns in the tab, otherwise it could end up with duplicate row or column headers with different values, which would be confusing at best. If you want it sorted by field4, you'll need to put that in the crosstab.

HTH,

Carl

Answers (0)