This topic is locked

Crosstab reports

7/6/2014 2:30:40 PM
ASPRunnerPro General questions
R
rgke author

I have created a crosstab report using ASPRUNNER 8.1 which correctly sorts the y axis alphabetically, but I cannot figure out how to sort the x axis. I have checked the SQL SORT statement which is correct, but it does not seem to have any effect. I cannot see any logic to the order in which the rows are displayed.
What am I doing wrong?

lefty 8/30/2014

your using the wrong parmeters for the report . It seems you need two fields x and y and your not getting x. Need to play with report and ,,make sue x has data in it . Try lattitude and longitude or reverse them to the most important field sorted or grouped. Make sure the x and y are in the group settings of the report as that will change your sql sort.