Nick, I figured it out - we needed to limit to LOC authorized values: SELECT IFNULL(a.lib,'*GRAND TOTAL*') as Location, thingy.circs AS Circulations FROM (select i.location as loction, count(s.datetime) as circs from statistics s left join items i using (itemnumber) left join borrowers p using (borrowernumber) where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and s.branch=<<Check out/renewal branch|branches>> and s.datetime between <<Checked out or renewed between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> group by i.location with rollup ) AS thingy LEFT JOIN authorised_values a on thingy.loction=a.authorised_value where a.category='LOC' On Tue, Mar 25, 2014 at 1:08 PM, Nick Clemens <nick@quecheelibrary.org> wrote:
Here's a thought, it might be an error in the authorized values., and I think it is a bug
I recreated it on our system by adding an authorized_value in a different category with the same value as one in the LOC: i.e. I added AFIC to our Vendor category, with description Error! The system doesn't throw an error, and I can't see that value in the listing, but it is then 'Adult Fiction' is duplicated in my report
Is the issue clear?
On Thu, Mar 20, 2014 at 7:04 PM, Nicole Engard <nengard@gmail.com> wrote:
Okay, any idea why the Juveasy might be showing 2 times?
http://screencast.com/t/6dbByW4eZ
I added the location code in case that was it - they're identical as are their numbers.
On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard <nengard@gmail.com> wrote:
Thank you so much Nick!!
Nicole
-- Nick Clemens Quechee & Wilder Libraries Nick@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341