Reports - setting up data order

[Guest]

I need to create reports where I can specify the order in which the data
appears. The data set is only about 12 lines long, but it will also include
several 'non logical' sbutotals.

For example, if the data set were colors Red, Blue, Purple, Green, Yellow,
Orange. I want to specify the order of the colors, but this order is not
decending or ascending, it is mixed. The colors will have fields across
values associated with them: such as: Orange this month 50, last year 20,
variance 30 (ie a line across the report not just the color name)

Also, I want a subtotal for Purple (logical to my need but not the dataset)
and then a final total.

 

[Guest]

Create a SortOrder table for your colors. A number field for sorting and the
color in a second field. Add the SortOrder table in your query that is used
as the record source for the report. In the report select the SortOrder
field in the Sorting and Grouping section (it does not have to be displayed).