When creating reports to Excel using InfoAssist, putting tot...

[Martin Yergeau]

The key is HEADALIGN=BODY

But cant tell where to do this in IA

TABLE FILE CAR

SUM SEATS

BY MODEL

 

FOOTING

"SEATS: <TOT.SEATS"

 

ON TABLE PCHOLD FORMAT XLSX

ON TABLE SET STYLE *

 

TYPE=FOOTING,

HEADALIGN=BODY,

JUSTIFY=RIGHT,

$

ENDSTYLE

END

[Debra Waybright]

MartinY:

 

TYPE=FOOTING, HEADALIGN=BODY, JUSTIFY=RIGHT, $

 

 

I will see if maybe I can get it added to the theme file and see if that will work. Thanks.

[Debra Waybright]

I added that to the style sheet and it works like a charm!

Thanks for the help!

Deb

[Debra Waybright]

When creating reports to Excel using InfoAssist, putting totals in a footer, the totals end up in the same cell with the total description, for example:

 

Tried putting <+0> in the footer between the text and the field, but either got an error or it just didnt print the total amount. Heres what the footer looks like:

 

What is the trick to get it to be like this:

 

Thanks,

Deb