2. ASPRunnerPro General questions
  3. Sort a Report
This topic is locked

Sort a Report

 		8/31/2007 6:01:54 AM
ASPRunnerPro General questions
4
 4thninches author

Hi,
How can I Sort a 'Report' in date order?
It need a simple old fashioned screen type report and have created it successfully but it is listing in the order that the records appear in the database.
I can set the Sort Field and Order in both the Editor and in View but not in a Report.
I guess this 'should' be done in a View but I always get a sub-menu for each Record in a 'View'. I can't see how to make a Report style View.
Help please.
FAI
Sergey Kornilov admin 8/31/2007

Reports are sorted by the group field. If you sort it by some other field it won't work.
4
 		4thninches author 9/1/2007

Is there way to make a display page that looks like -
Record 1 - Field 1

Record 1 - Field 2

Record 1 - Field 3
--
Record 2 - Field 1

Record 2 - Field 2

Record 2 - Field 3
--
Record 3 - Field 1

Record 3 - Field 2

Record 3 - Field 3
--
etc
Sorted in an oder of Field 4 (that is a date)
Thanks
FAI
Sergey Kornilov admin 9/1/2007

Sorting data by any field other than group field doesn't make sense as you break the grouping.