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

2016-06-30 Thread Walz, Jennifer 
Elizabeth,

Thanks!   This is very helpful.

Jennifer

From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of 
Thomsen, Elizabeth
Sent: Thursday, June 30, 2016 11:18 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Help with reports - need end of year stats - 
can't get data - blank report

Glad you found your answer!

Report templates can be complicated, and it's not always easy to understand 
what each element of the template means, especially if you don't use the same 
templates frequently. We've found it useful to add field hints and links to 
local documentation to the report templates.  This was an enhancement in 
Release 2.7:
https://esilibrary.com/documentation/2-7-enhancements-to-reports/

It takes a little time to set these up, but it saves time in the long run  and 
promotes consistency in reports.

--
Elizabeth B. Thomsen
Member Services Manager
NOBLE: North of Boston Library Exchange
Danvers, Mass.
www.noblenet.org

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

2016-06-30 Thread Willis, Beth 
Jennifer,

Sounds like you have figured out why your report was blank.  To see the
report SQL, when viewing your report output, just click on the "Debugging
info" link.

Beth

On Thu, Jun 30, 2016 at 10:10 AM, Walz, Jennifer  wrote:

> Chris,
>
>
>
> I was trying to do that yesterday and I don’t remember how to find that.
>   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-boun...@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 
> 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.
>
>
>
>
>
>
>
> -Brent
>
>
>
> -
>
> Brent Mills
> Systems Librarian | Sage Library System
>
> email: br...@hoodriverlibrary.org
> tickets: https://sagesupport.eou.edu
> phone: 541.610.8384
>
>
>
> On Jun 29, 2016, at 1:47 PM, Walz, Jennifer  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
>



-- 
Beth Willis
Digital & Catalog Librarian
NOBLE, Inc.
26 Cherry Hill Drive
Danvers, MA 01923

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

2016-06-30 Thread Mike Rylander 
Jennifer,

It does this because a range goes from first (earliest) to last (latest).
That is true for any "between" (range) query, regardless of the data type.

Hope that helps.

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com
On Jun 30, 2016 10:22 AM, "Walz, Jennifer"  wrote:

> Brent,
>
>
>
> Thanks!
>
>
>
>   This did it.Whew.  I thought maybe I was going nuts. WHY does it
> do this? And can some instruction be listed someplace?
>
>
>
>   Just wondering.   Now to figure out how many Titles we added last year.
> Ha!
>
>
>
> Jennifer
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Brent
> Mills
> *Sent:* Wednesday, June 29, 2016 7:10 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,
>
>
>
> 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.
>
>
>
>
>
>
>
> -Brent
>
>
>
> -
>
> Brent Mills
> Systems Librarian | Sage Library System
>
> email: br...@hoodriverlibrary.org
> tickets: https://sagesupport.eou.edu
> phone: 541.610.8384
>
>
>
> On Jun 29, 2016, at 1:47 PM, Walz, Jennifer  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.
>
>
>

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

2016-06-30 Thread Walz, Jennifer 
Brent,

Thanks!

  This did it.Whew.  I thought maybe I was going nuts. WHY does it do 
this? And can some instruction be listed someplace?

  Just wondering.   Now to figure out how many Titles we added last year.  Ha!

Jennifer

From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Brent 
Mills
Sent: Wednesday, June 29, 2016 7:10 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,

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@01D1D2B9.59AE1A60]

-Brent

-

Brent Mills
Systems Librarian | Sage Library System

email: br...@hoodriverlibrary.org
tickets: https://sagesupport.eou.edu
phone: 541.610.8384

On Jun 29, 2016, at 1:47 PM, Walz, Jennifer 
> 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.

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

2016-06-30 Thread Walz, Jennifer 
Chris,

I was trying to do that yesterday and I don’t remember how to find that.  
  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-boun...@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 
> 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@01D1D2B7.CAF4BD20]

-Brent

-

Brent Mills
Systems Librarian | Sage Library System

email: br...@hoodriverlibrary.org
tickets: https://sagesupport.eou.edu
phone: 541.610.8384

On Jun 29, 2016, at 1:47 PM, Walz, Jennifer 
> 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

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

2016-06-30 Thread Elisabeth Keppler 
I bet Brent is right!  If you are using relative dates in your parameters
instead of real dates (such as saying you want everything created 1 to 12
months ago), it's easy to enter them backwards.  In the example he
provided, the top parameter would 12 months and the bottom parameter 1
month.

On Wed, Jun 29, 2016 at 7:10 PM, Brent Mills 
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.
>
>
>
> -Brent
>
> -
>
> Brent Mills
> Systems Librarian | Sage Library System
>
> email: br...@hoodriverlibrary.org
> tickets: https://sagesupport.eou.edu
> phone: 541.610.8384
>
> On Jun 29, 2016, at 1:47 PM, Walz, Jennifer  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.
>
>
>


-- 
Lise Keppler, Technical Services
Forsyth County Public Library
2851 Fairlawn Dr
Winston Salem NC  27106
336-703-3048