Hi All,
Recently I started working with Jetreports 2009 on a NAV database
At the moment creating very simple reports is ok, now speeding up to improve my skills
For sure I will have questions, and I believe this is the right place to come to ;) to get the answers and help I need!
Thanks in advance for you help
first one, just to be sure I'm thinking in the right direction.
within NL functions the filtering is done in sequence of the filterfield? right?
lets say
Filterfield 1 on field nr. with filter "1*"
Filterfield 2 on field Globe code dimmension 1 with filter "NL"
the report will built up as
show all nr. starting with "1*"
Within this filter show all nr starting "1* AND have the code dimmensions "NL"
In other words, it does matter in which filterfiled position the filterfiled is placed?
and I guess this count for sorting as well?
Jasmon
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Jasmon,
Actually it does not matter what order the filters are in, but it DOES matter for sorting. So think about a theoretical set of data that looked like this:
No. Name
— ——-
01 Bob
02 Bo
03 Belle
04 Scott
05 Sam
06 Mike
07 Mike
Let's say you were filtering for Name with B* and for No. with 02..05. If you applied the name filter first, you have Bob, Bo and Belle, then if you apply the No. filter you get just Bo and Belle. If you apply them in the opposite order you first get Bo, Belle, Scott, and Sam, then you get Bo and Belle. So for filtering it doesn't make a difference what order those are in.
For sorting, it's a different story. If you sorted that list by No., then Name, you would get the records in the order 01, 02, 03, 04, 05, 06, 07. However, if you sorted by Name, then No., you would get 03, 02, 01, 06, 07, 05, 04. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Yes this makes sense
thanks for your help
Please sign in to leave a comment.