Selecting Nth value from list of values

Stimulsoft Reports.WEB discussion
Post Reply
evflores001
Posts: 21
Joined: Wed Dec 02, 2020 9:21 pm

Selecting Nth value from list of values

Post by evflores001 »

Hello,

I was wondering if it is possible to select the Nth value from a list of values.

For example, say I have a list of loans and I wanted to select the second biggest loan, how could I do so?

Thank you.
Lech Kulikowski
Posts: 6238
Joined: Tue Mar 20, 2018 5:34 am

Re: Selecting Nth value from list of values

Post by Lech Kulikowski »

Hello,

You can sort Databand by the necessary value and use Line==2 in the Filter or Conditions.

Thank you.
evflores001
Posts: 21
Joined: Wed Dec 02, 2020 9:21 pm

Re: Selecting Nth value from list of values

Post by evflores001 »

Awesome! Thank you
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Selecting Nth value from list of values

Post by Andrew »

You are welcome!
evflores001
Posts: 21
Joined: Wed Dec 02, 2020 9:21 pm

Re: Selecting Nth value from list of values

Post by evflores001 »

Is it possible to call a specified Line from a data databand from a summary band? If so, how would I call it using a text box object?

For example, lets say I want to retrieve information from the second line of a databand (i.e., Line==2).
StimulsoftLines.png
StimulsoftLines.png (37.95 KiB) Viewed 2113 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Selecting Nth value from list of values

Post by HighAley »

Hello.

You could add a data band and set Filter to Line==2.

Thank you.
Post Reply