how to show value of prev and next row?

[progame]

The report need show each row in one page, and in pageheader show prev row and next row value.

like this:
products: car, moti, mobile

page 1:
prev product: , next product:moto
Car

page 2:
prev product:car , next product:mobile
moto

....

[Vital]

Hello,

You can use functions Next and Previous. For example:

Code: Select all

{Next(products, "columnname")}

Thank you.

[hcelik1]

Hi
I want show 3 item in same row. So I need item,next item, 2 next item.


How can I get the second and third next element?

[Lech Kulikowski]

Hello,

You can use the VLookup function.

Thank you.

[hcelik1]

Hi
I use js designer

this not work for me in js designer
{VLookup(Line+1,gayrimenkulBilgileri,"gayrimenkulKod","ilce")}


next work but VLookup does not work in js designer

{Next(gayrimenkulBilgileri, "il")}


thanks

[Lech Kulikowski]

Hello,

Please check the last release 2024.2.6 version.

Thank you.

[hcelik1]

Hi
it does not work form me, my js designer version is 2024.2.6
you can see attachment file

I have 4 items in array. I want to show 3 items in a row instead of one item

{ekspertizKayitlar.parsel} {VLookup(Line+1,ekspertizKayitlar,"ada","parsel")} {VLookup(Line+1,ekspertizKayitlar,"ada","parsel")}

[Lech Kulikowski]

Hello,

In your data should be added index numeric column.

Thank you.

[hcelik1]

Hello,
you have 8 items (products) in your report. You have 4 column so there should be two line but it has 8 lines.
how can i avoid duplicates products?

I want show 3 or 4 items in one row

[hcelik1]

do you any suggestion @Lech Kulikowski

thanks