Does anyone know how to format a report with styling and get rid of the two empty Lines at the top of the report where the header usually is?

Also for TOTALS, is there any way of get not showing the Column name for the total?

Have you tried set page = nolead

ON FIELDNAME SUBTOTAL AS ''

Thanks Leah, the Page header problem is now finished.

But as per the TOTALS, If I wanted to Put text after the value of the column name is that possible?

i.e TOTAL for by Column_Name

Francis supplied an answer that works.

I needed to make it something like:

TOTAL for Column_Value1 by Column_Name2

You may have to use subfoots do do what I think you want. hope the code comes through okay

TABLE FILE CAR
SUM CNT.MODEL
BY CAR
BY COUNTRY
ON CAR SUBFOOT
" "
"TOTAL FOR " "
END

TABLE FILE CAR
SUM CNT.MODEL
BY CAR
BY COUNTRY
ON CAR SUBFOOT
" "
"TOTAL FOR "<"COUNTRY FOR "<"CAR "<"C1"
" "
END

In the second post, sorry for so much junk here, the "<" remove the double quote mark. Should we 'complain to IB about problems posting real code?

Hi Leah,

Not completely sure if this will resolve the issue, but can you please try to wrap your code with {code} and {/code} (replace {} with []) at the beginning and end, respectively?

Here is an example:

TABLE FILE CAR
...
code goes here
...
TOTAL "here1" FOR "here2"
...
END

Hope it helps.

Cheers,

Kerry

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

Following Kerry's suggestion:

TABLE FILE CAR
SUM CNT.MODEL
BY CAR
BY COUNTRY
ON CAR SUBFOOT
" "
"TOTAL FOR [COUNTRY FOR [CAR [C1"
" "
END

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

Hi Leah,

I think there is bit of a misunderstanding here that seems to be quite widespread.

When you want to add code to a posting, type [ code ]your code....[ /code ]. The [ code ] tags (without the spaces) are this bulletin boards (and most others that use UBB style coding) method of permitting unmodified text to display asis.

This will allow you to show exactly what code you want to (within reason e.g. the censorship mointor ) and is the method that J.G. (both of them ), Francis, Susannah etc. use.

Hope this helps

T

Thanks, Tony. A

Thanks for all the help on this issue, but it didn't quite seem to work.

I needed the Row to have the totals as well.

So it would look like:

TOTAL for Column_Value1 by Column_Name2 Total1 Total2

When posting embedded code, I've also taken to checking the "Disable HTML" option

Are you using across to need row totals. Might help if we knew what you trying to report.

I am not really using anything across.

But just columns, and totals. The totals are based on columns.

Check this out,

TABLE FILE CAR
PRINT MODEL
DEALER_COST
RETAIL_COST
BY CAR
BY COUNTRY
-*ON COUNTRY SUBTOTAL AS ''
ON COUNTRY SUBFOOT
"TOTAL FOR END


Hope it helps,

TABLE FILE CAR
PRINT MODEL
DEALER_COST
RETAIL_COST
BY CAR
BY COUNTRY
-*ON COUNTRY SUBTOTAL AS ''
ON COUNTRY SUBFOOT
"TOTAL FOR < CAR BY < COUNTRY < ST.DEALER_COST < ST.RETAIL_COST"
END

Thanks. It should be ok now.