I am in the process of writing a report. I want to show two columns sort data as one colum and indent top sort to 2nd sort.
In first sort for example:
DESCRIPTION ENDLAND CARNAME1 CARNAME2 JAPAN CARNAME1 CARNAME2 Now after I have this indenting done I would like to add a user defined compute for in the middle of column value: ENGLAND Jaguar 8000 JENSEN 1000 JAPAN TRIUMPH 9000 TRIUMPH-JAG 1000 DATSUN 11000 England-Japan (11000) ITALY ALFA 20000 ROMEO 29000 ENGLAND-Itly (40000)
Is it possible?
The first part is easy. Just put the Country in a subhead:
ON COUNTRY SUBHEAD "<COUNTRY"
and use the IN marker on the indented field:
CAR IN 5 or CAR IN +5
As for the rest of the question, you can put a SUBFOOT or RECOMPUTE at the bottom of every COUNTRY section, but you will have to probably use a double verb to compute the ENGLAND total for the entire report so it can be used at various places in the report.
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
Thank you so much for great suggestions. I think my report is little more complicate than I explained(My fault).
Here is the code for my report:
PRINT 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CCW/I11CB' AS 'Current ,Week' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PriorYearChange/I7CB' AS 'CW vs PY,Change' 'J1.DWMETRICSDESCRIPTION.PYCPct' AS 'CW vs PY,Change%' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPW/I11CB' AS 'Prior ,Week' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PWPYChange/I7CB' AS 'PW vs PY,Change' 'J1.DWMETRICSDESCRIPTION.PWPYPct' AS 'PW vs PY,Change%' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPT/I11CB' AS 'Current Period,To Date' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PTDChange/I7CB' AS 'PTD vs PY,Change' 'J1.DWMETRICSDESCRIPTION.PTDPct' AS 'PTD vs PY,Change%' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CPP/I11CB' AS 'Prior ,Period' 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.PPTDChange/I7CB' AS 'PP vs PY,Change' 'J1.DWMETRICSDESCRIPTION.PPPYPct' AS 'PP vs PY,Change%' 'J1.DWMETRICSDESCRIPTION.DBTBLFLAG' NOPRINT BY &BURST.(<DivisionID,DivisionID>,<DistrictID,DistrictID>,<SchoolID,SchoolID>).Select Burst(sort) order. NOPRINT BY 'J0.DIM_SCHOOL.DIVISIONID' NOPRINT BY 'J0.DIM_SCHOOL.DISTRICTID' NOPRINT BY 'J0.DIM_SCHOOL.SCHOOLID' AS 'School' BY 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.ORDERID' NOPRINT BY 'DWMETRICSSUMMARY.DWMETRICSSUMMARY.KEY1' NOPRINT BY 'J1.DWMETRICSDESCRIPTION.KEY1_DESCRIPTION' NOPRINT AS '' BY 'J1.DWMETRICSDESCRIPTION.KEY2_DESCRIPTION' AS ''
So I need SUBHEADIN
ON KEY2_DESCRIPTION SUBHEAD
The problem is it repeats the subheading again and again for each line because I have couple of hidden sort fields. Is there a way to accomplish this?
[IMG:left]C:\Documents and Settings\Szaidi.CTTLC\Desktop\untitled.bmp[/IMG]
|Powered by Social Strata|