Solved: Gallery report in reading direction - Page 2

Bulubulu · 06-30-2023 04:08 AM

Would it be possible to export a report with images arranged in the reading direction, like a comic book ?

Suvrutt_Gurjar

Thank you. Just a while ago, I responded to an exactly similar requirement. The poster there wishes to have bar codes in the gallery view format.

How to Print Barcode Labels - Google Cloud Community

You could replace "Table Name", with "Slice Name" , if you have certain rows from the table in the images. You can create a slice to filter rows with the desired range, such as dates or status ( approved etc) or such similar ranges.

<START: Table Name[Key Column] >>

<<IFS(MOD(COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & Table Name[Key Column] & " , "),
(" , " &[Key Column] & " , ")
)
),
" , "
)
), 4)=1,

[Image Column]

)>> <<END>>

<START: Table Name[Key Column] >>

<<IFS(MOD(COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & Table Name[Key Column] & " , "),
(" , " &[Key Column] & " , ")
)
),
" , "
)
), 4)=2,

[Image Column]

)>> <<END>>

<START: Table Name[Key Column] >>

<<IFS(MOD(COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & Table Name[Key Column] & " , "),
(" , " &[Key Column] & " , ")
)
),
" , "
)
) , 4)=3,

[Image Column]

)>> <<END>>

<START: Table Name[Key Column] >>

<<IFS(MOD(COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & Table Name[Key Column] & " , "),
(" , " &[Key Column] & " , ")
)
),
" , "
)
), 4)=0,

[Image Column]

)>> <<END>>

Edit: made a minor change in last column's expression. It needs to he compared with 0 and not 4 as earlier I mistakenly mentioned.

Edit2: Made a change to the denominator in the expression. Changed it from Table Name[Key Column] to 4 as we need images in 4 columns.

Edit3: There was a typo in MOD() expression, which I have corrected above. So now the above shared template should work. I have updated the typo details and also test results on a test app in the post thread How to Print Barcode Labels - Google Cloud Community

Please take a look at that thread as well.

View solution in original post