[OPEN-ILS-GENERAL] Help with reports - need end of year stats - can't get data - blank report

[Walz, Jennifer]

Chris,

I was trying to do that yesterday and I don’t remember how to find that.  <sigh>  It was a long and messy day.

    I’ll try to find it and post that back to you.   Could be that Brent’s suggestion is what the problem is on one front though.   Just reverse the dates.  Grief!   Why is that?

Thanks!

Jennifer

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Chris Sharp
Sent: Wednesday, June 29, 2016 7:29 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Help with reports - need end of year stats - can't get data - blank report

Jennifer,
If you can post the "Generated SQL" section of the Debugging Info in the report output, I can probably help.
Thanks,
Chris

On Wed, Jun 29, 2016 at 7:10 PM, Brent Mills <brent at hoodriverlibrary.org<mailto:brent at hoodriverlibrary.org>> wrote:
Jennifer,

And there is a ‘canned’ report from Equinox that is Count Items Added by Date Range.    But nothing ever comes out.  I just get a blank.   I’ve tried all kinds of date ranges and don’t know what is wrong.

Have you tried putting the older date range value in the first section of the between? I think that’s been an issue with a few of our date range reports.


[cid:image001.png at 01D1D2B7.CAF4BD20]

-Brent

-----------------------------

Brent Mills
Systems Librarian | Sage Library System

email: brent at hoodriverlibrary.org<mailto:brent at hoodriverlibrary.org>
tickets: https://sagesupport.eou.edu
phone: 541.610.8384<tel:541.610.8384>

On Jun 29, 2016, at 1:47 PM, Walz, Jennifer <jlwalz at asbury.edu<mailto:jlwalz at asbury.edu>> wrote:

And there is a ‘canned’ report from Equinox that is Count Items Added by Date Range.    But nothing ever comes out.  I just get a blank.   I’ve tried all kinds of date ranges and don’t know what is wrong.




--
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160630/9c3d63a4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 19733 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160630/9c3d63a4/attachment-0001.png>