I wish to use the NL function with the feilds I choose in that specific order, not alphabetical. Can this be done?
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi,
Aaah, so I didn't understand what you meant by sorting fields originally. You mean sorting the values returned, not the list of fields. Sorry, that's my fault; I just read your question wrong.
So let me see if I understand what you want. You have a cell where you are specifying a filter for 3 values (companies in this case). Your filter looks something like this:Beta Co|Alpha Co|Charlie Co.
And you just want to list these 3 values across columns in the order specified, is that right? In this case, you can do this easily without even accessing the database. Just do something like this:=NL("Columns",NP("Split",$D$3,"|"))
This will split the values in the cell based on the | character and then replicate that list (without doing any sorting). Since you just want the exact values specified, there is no need to go to the Company table. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Sure, you can. I'm not sure what context you mean here. Are you talking about the Jfx? The Browser? The Table Builder? The Report Builder? I don't think the NL function itself generally alphabetizes fields unless you don't specify any fields in an NL(Table) function.
Regards,
Hughes -
Jet Reports Historic Posts I wish to use the NL function with the feilds I choose in that specific order, not alphabetical. Can this be done?
Here is the list which sets out the collomns per a specified field.
=NL("Columns","Company","Name","Name",$D$3)
The fields in the cell are Beta Co, Alpha Co, Charlie Co.
The NL function then sorts these alphabetically, not in the orginal order I chose them. -
Jet Reports Historic Posts Works like a charm.
Thanks.
Please sign in to leave a comment.