COGNOiSe.com - The IBM Cognos Community

Hi All,

Am authoring a report where i need to list several lines of comments for each invoices if they are not blank. Sample of report below

  Customer#       INVOICE#    Due Date        Amt Due     Comments
    xxxx              xxxxxxx       01/01/01          111111       Line1
                                                                                    Line 2
                                                                                    Line 5
                                                                                    Line 15

  yyyy              yyyyyy       02/02/02          222222          Line3
                                                                                    Line 4
                                                                                    Line 7
                                                                                    Line 14
Would like to know how to list all the lines of comments in the comment column for each invoice#

Thanks!!

You might want to create the master-detail relationship, take a look at the documentation for  Create a Master Detail Relationship in the PROFESSIONAL AUTHORING USER GUIDE

u can do this using "HTML item" also, using "html item" u can build a custom alert box on comments column , using java script, but it works only in HTML view.

Thanks for your suggestions. I was reading the RS user guide on a issue related to bursting and found another solution to this problem. First unlock the page objects , drag a table to the column and specify #rows to fit all the lines of comments in the table and drag each comment line to the rows of the table. Detailed explanation with example is in RS user guide (Ver 8.2 , Page 146 titled ADD MULTIPLE  ITEMS TO A SINGLE COLUMN).
Thought i would share what i found.