Hi:
By default, PROC REPORT, (which is the procedure "underneath" the List Report Wizard, will display items using the default ordering. Using code, there is a way to specify ORDER=DATA if your data have been pre-sorted to be the order you want.
However, in the List Report Wizard, I do not believe there is a way to alter the PROC REPORT code. If you edit the code created by the EG List Report Wizard, then you would have to change the DEFINE statement for your variable of interest. For example, if I had created a report using SASHELP.CLASS and I had already pre-sorted the data so that SEX and NAME were ordered in descending order, then I could tell PROC REPORT to preserve that order by changing the DEFINE statements to include ORDER=DATA:
[pre]
proc report .....;
column Sex Name Height Age ;
define Sex / group 'Sex' missing
order=data;
define Name / order
order=data;
.... more code ....
run;
[/pre]
cynthia
PS...ODS RTF destination output does not have the concept of "fit to page". Generally, ODS does not have a good way to interact with Microsoft Office menus and menu buttons. However, if you changed your output type to PDF output, then there are some system options that will allow you to instruct Acrobat Reader to fit the output to the page width. For example, if you look at the documentation, then you will see that this option causes the Adobe Acrobat Reader to open in "fit to page" mode.
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#/documentation/cdl/...
You would use the option like this:
[pre]
options pdfpageview=fitpage orientation=landscape;
ods pdf file='c:\temp\fitpage.pdf';
proc report data=sashelp.class nowd;
column sex name age height;
title 'List of Students and the Overall Average Age and Height';
define sex / group;
define name / order;
define age / mean;
define height / mean;
rbreak after/ summarize;
run;
ods pdf close;
options pdfpageview = default;
[/pre]