<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:637035738;
mso-list-type:hybrid;
mso-list-template-ids:378828508 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Beth,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>We have the same issue at Biblio. We handle it the same way it sounds like you do – we move the old report to a nonshared folder. So far, I have tried to curtail the issue by encouraging libraries to clone reports to their own folders. However, this creates another issue in which the reports that the libraries run for themselves are often not the most up-to-date version. We have discussed implementing a procedure that would only retain report data for a limited time (a month, for example), which would allow us to clean out that folder full of broken reports after a time, and limit the number of old reports that are being stored in the database.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>The Pivot Label Column is very good for generating counts of things based on two different criteria. For example, we run a report at the end of our fiscal year that breaks out number of circulations by month and by shelving location. We choose “Month” as the Pivot Label Column, and we as a result we get the months listed across the top of the output as column headers and the shelving locations listed along the side, so the report actually shows total number of circulations by month and shelving location. Then, we total the columns and rows in Excel. I’ve attached an example of one of last year’s reports (This was before we did our shelving location cleanup project, but we still have a lot of shelving locations).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hope this helps!<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jessica<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>---<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jessica Venturo<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Applications Support Specialist<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> Bibliomation, Inc.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>24 Wooster Ave.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Waterbury, CT 06708<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 203-577-4070 ext. 105<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> evergreen-reports-bounces@list.evergreen-ils.org [mailto:evergreen-reports-bounces@list.evergreen-ils.org] <b>On Behalf Of </b>Cristina Hernandez Trotter<br><b>Sent:</b> Wednesday, June 12, 2013 6:35 PM<br><b>To:</b> Evergreen Community Reports Email List<br><b>Subject:</b> Re: [Evergreen-reports] Deleting Templates and<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi, Beth,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I am not able to offer any help with your first question, but here is a link to instructions for a template that uses the Pivot Label Column:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="http://ocrl.org/chtrotter/reports/Average%20Number%20of%20Circulations%20by%20Weekday%20and%20Time%20(Circ%20Source).pdf">http://ocrl.org/chtrotter/reports/Average%20Number%20of%20Circulations%20by%20Weekday%20and%20Time%20(Circ%20Source).pdf</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>(Please excuse extra blank page. Gotta fix that!)<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Since you mention that you have basic proficiency in Excel, you might be interested in watching the screencast where I cover the tip in step 5. The video is embedded in this blog post:<o:p></o:p></p></div><div><p class=MsoNormal><a href="http://reportsblog.blogspot.com/2011/06/copy-and-paste-part-1-selecting.html">http://reportsblog.blogspot.com/2011/06/copy-and-paste-part-1-selecting.html</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Hope this is of some help,<o:p></o:p></p></div><div><p class=MsoNormal>Cristina<o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Wed, Jun 12, 2013 at 3:54 PM, Beth Willis <<a href="mailto:willis@noblenet.org" target="_blank">willis@noblenet.org</a>> wrote:<o:p></o:p></p><p class=MsoNormal>Hi,<br><br>I have two questions for the list.<br><br>1) When I revise a template, often I cannot delete the original template because one or more of our libraries have created reports from it. In this case, the only way I know of to remove a template from our shared folders is to move it to a different, non-shared folder. In some cases I have revised a template more than once and have to move/store multiple versions of it because I cannot delete it. This results in a lot of obsolete templates being retained for no purpose. How are others handling this situation?<br><br>2) We generally ignore the Pivot Label Column and Pivot Data Column options when generating reports. I believe that these options relate to Excel, but I have only basic proficiency in Excel. Are others using these options? If so, can you provide one or two examples where selecting these options are useful?<br><br>Thank you.<span style='color:#888888'><br><span class=hoenzb>Beth</span><br><span class=hoenzb>-- </span><br><span class=hoenzb>Beth Willis</span><br><span class=hoenzb>Digital & Catalog Librarian</span><br><span class=hoenzb>NOBLE, Inc.</span><br><span class=hoenzb>26 Cherry Hill Drive</span><br><span class=hoenzb>Danvers, MA 01923</span><br><br><span class=hoenzb>_______________________________________________</span><br><span class=hoenzb>Evergreen-reports mailing list</span><br><span class=hoenzb><a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a></span><br><span class=hoenzb><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></span></span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>