[OPEN-ILS-GENERAL] Duplication in Reports

[Patrick, Irene]

I have another, more general, question about reports in Evergreen.  Some reports return information that is duplicated.  When we were on our previous ILS, I could use SELECT DISTINCT to eliminate rows where all the information was duplicated.  Is there any way to do that in Evergreen reports?  Now that I'm starting to need more complicated reports, it would sure be helpful to be able to get rid of the duplicates.

Thanks for any advice you can share!


[cid:image001.png at 01D5204E.DAD7A080]Irene Patrick
Library & Information Management Systems Librarian, NC Government & Heritage Library
NC Dept. of Natural and Cultural Resources
919.814.6788  |  irene.patrick at ncdcr.gov<mailto:irene.patrick at ncdcr.gov>
(Please note new phone number)

109 E. Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
Facebook<http://www.facebook.com/ncghl>  Instagram<https://www.instagram.com/foreverythingnc/>  Twitter <https://twitter.com/ForEverythingNC>   YouTube<https://www.youtube.com/statelibrarync>  Website<https://statelibrary.ncdcr.gov/>

Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190611/eb69a324/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8625 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190611/eb69a324/attachment.png>