Hi all,

How do I identify the last two rows of data in my style sheet? I need to make the last two rows bold. Is this possible?

Thanks in advance,
B

This message has been edited. Last edited by: bflemi3,

Hope this will help u,

TABLE FILE CAR
PRINT CAR
COUNTRY
ON TABLE HOLD
END

-SET &LAST_ROW = &LINES;
-SET &PENUL_ROW = &LAST_ROW - 1;

TABLE FILE CAR
PRINT CAR
COUNTRY
COMPUTE RANK/I2 = RANK + 1; NOPRINT
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE = DATA, STYLE=BOLD, WHEN = RANK EQ &PENUL_ROW,$
TYPE = DATA, STYLE=BOLD, WHEN = RANK EQ &LAST_ROW,$
END

-Hari

What is so particular about those 2 rows of data when compared to the rest of the data in your report? Are they sub-totals or totals? or .. is there "something" in there that would allow to clearly differentiate them from other rows in the same data set?

They are the totals for the particular region the user selected and the total for the company. I had to create 3 hold files and then used MORE to join all three hold files together. Now I need to format the report so the last lines are bold.

quote:

Originally posted by atturhari:
Hope this will help u,

TABLE FILE CAR
PRINT CAR
COUNTRY
ON TABLE HOLD
END

-SET &LAST_ROW = &LINES;
-SET &PENUL_ROW = &LAST_ROW - 1;

TABLE FILE CAR
PRINT CAR
COUNTRY
COMPUTE RANK/I2 = RANK + 1; NOPRINT
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE = DATA, STYLE=BOLD, WHEN = RANK EQ &PENUL_ROW,$
TYPE = DATA, STYLE=BOLD, WHEN = RANK EQ &LAST_ROW,$
END

-Hari

Thanks Hari,

I'm not seeing the formatting change. What is RANK supposed to represent? The row number?

What's in each HOLD file? Do you have something like this?

HOLD1: Detailed records
HOLD2: Total for the Region
HOLD3: Total for the Company

If so, you can define a special field to keep some sort of record type indicator which can later be used in your style sheet.

Something like:

FILEDEF HOLDFINAL DISK holdfinal.ftm (APPEND
-RUN
SET HOLDLIST=PRINTONLY
SET ASNAMES=ON
-*
-* 1. Send detail records to resulting HOLD file
DEFINE FILE HOLD1
REC_TYPE/A10 = '1DETAIL';
END
TABLE FILE HOLD1
SUM FIELD1
    FIELD2
    FIELD3
    ...
BY REC_TYPE   <-- Record type indicator
BY ...
ON TABLE HOLD AS HOLDFINAL
END
-*
-* 2. Add region total to resulting HOLD file
DEFINE FILE HOLD2
REC_TYPE/A10 = '2TLREGION';
END
TABLE FILE HOLD2
SUM FIELD1
    FIELD2
    FIELD3
    ...
BY REC_TYPE
BY ...
ON TABLE HOLD AS HOLDFINAL
END
-*
-* 3. Add company total to resulting HOLD file
DEFINE FILE HOLD3
REC_TYPE/A10 = '2TLCOMPANY';
END
TABLE FILE HOLD3
SUM FIELD1
    FIELD2
    FIELD3
    ...
BY REC_TYPE
BY BYFIELD1
BY BYFIELD2
BY ...
ON TABLE HOLD AS HOLDFINAL
END
-RUN

Now you have a file (HOLDFINAL) with all of the information you need. You can then create a report and style it according to REC_TYPE:

TABLE FILE HOLDFINAL
PRINT FIELD1
      FIELD2
      FIELD3
      ...
BY REC_TYPE NOPRINT
BY BYFIELD1
BY BYFIELD2
BY ...
ON TABLE SET STYLE *
...
TYPE=DATA, STYLE=+BOLD, WHEN=REC_TYPE NE '1DETAIL', $
....
ENDSTYLE
END

You don't specify how HOLD1, HOLD2 and HOLD3 were created in the first place but if you can control it, it would be preferable to create the REC_TYPE field *while* creating those HOLD files. If you do that, you can then use MORE (instead of the technique I showed above) making sure that REC_TYPE is included in the resulting HOLD file.

The style definition would remain the same.

Hope that helps!

bflemi3, Attuhari's example works for me - the last two lines are in bold . Just remove the NOPRINT from the RANK computation and you'll see that it is indeed a row number.

If those lines are just total lines, you should use
BY fieldname
ON fieldname SUB-TOTAL

SUBTOTAL is one of the componenets that can be styled:
TYPE=SUBTOTAL, BY=fieldname, STYLE=BOLD,$