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.
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.
Many thanks, I'll try it!!
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 (http://www.ibm.com/developerworks/data/library/cognos/reporting/performance_and_tuning/page582.html)