Crystal Report Crosstab column without sorting (Original order)
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.
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.