I would like to return records from a query to excel. Currently the report is in summary form.

This is what the report looks like now:


Region State Amount
North New York 3,226.55
Maine 588.84
Vermont 8,042.16
South Florida 827.54
Georgia 1,532.45
South Carolina 7,527.42
West New Mexico 3,822.07
Texas 7,579.25
California 8,800.68


This is what I want the report to look like:


Region State Amount
North New York 3,226.55
North Maine 588.84
North Vermont 8,042.16
South Florida 827.54
South Georgia 1,532.45
South South Carolina 7,527.42
West New Mexico 3,822.07
West Texas 7,579.25
West California 8,800.68


Thanks in advance,
Brad

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

Sorry the example did turn out as I had planned.

Basically I need to return data for each field in a record.

Thanks,
Brad

Is the region on every record?

SET BYDISPLAY=ON
TABLE FILE filename
PRINT AMOUNT
BY REGION 
BY STATE
ON TABLE SET ONLINE-FMT EXL2K
END  

Thank you so much Ginny. It works perfectly.

This is pretty basic stuff. Have you had any training or been pointed to the documentation? Do you have Developer Studio or are you writing this by hand? You might want to check out the doc link in the upper right-hand corner of this page and do a little perusing to get familiar with WebFOCUS functionality.

Best of luck!