{"id":3258,"date":"2018-08-24T19:21:49","date_gmt":"2018-08-25T00:21:49","guid":{"rendered":"https:\/\/powercode.com\/?p=3258"},"modified":"2018-08-24T19:21:49","modified_gmt":"2018-08-25T00:21:49","slug":"custom-reports","status":"publish","type":"post","link":"https:\/\/powercode.com\/old-wp\/2018\/08\/custom-reports\/","title":{"rendered":"Custom Reports"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-1\"><p>Despite having 77 pre-built reports, dashboards and other business intelligence metrics already available in the &#8216;Reports&#8217; tab, sometimes you just need more data. Luckily Powercode records nearly everything that happens in the system. So if you&#8217;ve ever caught yourself thinking &#8220;it would be great to see the data on this type of customer for this service with these characteristics&#8221; we can give that (or just about anything else you can think of) to you through our &#8216;Custom Reports&#8217; feature.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );margin-right: 4%;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><img decoding=\"async\" width=\"307\" height=\"482\" title=\"2018-08-24_16-26-57\" src=\"https:\/\/powercode.com\/wp-content\/uploads\/2018\/08\/2018-08-24_16-26-57.jpg\" alt class=\"img-responsive wp-image-3261\" srcset=\"https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_16-26-57-200x314.jpg 200w, https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_16-26-57.jpg 307w\" sizes=\"(max-width: 800px) 100vw, 307px\" \/><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last\" style=\"--awb-bg-size:cover;width:50%;width:calc(50% - ( ( 4% ) * 0.5 ) );\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-image-element fusion-image-align-center in-legacy-container\" style=\"text-align:center;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><div class=\"imageframe-align-center\"><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><img decoding=\"async\" width=\"611\" height=\"572\" title=\"2018-08-24_14-51-33\" src=\"https:\/\/powercode.com\/wp-content\/uploads\/2018\/08\/2018-08-24_14-51-33.jpg\" alt class=\"img-responsive wp-image-3262\" srcset=\"https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_14-51-33-200x187.jpg 200w, https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_14-51-33-400x374.jpg 400w, https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_14-51-33-600x562.jpg 600w, https:\/\/powercode.com\/old-wp\/wp-content\/uploads\/2018\/08\/2018-08-24_14-51-33.jpg 611w\" sizes=\"(max-width: 800px) 100vw, 600px\" \/><\/span><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-2\"><p>From the &#8220;Add New Custom Report&#8221; button at the top of the Custom Reports&#8217; header a MySQL query can be entered with the choice between a standard report or a report with an address range or date picker. Then anytime you or an employee need to access that data, just click on the report that was created.<\/p>\n<p>You&#8217;re welcome to write your own reports in MySQL or you can call or email support and we are happy to build the report you need for you!<\/p>\n<\/div><div class=\"fusion-video fusion-youtube fusion-aligncenter\" style=\"--awb-max-width:600px;--awb-max-height:360px;--awb-width:100%;\"><div class=\"video-shortcode\"><div class=\"fluid-width-video-wrapper\" style=\"padding-top:60%;\" ><iframe title=\"YouTube video player 1\" src=\"https:\/\/www.youtube.com\/embed\/Sp58nrW7D_8?wmode=transparent&autoplay=0\" width=\"600\" height=\"360\" allowfullscreen allow=\"autoplay; fullscreen\"><\/iframe><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/posts\/3258"}],"collection":[{"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/comments?post=3258"}],"version-history":[{"count":5,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/posts\/3258\/revisions"}],"predecessor-version":[{"id":3265,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/posts\/3258\/revisions\/3265"}],"wp:attachment":[{"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/media?parent=3258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/categories?post=3258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powercode.com\/old-wp\/wp-json\/wp\/v2\/tags?post=3258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}