If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multiple Lines Of Comments for each invoice

Started by rpvs, 09 Nov 2009 10:32:14 AM

Previous topic - Next topic

rpvs

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!!

cschnu

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

Sreeni P

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.

rpvs

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.