Focal Point
Indenting date from two sort fields as one and adding a compute in the middle of sort

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/940104635

September 28, 2010, 04:50 PM
Arif
Indenting date from two sort fields as one and adding a compute in the middle of sort
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?


WebFOCUS 7.6.10
Windows
HTML
September 28, 2010, 06:55 PM
Darin Lee
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.


Regards,

Darin



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
September 29, 2010, 12:49 AM
Arif
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:
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]


WebFOCUS 7.6.10
Windows
HTML