[Evergreen-reports] Circulation Report

[Chris Sharp]

Kate,

Can you share the "Generated SQL" from the Debugging Output from one of your attempts?  I'd be happy to see if I can help you get what you want.

Thanks,

Chris

----- Original Message -----
> From: "Kate Butler" <KateButler at rodgerslibrary.org>
> To: evergreen-reports at list.evergreen-ils.org
> Sent: Monday, December 14, 2015 4:57:38 PM
> Subject: [Evergreen-reports] Circulation Report
> 
> 
> 
> We are trying to get a report that shows us circulations in the past three
> months and also total circulations for items in a shelving location. We want
> the report to include all the items in the shelving location, including the
> ones with 0 circulation activity in the past 3 months.
> 
> 
> 
> I can see from the archives that this has come up before, and the problem
> we’re encountering (as soon as you add the filter for circs in a date range,
> you lose any items with null activity in that range) has been discussed, but
> it wasn’t clear that anyone had successfully created this report, even with
> nullability enabled.
> 
> 
> 
> Has anyone managed it? What is the secret?
> 
> 
> 
> Kate Butler
> 
> Technology Librarian
> 
> Rodgers Memorial Library (Hudson, NH)
> 
> http://www.rodgerslibrary.org/
> 
> 
> 
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
> 

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/