{"id":11739,"date":"2016-01-18T12:51:01","date_gmt":"2016-01-18T12:51:01","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11739"},"modified":"2016-01-18T12:51:01","modified_gmt":"2016-01-18T12:51:01","slug":"report-category-access-to-particular-users-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/","title":{"rendered":"Report Category Access to particular users in Sage CRM"},"content":{"rendered":"

Reporting is very essential in any business process as it gives clear picture of ongoing work in an efficient manner. Sage CRM also provides Reporting feature and security structure.
\nNew Stuff:<\/em><\/strong><\/span> Sage CRM and Sage 300 ERP Integration Part-3<\/a>
\nIn Report section, you can see many Reports Category are available and each Report Category will have many reports into it. Few days back, Management Team ask to create new Report Category Management Report and that Report Category should be available only for Management Team User and other few users.
\nThis can be implemented by a simple trick. Below are the steps that you need to follow to provide access to selected Sage CRM users.
\n1) Navigate to Administration | Customization | Users entity.
\n
\n<\/a> \"R1\"<\/a>
\n2)\u00a0Create a new field with field type checkbox as ‘user_reportaccess’.
\n\"R2\"<\/a>
\n3)\u00a0Navigate to Screens tab and add this field on UserAdminExtraBox screen as shown below.
\n\"R3\"<\/a>
\n4)\u00a0Navigate to Users to which you wanted to display Management Reports and select the Report Access checkbox for them as shown below.
\n\"R4\"<\/a>
\n5)\u00a0Now, navigate to Advance Customization | System Menu and click on pencil icon of ReportsTabGroup.
\n\"R5\"<\/a>
\n6)\u00a0Select Management Reports Category and add below SQL condition in the SQL section\u00a0of Properties section.
\nuser_reportaccess =’Y’
\n\"R6\"<\/a><\/span>
\n7) Click on Update button and then click on Save.<\/strong>
\nNow Login to Sage CRM with any user for which Report Access checkbox is not checked and you will observe that Management Reports category will not be visible. However same will be visible for user for which Report Access category is checked at user level.
\nAlso Read:<\/em><\/strong><\/span>
\n<\/em><\/strong>1) View Sage CRM Reports in PDF format from any Sage CRM screen<\/a>
\n<\/u>2) Include your Company Logo in Sage CRM Reports<\/a>
\n<\/u>3) Forecasting \u2013 Reports to field in CRM<\/a>
\n<\/u>4) How to add the Mobile Phone and Private Phone fields to the views being used by Find screens, Reports and Groups<\/a>
\n<\/u>5) Access Rights to create new Reports in Sage CRM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Reporting is very essential in any business process as it gives clear picture of ongoing work in an efficient manner. Sage CRM also provides Reporting feature and security structure. New Stuff: Sage CRM and Sage 300 ERP Integration Part-3 In Report section, you can see many Reports Category are available and each Report Category will\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,83,317,318,332,336,337,338,342,417],"tags":[487,793,833,1920,2010,2030,2031,2033,2035,2140,2524],"class_list":["post-11739","post","type-post","status-publish","format-standard","hentry","category-access","category-crm72","category-report","category-reports-to","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm-73","category-sage-crm7-3","category-user","tag-access","tag-crm","tag-crm7-0","tag-report","tag-sage-crm","tag-sage-crm-7-0","tag-sage-crm-7-1","tag-sage-crm-7-2","tag-sage-crm-7-3","tag-sage-crm-com","tag-user"],"yoast_head":"\nReport Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Report Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Reporting is very essential in any business process as it gives clear picture of ongoing work in an efficient manner. Sage CRM also provides Reporting feature and security structure. New Stuff: Sage CRM and Sage 300 ERP Integration Part-3 In Report section, you can see many Reports Category are available and each Report Category will\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-18T12:51:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/\",\"name\":\"Report Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg\",\"datePublished\":\"2016-01-18T12:51:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Report Category Access to particular users in Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Report Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Report Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Reporting is very essential in any business process as it gives clear picture of ongoing work in an efficient manner. Sage CRM also provides Reporting feature and security structure. New Stuff: Sage CRM and Sage 300 ERP Integration Part-3 In Report section, you can see many Reports Category are available and each Report Category will\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-01-18T12:51:01+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/","name":"Report Category Access to particular users in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg","datePublished":"2016-01-18T12:51:01+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/R1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/18\/report-category-access-to-particular-users-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Report Category Access to particular users in Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=11739"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11739\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}