Is there a way to select a distinct set of records like SQL’s SELECT DISTINCT in the report writer?
dlombardozzi, Could you be a little more clearer as to what you’re trying to achieve - what does SELECT DISTINCT do?
No. You should be able to do a search and see the previous solutions offered for showing unique records in tables with compound keys. Django
Hi, think of this as likle asking how to create a Holerith field in C++, the question does not make sense. Rather than asking how to translate a function, try to do it the Navision way, this will probably then make more sense. Please ask the question of what you want to do, not how you want to achive it.
You shuld look at the group footers. There You can get something similar to select distinct. There’s at good description of group footers in the manual. You can alsp create a report with the wizard and choos to have grouping. Then You’ll see how it works /Lars
Thanks Lars, the group footers are what i was looking for. -Doug