[SOLVED] Multiple Footer-Rows in 1 List item

[biejorrun]

Sorry for my bad English...I'm dutch ;-)

Situation: Cognos 8.2

I'm looking for a way to add a second footer row in a list item.
I already added a footer row with sums, but now I have to add another row, but from a different query. I know that it's not possible to assign 2 queries to one list item.

Any ideas or other solutions for this issue? Thanks in advance!

Björn

[COGNOiSe administrator]

My English is even worse ... I'm Polish  ;D

You could "fake it" by forsing exact widths of columns for each query.

[biejorrun]

Thanks! I will try that!

Björn

[MDXpressor]

Fake it till you make it!   ::)

OR

Select the footer row in the list.  From the Structure menu select 'Insert List Row Cells Below' (or Above depending on your preference).

In the tabular model of the query which serves the list add a Tabular Reference (pointing at the 2nd query with the additional data item you want to include) to the Children section.  Bring in the data item required, and pass it up through the tabular model and query levels.

Drop the data item in the appropriate cell of the newly created row in the list.

[biejorrun]

Select the footer row in the list.  From the Structure menu select 'Insert List Row Cells Below' (or Above depending on your preference).

In the tabular model of the query which serves the list add a Tabular Reference (pointing at the 2nd query with the additional data item you want to include) to the Children section.  Bring in the data item required, and pass it up through the tabular model and query levels.

Drop the data item in the appropriate cell of the newly created row in the list.

That worked great, thanks!

[COGNOiSe administrator]

You CAN put two queries in one list !?!?! I'd never thought of that!

Thanks, MDX! Good lesson.

[MDXpressor]

It's my patented move.   ;D