# Repeats in Feature Report as two columns

773
2
03-22-2023 08:58 AM
by
MVP Regular Contributor

Wondering if someone has an easier way to get a repeat to appear as two columns in a Feature Report. Specifically, an image question inside a repeat. Using images with the multiline appearance doesn't work for me as there is a bunch of other data accompanying the images.

Essentially, I want images to appear like this (a single table with unlimited length):

With a convoluted calculate, I can get this (two tables nested inside a larger table, and the repeat is limited by IF statements). This one actually looks really good, but has two limitations: 1) Silly IF statement, and 2) Empty table rows that need to be manually deleted.

If you are curious, the calculate below is essentially what I am doing to create the second table. In the Feature Report, the left table only populates with "odd" items, and the right only populates with "even" items.

Tags (2)
1 Solution

Accepted Solutions
by
MVP Regular Contributor

I deleted my original example. But in doing so, I figured out the (painfully simple) math when I had to recently recreate it. So, now this works with any number of repeat items.

Here is what I have in S123 (Attached):

The result of the math is either 0 or 0.5. To make things easy in the Feature Report, I converted those to either 'A' or 'B'. You can obviously change the three "text" rows to "calculate" instead. I just made them "text" to show what was going on.

This is my Feature Report (Attached. There are hidden tables that make this annoying):

This is the output:

Limitations:

1. Different sized photos can make things fall out of alignment
2 Replies
MVP Regular Contributor

Clever workaround, thanks for sharing! I am curious what your report template looks like....are the cells that are showing up as empty hard-coded into the template?

Best,
Katie

“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
by
MVP Regular Contributor

I deleted my original example. But in doing so, I figured out the (painfully simple) math when I had to recently recreate it. So, now this works with any number of repeat items.

Here is what I have in S123 (Attached):

The result of the math is either 0 or 0.5. To make things easy in the Feature Report, I converted those to either 'A' or 'B'. You can obviously change the three "text" rows to "calculate" instead. I just made them "text" to show what was going on.

This is my Feature Report (Attached. There are hidden tables that make this annoying):

This is the output:

Limitations:

1. Different sized photos can make things fall out of alignment