<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- What is the Online Repository?</strong></p><p><strong>- Downloading Reports</strong></p><p><strong>- Downloading Data Sources</strong></p><p><br></p><p><br></p><p><strong>Related Guides:</strong></p><ul><li><a href="https://usehalo.com/haloitsm/guides/1563/" target="_blank" rel="noopener noreferrer"><strong>Report Builder</strong><br></a></li><li><a href="https://usehalo.com/haloitsm/guides/2375/" target="_blank" rel="noopener noreferrer"><strong>Report Data Sources</strong></a> </li><li style="font-weight: bold;"><a href="https://usehalo.com/haloitsm/guides/887/" target="_blank" rel="noopener noreferrer"><strong>Reports and Scheduling</strong></a></li></ul><p><br></p><p><strong><span style="font-size: 14pt;">What is the Online Repository?</span></strong></p><p>The Online Repository is Halo's built-in compilation of pre-made reports and data sources that are available for download and use within your own system.</p><p><br></p><p>Clicking into the reporting suite, and then the "Online Repository" section will bring you to the below screen. This allows you to browse and preview reports and data sources made by our team.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM2YjdiNzFjLWVjNWMtNGFhYi1hYzkyLWQxYmVhZGU0ODZhOCJ9.PPPTLTWWW4kdh1sQvpAb7yNWT6mxzEmSHnqNdx-Hp48" class="fr-fic fr-fil fr-dib" width="1227" style="width: 1229px; height: 580.842px;" height="581"></p><p><strong><span style="font-size: 10pt;">Fig 1. Online Repository screen. </span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Downloading Reports</span></strong></p><p>Reports can be downloaded from the Online Repository. Simply search what you are looking for, and if you know an SQL column you want to have included, you can search that as well.</p><p><br></p><p>Clicking on a report will preview it on the right side of the screen.</p><p><strong><em>Note: The report may appear empty or lacking content at first. This is because filters for only "Today" are often added to these by default so the preview loads quickly. This can be changed in the filter dropdown at the top.</em></strong></p><p><br></p><p>If you decide you want to download the report, click "Add this report to my library" at the top.</p><p><br></p><p id="isPasted">If downloading reports that are created with data sources, the data source will also download with the report.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQ1ODU5NWU1LWRiMTItNGY5Zi04NWNhLTAwYTMwMzkxZmJjYSJ9.EHs79T3oXhAK3i0iMZMzI-tCRltfBrNcHvTYmRLAG48" class="fr-fic fr-fil fr-dib" width="1227" style="width: 1229px; height: 579.56px;" height="580"></p><p><strong><span style="font-size: 10pt;">Fig 2. Downloading a report.</span></strong></p><p><br></p><p>The button will now change to "Update local version" and the report will show that is is "In Your Library".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImZkMWE4NDM2LTg0ZjgtNGNjMS05ZDFjLTRjOGQxMjVlNzIzYiJ9.oKpaxm8irngdlFfpUbMS2cqqkRa_zmqC0I3Stys05E8" class="fr-fic fr-fil fr-dib" width="1226" style="width: 1228px; height: 577.769px;" height="578"></p><p><strong><span style="font-size: 10pt;">Fig 3. Downloaded report.</span></strong></p><p><br></p><p>You can now go back to your "Reports" area to make use of your new report. The search field you used will stay, so the report will likely show up near the top.</p><p><br></p><p>Once you have clicked on it, you can treat this as you do any other report. You can adjust the filters, edit the SQL, create composite reports with it, etc. </p><p><br></p><p><em><strong>Note: Make sure to change the "Group" in the report details to wherever you want to store it.<br></strong></em></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZjOGJlNzIzLTgwMDktNDNlMC05ZDRmLWVkMmViOGIyYjg5MSJ9.zzhgh4KQmcag8mSb2vxQPL4T1VwmG1-WQt9lB_Bk5qE" class="fr-fic fr-fil fr-dib" width="1225" style="width: 1227px; height: 579.221px;" height="579"></p><p><strong><span style="font-size: 10pt;">Fig 4. Downloaded report in Reports area.</span></strong></p><p><br></p><p>Editing the report can also allow you to adjust the SQL to your liking.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjY4MDI1NTE1LTI1ODUtNDBmOS1hM2UwLTNmZTYyMjU0Mzc1NSJ9.hne8mGjU7rinQhy9PbWkvzlwtkvM5XoajpYAKmpa20I" class="fr-fic fr-fil fr-dib" width="1225" style="width: 1227px; height: 577.977px;" height="578"></p><p><strong><span style="font-size: 10pt;">Fig 5. SQL of the downloaded report.</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Downloading Data Sources</span></strong></p><p>The Online Repository also has data sources available for download. Data sources are pre-made reports that can be used as the data source of a report, and allows fields to be added based on them, similar to the query builder/report builder.</p><p><br></p><p>Data sources can be saved the same way as reports.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjYxMjk3OGRkLTYyODQtNDBhZS1iZGQzLWJiOThhZGRkMTY0YyJ9.wRk8SghCB2ToDBnx2f8NWBh0gn8Dp_vWlfZ0TS_3dIM" class="fr-fic fr-fil fr-dib" width="1227" style="width: 1229px; height: 579.56px;" height="580"></p><p><strong><span style="font-size: 10pt;">Fig 6. Downloading a data source.</span></strong></p><p><br></p><p>You can then go back to the reports area and create a "New" report.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc2NTc0NTgzLTdkNzYtNGY1NS1iNWYwLTVmNjcxN2MzOTkzNiJ9.3MU_bdnVQ5rlJt-BTuyTWlzr-2DljNzjEJn2975r0p8" class="fr-fic fr-fil fr-dib" width="1227" style="width: 1229px; height: 579.413px;" height="579"></p><p><strong><span style="font-size: 10pt;">Fig 7. Creating a new report.</span></strong></p><p><br></p><p>In the "Data Source" tab of the new report, the downloaded data sources will appear at the top of the corresponding dropdown. For more information on the full process of making reports with a data source, check out the guide linked at the top.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE5NmU1ODEzLWI4N2QtNDE5ZC05OGE5LTlmNmRhNzk3M2Y3NiJ9.RoPT12LlUuXKjbM9okErGKd7zolNcBWKqC_iBXSG7sM" class="fr-fic fr-fil fr-dib" width="1227" style="width: 1229px; height: 579.523px;" height="580"></p><p><strong><span style="font-size: 10pt;">Fig 8. Selecting the downloaded data source.</span></strong></p>
