Is there a way to have the noprint fields NOT show up in the drop down list for ROLLUP when manipulating an Active Report? I use the noprint fields to correctly sort the report, but my users are confused with these fields and I would prefer not having these even viewed by my users when working with Active Reports.

This message has been edited. Last edited by: Kerry,

I couldn't figure out any direct way to achieve your requirement.

STEP1

Create a hold1 table like

 
TABLE FILE CAR
PRINT
CAR
MODEL
BY COUNTRY NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS H1
END
-RUN
 

Read the data from the hold table.

STEP2 - this will read the data in the same order as stoerd in the hold file

 
TABLE FILE H1
PRINT
CAR
MODEL
ON TABLE PCHOLD FORMAT AHTML
END

This will display the data sorted by country.