Result in cross-tab not sorted

bilalsalas

<p>Hi,</p><p>I have prepared a new report using cross tab, but the the list of row are coming without order or with different order than the query return if I run the query in SQL management studio.</p><p>the sql query returns as in the following image:</p><p><a data-ipb='nomediaparse' href='http://www.photobox.co.uk/my/photo/full?photo_id=20301051270'>http://www.photobox.co.uk/my/photo/full?photo_id=20301051270</a></p><p> </p><p>but the report (cross-tab) appears like the following:</p><p><a data-ipb='nomediaparse' href='http://www.photobox.co.uk/my/photo/full?photo_id=20301101332'>http://www.photobox.co.uk/my/photo/full?photo_id=20301101332</a></p><p> </p><p>I need the order in the report to be as it returned in sql management studio.</p><p>Thanks in advance</p>