anybody know how to get a subtotal line without the blank line before and after?
There's probably a setting.
I just don't know it.

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

The sort, sneaky answer is to turn GRID ON!

Now we'll have to ask IBI why turning GRID OFF/ON affects how many lines are used for SUBTOTAL.

ah bless you, but grid is too icky a solution. any other ideas?

Check out this example. The css styling TD {font-size: 1px;} sets all the TD's that do not have anything else in them to 1px font size, thus reducing the lines before and after the subtotal.



TABLE FILE CAR
SUM SALES
BY COUNTRY SUBTOTAL BY CAR
HEADING
" "

ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS H001 FORMAT HTML
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF,
FONT='VERDANA', SIZE=8, $
TYPE=SUBTOTAL, BACKCOLOR=RED, $
ENDSTYLE
END
-HTMLFORM BEGIN

!IBI.FIL.H001;
-HTMLFORM END

This message has been edited. Last edited by: <Mabel>,

sweet!
but i'm actually trying to kill it, because my users use RCXX and the excel version will have all those icky blank lines that make sorting the db really annoying.

Interestingly, I don't get blank lines in Excel 2000.

TABLE FILE CAR
SUM SALES
BY COUNTRY SUBTOTAL
BY CAR

ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT EXL2000
END

If its a PDF did you try BOTTOMGAP in your STYLESHEET?

TYPE=SUBFOOT, BOTTOMGAP=.??, $

yep, but i'm not doing PCHOLD FORMAT EXL2K
i'm doing RCXX and letting BillGates handle the conversion, the fex reruns and opens in real actual excel, not xml which my users hate.
So if i've got blank TDs, BillGates is gonna give them to me. I gotta kill 'em at the source.
Lenny, thanks for the input, but if i had to do pdfs , i'ld a quit this job ages ago!

I seem to recall in more recent versions of WebFOCUS additional and finer commands were added to control and customize the borders/gridlines on a report. Since GRID=ON eliminates the blank lines, try turning the GRID ON and then use the new border/gridline control commands to "hide" the grid lines by changing their color/width or turning them off idividually, if possible. I have not tried this myself but it might get you what you are looking for.

Mickey's suggestion seems to be the best.

Susannah, I have no idea what RCXX is but try the following. This gives me a report in HTML with no skipped lines.

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY SUBTOTAL
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=LIGHT, BORDER-STYLE=NONE, $
ENDSTYLE
END

Turn your grid OFF
and you'll get extra lines.
rcxx=right click export to excel, a very billgates thing to do.

Susannah,

I ran this and then RCXX'd and no extra lines.

I guess it's the HTMLCSS ON and the border commands.

I know we don't like using HTMLCSS ON but in this case...

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY SUBTOTAL
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

TYPE=REPORT, GRID=OFF, BORDER=LIGHT, BORDER-STYLE=NONE, $
ENDSTYLE
END

WORKS! guess i gotta bite the bullet
Thanks Pietro.

The big question is, why does it work this way?

Why does WebFOCUS do things other than controlling the GRID when you set GRID to OFF or ON?

It should be adding or removing empty lines around report elements, just show or hide the grid.

oh you're preaching to the choir, here. i've been after the PM at Summit for 3 years now, and no response. Not even a glimmer of understanding what i'm talking about with GRID baggage.

And here we are in 2011 and still No Answer? GRID does weird stuff (which should not be associated with GRID ~ imho).

See you at Summit!!!

Doug, I guess the unanswered question is on GRID, but in case someone scanning this topic doesn't know, this IS solved in 7.6.11 for removal of blank lines on subtotals.

SET DROPBLNKLINE=ON will remove the blank lines around subtotals and more.

For more info, see topic: Controlling Generation of Blank Lines on Report Output

David

11,790 reads later. Thanks for the update on the DROPBLNKLINE setting.

Yeah, a thorn in many a persons side over the years they've been looking to remove.

Can this topic be marked [SOLVED] by the moderator?

that so-called 'marking' of topics just makes the subject much harder to read, makes the lists much harder to scan...
it was a very bad idea, conceptually.. should have been implemented AT THE END of a topic, not the beginning....
and its only 'SOLVED BY UPGRADE', so i'll mark it 'SBU' at the end... howzat?

That works for me. Thanks!

I was going to make an additional suggestion regarding marking topics as SOLVED, but that's going off topic for this topic. I'll make it to Kerry or the FocalPoint world at large when I've thought it through.