As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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:
Now after I have this indenting done I would like to add a user defined compute for in the middle of column value:
The first part is easy. Just put the Country in a subhead:
ON COUNTRY SUBHEAD
and use the IN marker on the indented field:
CAR IN 5
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
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
Darin, 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:
'DWMETRICSSUMMARY.DWMETRICSSUMMARY.CCW/I11CB' AS 'Current ,Week'
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%'
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%'
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]