[Evergreen-reports] Including ID as first column

[Tiffany Little]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220805/9d9f6602/attachment.htm>