Page 1 of 2

how to show value of prev and next row?

Posted: Thu Aug 07, 2008 10:39 am
by 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

....


how to show value of prev and next row?

Posted: Thu Aug 07, 2008 2:12 pm
by Vital
Hello,

You can use functions Next and Previous. For example:

Code: Select all

{Next(products, "columnname")}
Thank you.

Re: how to show value of prev and next row?

Posted: Wed May 29, 2024 2:28 pm
by 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?

Re: how to show value of prev and next row?

Posted: Wed May 29, 2024 7:34 pm
by Lech Kulikowski
Hello,

You can use the VLookup function.

Thank you.

Re: how to show value of prev and next row?

Posted: Thu May 30, 2024 7:25 am
by 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

Re: how to show value of prev and next row?

Posted: Thu May 30, 2024 7:47 am
by Lech Kulikowski
Hello,

Please check the last release 2024.2.6 version.

Thank you.

Re: how to show value of prev and next row?

Posted: Thu May 30, 2024 8:44 am
by 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")}

Re: how to show value of prev and next row?

Posted: Thu May 30, 2024 9:10 am
by Lech Kulikowski
Hello,

In your data should be added index numeric column.

Thank you.

Re: how to show value of prev and next row?

Posted: Thu May 30, 2024 10:43 am
by 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

Re: how to show value of prev and next row?

Posted: Fri May 31, 2024 6:18 am
by hcelik1
do you any suggestion @Lech Kulikowski

thanks