Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report Crosstab column without sorting (Original order)

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question