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
My English is even worse ... I'm Polish ;D
You could "fake it" by forsing exact widths of columns for each query.
Thanks! I will try that!
Björn
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.
Quote from: MDXpressor on 30 May 2007 11:16:35 PM
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!
You CAN put two queries in one list !?!?! I'd never thought of that!
Thanks, MDX! Good lesson.
It's my patented move. ;D