September 28, 2010, 04:50 PM
ArifIndenting 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?
September 28, 2010, 06:55 PM
Darin LeeThe 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.
September 29, 2010, 12:49 AM
ArifDarin,
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]