[OPEN-ILS-GENERAL] Duplication in Reports

[Kate Coleman]

Would deduplicating the column in Excel work? I have to do that a lot with
some of my reports. I find that reports generally give the information I
need, but I have to manipulate the returned information into what I want in
Excel.


Kate Coleman
Jefferson County Library - Central Services
Technical Services Specialist
5678 State Rd. PP
High Ridge, MO 63049
636-677-8689
Fax: 636--677-1769
kcoleman at jeffcolib.org




On Tue, Jun 11, 2019 at 11:12 AM Patrick, Irene <irene.patrick at ncdcr.gov>
wrote:

> 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!
>
>
>
>
>
> *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
>
> *(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/d418791e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8625 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190611/d418791e/attachment-0001.png>