Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Indenting date from two sort fields as one and adding a compute in the middle of sort
Go
New
Search
Notify
Tools
Reply
  
Indenting date from two sort fields as one and adding a compute in the middle of sort
 Login/Join
 
Guru
posted
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
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Indenting date from two sort fields as one and adding a compute in the middle of sort

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.