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 <[email protected]> wrote: > 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: > [email protected]] *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 <[email protected]> > 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: [email protected] > tickets: https://sagesupport.eou.edu > phone: 541.610.8384 > > > > On Jun 29, 2016, at 1:47 PM, Walz, Jennifer <[email protected]> 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
