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.
Solved! Go to Solution.
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:
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?
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: