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

data records next to each other

Started by dollipi, 21 Oct 2013 09:05:24 AM

Previous topic - Next topic

dollipi

Hello,

I have created a list in report studio:

Column A Customer Number
Columd C Serial Number of Machine

When a customer has several machines, the serial numbers will be displayed below each other.
But I want to have the serial numbers next to each other. Is this possible (maybe with data items)?

Best regards,
D.

Lynn

You could use a master-detail relationship connecting a list to a repeater.

Master query will bring back the customer numbers and the detail query will bring back customer number and serial number with customer number obviously being the link between them.

Put the customer information from the master query in the list, and then drag in a repeater layout container and associate it with the detail query and setting the m-d relationship. That will let you put the serial number into the repeater so they appear side by side. You can include a comma between them (there are techniques in other topics on how to suppress the comma after the last serial number) or just use a space.

Another option is a repeater table that would allow you to arrange the serial numbers in a specific number of cells down and across.

Fair warning: there may be performance implications in using a master-detail relationship since you'll get the detail query firing for each customer returned by the master.

dollipi


blom0344

There is a fairly complex way to improve master-detail performance. The detailed procedure can be found here:


http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html