<div dir="ltr"><div><div><div>Hi Elisabeth,<br><br></div>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.<br>
</div><div><br></div>Thanks, I appreciate the suggestion!<br><br></div>Jessica<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Apr 29, 2014 at 5:58 PM, Elisabeth Keppler <span dir="ltr"><<a href="mailto:keppleep@forsyth.cc" target="_blank">keppleep@forsyth.cc</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div>
<br></div><div>Thanks,</div><div>Lise</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Tue, Apr 29, 2014 at 5:24 PM, Jessica Venturo <span dir="ltr"><<a href="mailto:jventuro@biblio.org" target="_blank">jventuro@biblio.org</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><div><div><div><div><div><div><div><div><div>Hi all,<br><br></div>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).<br>
<br></div>The display field that I'm using are:<br></div>Classic Circulation View > Dewey Block - Tens (Transform - Raw Data)<br></div>Classic Circulation View > Circulation (ID, Transform - Count)<br><br></div>
The filters I'm using are:<br></div>Classic Circulation View > Library Circulation Link (Transform - Raw Data, Operator - In List)<br></div>Classic Circulation View > Copy Link > Circulating Library (Transfom - Raw Data, Operator - In List)<br>
</div>Classic Circulation View > Circulation Date/Time (Transform - Date, Operator - Between)<br><br></div>Any help you can give would be appreciated!<br><br>Thanks,<br>Jessica<span><font color="#888888"><br clear="all">
<div><div><div><div><div><div>
<div><div><div><div><div><div><div><div><br>-- <br><div dir="ltr">Jessica Venturo<div>Applications Support Specialist</div><div>Bibliomation, Inc.</div><div>24 Wooster Ave.</div><div>Waterbury, CT 06708</div><div><a href="tel:203-577-4070%20x105" value="+12035774070" target="_blank">203-577-4070 x105</a></div>
</div>
</div></div></div></div></div></div></div></div></div></div></div></div></div></div></font></span></div>
<br></div></div>_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Lise Keppler<div>Forsyth County Public Library<br></div><div>660 W 5th St</div><div>Winston Salem NC 27101</div>
<div><a href="tel:336-703-3070" value="+13367033070" target="_blank">336-703-3070</a></div></div>
</font></span></div>
<br>_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">Jessica Venturo<div>Applications Support Specialist</div><div>Bibliomation, Inc.</div><div>24 Wooster Ave.</div><div>Waterbury, CT 06708</div><div>203-577-4070 x105</div>
</div>
</div>