[SOLVED] Return records to report instead of summary
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:
RegionStateAmount 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:
RegionStateAmount 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, BradThis message has been edited. Last edited by: Kerry,
June 29, 2009, 04:05 PM
<bhouse>
Sorry the example did turn out as I had planned.
Basically I need to return data for each field in a record.
Thanks, Brad
June 29, 2009, 04:28 PM
GinnyJakes
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
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.