I have the following codes as Item Variant codes:
Code
ZMF21, ZMH20, ZMH21, ZMK20, ZMK21, ZMN20, ZMQ20, ZMV20, ZMZ20.
I'd like my JetReport to sort first by right (2), then by code. (i.e. the right (2) designate the fiscal year.). These variant codes are "externally determined", so I can't "rename" the variant codes.
How do you create a sort by specific characters within a string is the more universal question?
| ZMH20 |
| ZMH21 |
| ZMK20 |
| ZMK21 |
| ZMN20 |
| ZMQ20 |
| ZMV20 |
| ZMZ20 |
Kent Mogler, you'll have to construct a calculated field as the FilterField argument of your NL("rows") function and then apply sorting as normal
NL("rows", ... "=nf(,)", "*"
Basic Sorting: https://www.youtube.com/watch?v=LcaYKDYcA4c
Constructing and sorting on calculated Fields: https://www.youtube.com/watch?v=HaIAMP4dBHg
Hope that gets you started.
If you are trying to sort based on parts of two different fields, it might looks something like this: =@NL("rows","customer",,"+=RIGHT(NF(,""No.""),2)&LEFT(NF(,""Name""),5)","*")
