[Evergreen-reports] Including ID as first column

[Willis, Beth]

Hi Tiffany,

That's a really helpful reminder of how the reporter works!

Thanks.
Beth

On Fri, Aug 5, 2022 at 2:13 PM Tiffany Little via Evergreen-reports <
evergreen-reports at list.evergreen-ils.org> wrote:

> Hi everyone,
>
> I just wanted to pass this on if anyone else has ever been as stumped as I
> just was for about two hours.
>
> Sometimes putting the ID of a field as your first column in your report is
> a good thing, because the reporter likes to group things together. Putting
> the ID first keeps them separate because it's unique.
>
> So I was trying to run a report for debits in an Acquisitions fund. I had
> Amount as the first column. When I did a direct DB query, there were 736
> debits, but my report was only getting 432. Putting the same query the
> reporter had made into the DB, I got 736. So I surmised that there wasn't
> anything wrong with the construction of my report. So I tried putting Debit
> ID in the first column, and lo and behold, I got 736 results.
>
> If you click the "Debugging Info" link on a report result, you can see at
> the bottom it will say "Group by 1,2,3[...]" My assumption is that the
> reporter was grouping by Amount because it was my first column, and so I
> wasn't seeing all my results or they were lumped weird. (My explanation
> just got super technical, I know.)
>
> So--just in case anyone didn't already know that, hope it helps someone!
>
> Tiffany
>
> Tiffany Little, PINES Services Specialist: Acquisitions
>
> ------------------------------
>
> Georgia Public Library Service | University System of Georgia
>
> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>
> (404) 235-7161 | tlittle at georgialibraries.org
>
> Join our email list <http://georgialibraries.org/> for stories of Georgia
> libraries making an impact in our communities.
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>


-- 
Beth Willis
Digital & Catalog Librarian
NOBLE, Inc.
42 Cherry Hill Drive
Danvers, MA 01923
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220805/fcdd85d8/attachment.htm>