[Resolved] List with two rows for each record

[ourhari1]

Hello,

I'm new to Cognos 10 report development and for one of the report that I'm working, I am facing an issue.
Please refer to the attached image.

The list contains 5 columns, and the query contains 6 columns. Whenever the 6th column (Remarks) is not empty, we need to show the remarks in the list as shown in the image. i.e., it should be displayed in a new rows with the content spanning for the first 4 columns.

Could you please help me resolve this issue.

Your help is much appreciated.

Thanks & regards,
Hari

[Lynn]

You could try using a repeater table instead of a list to get the layout as you describe. A conditional style on the remarks element could be used to suppress it unless there is content.

You could also try to group the list and create a group footer to contain the remarks, similarly suppressing if there is no content for remarks.

[ourhari1]

Hi Lynn,

Thanks for the reply. I'll try both the approaches and let you know the results.

Regards,
Hari

[ourhari1]

I have tried with the Repeater Table and it partially resolves the issues. Please see attached report layout and PDF output.

# 1. The headers defined for the Repeater table is repeating for every row in the query. I define the headers as a separate columns in the same table. I resolved it using conditional styling; i.e., by suppressing the display when header column is empty. However, it creates a new issue; by showing thick lines between rows. Please see the attached image.

# 2. Even though I define the repeater table property as Fixed, and I define size for all 5 columns (20%, 30%, 10%, 30% and 10%), the PDF output does not adhere to this size definition. If you look at the first row, it did not follow the above mentioned % values. Similarly, all other rows, where there is no header (suppressed by conditional styling), they are almost of equal size.

# 3. The headers are not repeated for sub-sequent pages.

Could you please review the above and let me know how can I resolve these issues?

In the mean time, I'll also try with the second approach (List with grouping footer) and let you know the results.

Thanks and Regards,
Hari

[ourhari1]

Hi Lynn,

"List with group footer" approach works very well for the report scenario that I have. Please see the attached image.

#1. I added all 5 columns in the query as the group columns; since there is no unique key available. Also, used the 5th column (NUM1) as the first grouping key to make the list sorted on NUM1.

#2. For the group footer, I had to change the "List inner footer cell" style to "List column body cell" in order to make it in line with the table look and feel.


Thank you very much for showing the right direction. It is really helpful.

Thanks and Regards,
Hari

[Lynn]

Glad you got it working! It was very nice of you to provide the details for your solution in case anyone else finds it useful.