alignment in two different databand values and removing dup.

[shivkrsingh]

hi,
I have used two databand on panel inside a databand. there is a sequence of data for I want to break it in column but only one part and want to remove duplicate data from other(band5) and align each data of band5 and band4. How Can I achieve this. I have attached my sample with it.

thanks

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your task. Can you please send us a screenshot how it should look like.

Thank you.

[shivkrsingh]

Please find the attached screenshot. If you will check first column which is databand5 you will find duplicate values. All values comes three times. I want to take only one and want to remove others. so that they can align by row with other band as shown in screenshot.

thanks.

[Alex K.]

Hello,

In this case you need use the master-detail construction. Where master - it is data grouped by Name and detail - it is data from "Filter" source.
Please check the modified report in the attachment.

Thank you.

[shivkrsingh]

thanks for the answer it works but I do not want to change the sequence of column data orientation. by creating group it sorts data according to name. I do not want sorting. it should be in same order as it was coming in XML. how to achieve it.

thanks

[Alex K.]

Hello,

In this case, please try to add the additional datasource, which will be contain only the Name column without duplicates and without sorting. And use it source as master data.

Thank you.