Impromptu - Sommury information

[GilMerc]

Hi,

I find how I can sommurize some information in a footer of a group.
For exemple, in the report I have two field («recept», «ingredient»). The data is grouping by «recept». In a footer of group «recept» I would like to repeat all ingredients. It seems impossible to concat the same field for different occurrence.
The result will must be :
RECEPT INGREDIENT
R1 I1
I2
I3
------------------------------
R1 I1, I2, I3
------------------------------
R2 I1
I2
------------------------------
R2 I1, I2
------------------------------
etc.

Somebody know how to do this,
thank's in advance.

Gilles.

 

[griffindm]

Gilles,

The only way I know to do this is to set the page scope to be the group, then insert a distinct list frame sub-report into the page footer. It can only handle so much data though, and will not wrap to the next page if it overflows.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com