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

[Jessica Venturo]

Hi Elisabeth,

Pivot columns change the output so that the one of the display fields is
listed across the top of the report - it doesn't change the data itself.
You may have seen 0s in a report that you ran because there were some
columns and rows that had no intersecting data.  This report only has
column to pivot on, so unfortunately, that doesn't work for this particular
report.

Thanks, I appreciate the suggestion!

Jessica


On Tue, Apr 29, 2014 at 5:58 PM, Elisabeth Keppler <keppleep at forsyth.cc>wrote:

> This may be naive, but the only way I've found to get  "0" values included
> is to submit a report with a Pivot Label Column defined.  When the output
> is in table form instead of a list, the "0"s appear.
>
> Thanks,
> Lise
>
>
> On Tue, Apr 29, 2014 at 5:24 PM, Jessica Venturo <jventuro at biblio.org>wrote:
>
>> 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
>>
>>
>
>
> --
> Lise Keppler
> Forsyth County Public Library
> 660 W 5th St
> Winston Salem NC 27101
> 336-703-3070
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
>


-- 
Jessica Venturo
Applications Support Specialist
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 x105
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20140429/9f3dbad6/attachment.html>