[Solved] Sizing Inline footer to align with query items from another query

[bdybldr]

Hi everyone,

I'm developing a sales report for all Countries in Western Europe.Ã,  However, I need to break out the total for Nordic Region seperately.Ã,  I decided to build 3 separate queries (one for Nordic Region, one for Other Western European countries, and one for all Western European countries.

I have 3 separate tables with one row and column each.Ã,  I've placed the Nordic region sales query items in the top row.Ã,  The Other WE countries in the middle row and hid the column titles.Ã,  I've sized everything to line up.Ã,  The problem is when I get to the query for all WE countries all I want to display is the inline footer and inline aggregates but when I hide the column titles and set the list columns box type to "none", I lose all sizing on the cells in the footer.

This is what I'm looking for

DenmarkÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  query 1 (Nordic Region)
FinlandÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, "
NorwayÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  "
Total Nordic RegionÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  "
AustriaÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, query 2 (Other WE Counties)
BelgiumÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  "
ItalyÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, "
Total Western EuropeÃ,  Ã,  Ã,  Ã,  Ã, query 3 (Total of all WE Countries)

Thanks for your help with this.

[BIsrik]

i could do the same thing..but i took one table with 3 rows and 2 columns. i then applied the size and overflow property of the table cell...

It worked...

Note: IF u r executing in HTML mode of execution and if any of the query, query1 or query2 data, spans more than one page it will affect the formatting. This is due to the execution method of HTML in cognos itself. In PDF no probs at all.

Srik

[bdybldr]

Thanks for the reply, BISrik.  I was really hoping to find a work around without having to set the size and overflow properties for each cell and list column.  Unfortunately, I couldn't find a way around it.

I set the box type of the list columns to none and changed the attributes of the column titles.  I set the background color and foreground color to white and resized the text to 1pt and removed upper and lower padding.  This reduced the size of the gap between the aggragate line and the list columns and I was able to maintain the size and overflow settings on the inline footer.  If anyone knows of a way to accomplish this without setting the sizes of each component, I would love to hear from you.

Thanks again.