I am building a list of values on a select from a table. I noticed that even if I don't use DISTINCT in the select, when it comes to running the report, the LOV seems to automatically use DISTINCT. Is that the case or should I use DISTINCT in the select?
By definition a List Of Values item class will contain only distinct values. An LOV that contained one entry for every record with the value "2013" would serve no real function. By virtue of being a LOV each value shown will be unique.