[Evergreen-reports] Dewey Tens Call Number Report with Null Values

[Sharp, Chris]

Jessica,

Would you mind sharing the Generated SQL from the Debugging Info screen?  That would help me know how the template is currently joining tables.

Thanks,

Chris

----- Original Message -----
> From: "Jessica Venturo" <jventuro at biblio.org>
> To: "Evergreen Community Reports Email List" <evergreen-reports at list.evergreen-ils.org>
> Sent: Tuesday, April 29, 2014 5:24:13 PM
> Subject: [Evergreen-reports] Dewey Tens Call Number Report with Null Values
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Hi all,
> 
> A librarian in our consortium has requested a report that shows
> circulation by Dewey ten blocks, filtered by check out date range,
> the library where the item was checked out, and owning library of
> the item. The template was easy to assemble using the Classic
> Circulation source. However, they have recently requested that the
> report list ALL of the Dewey ten blocks - not just the ones that had
> circulations within the given time period. In other words, they
> would like those Dewey blocks from which no items circulated to
> display in the report with a value of "0." I had originally thought
> to use the Classic Item Source and rebuild the template, but alas,
> it does not seem that there is a link to the circulation table from
> that source. I am hoping that someone with more experience with
> nullabilty than me can give me some pointers on how to alter my
> original template so that it displays the information this way (if
> it's possible).
> 
> The display field that I'm using are:
> Classic Circulation View > Dewey Block - Tens (Transform - Raw Data)
> Classic Circulation View > Circulation (ID, Transform - Count)
> 
> The filters I'm using are:
> Classic Circulation View > Library Circulation Link (Transform - Raw
> Data, Operator - In List)
> Classic Circulation View > Copy Link > Circulating Library (Transfom
> - Raw Data, Operator - In List)
> Classic Circulation View > Circulation Date/Time (Transform - Date,
> Operator - Between)
> 
> Any help you can give would be appreciated!
> 
> Thanks,
> Jessica
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> 
> Jessica Venturo
> Applications Support Specialist
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> 203-577-4070 x105
> _______________________________________________
> 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/